XLSX EXPORT Problem
A client of mine pointed out to me that export XLSX suffers from a strange bug.
If data is formatted as a number with decimals, then the number appears in Excel multiplied by 10 raised to the number of decimal places used.
Eg: format =% 0.2f then the number is multiplied by 100!
If I remove the number formatting and put format as text then it works!
Any idea?
The program is compiled with Delphi XE3, FastReport 5.4
thanks
Lorenzo
If data is formatted as a number with decimals, then the number appears in Excel multiplied by 10 raised to the number of decimal places used.
Eg: format =% 0.2f then the number is multiplied by 100!
If I remove the number formatting and put format as text then it works!
Any idea?
The program is compiled with Delphi XE3, FastReport 5.4
thanks
Lorenzo
Comments
Usually I install only the "release" versions so I will wait for the next!
Thanks so much for the information!