Results 1 to 10 of 21

Thread: Excel-values can not been calcuated

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #20
    Join Date
    Feb 2009
    Location
    Hengelo, Netherlands
    Posts
    8,301

    Default Re: Excel-values can not been calcuated

    Anders,

    Excel export has 2 options:
    1. Data only (is like CSV but directly in Excel format)
    2. Format as in report (field properties or (new in v6.2) the FormatNumber etc functions. Excel sees strings and can get confused.

    Since v6.2 there is a new feature called Native format. No formatting from DataFlex Reports. It is limited to numeric values.

    Export to Excel uses LibXL and whatever it uses for native format is what DataFlex Reports offers
    Last edited by Vincent Oorsprong; 8-Feb-2019 at 07:51 AM. Reason: There are not 3 but 2 options and Native format can be applied to both
    Regards,
    Data Access Worldwide
    Vincent Oorsprong

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •