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