Excel text and number formatting (FlexReport)

Posted by: mradcke on 21 October 2018, 9:28 pm EST

    • Post Options:
    • Link

    Posted 21 October 2018, 9:28 pm EST

    We’ve got two problems with FlexReport generating Excel workbooks:

    • “One Excel column is filled with a variable which should be interpreted as text by Excel, but it can contain number-like values such as “1.2”. It should be displayed as “1.2” but is actually shown as “1.20”, or even “1,20” depending on regional settings. Can we add the Excel formula TEXT() around the value using FlexReportDesigner, or are there other alternatives? Using CStr or other functions did not work.”

    • “For other Excel columns, we want to control the number format, i.e. use 1 or 4 decumals. How can we control that in FlexReportDesigner? Using Format(myvariable, N4) in the Text field did not work out, likewise using N4 in the Format field.”

    Thank you,

    Marina

  • Posted 22 October 2018, 10:54 pm EST

    Hello Marina,

    I am discussing these requirements with the development team [Internal Tracking ID: 349615] and will get back to you once it is done.

    Best Regards,

    Esha

  • Posted 30 October 2019, 7:28 pm EST

    Hello Marina,

    1. This is by-design. The values are generated by default, if nthe Format property of the field is not set. For any text field, set format as “#,##0.##”, for example.

      In such case, automatic detection of format does not work.

    2. The exported excel now contains numbers such that the decimal places are retained. You can check the same by updating your installed version using C1Live or ControlPanel.

    Regards,

    Esha

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels