Export to Excel dropping numeric sign
Good Morning,
I'm trying to export a FastReport to Excel using v4.12. For whatever reason, all negative values in the report (and in the underlying Oracle Data) will only come over to excel as positive values. As I'm sure you can imagine, this causes issues for report users when they try to sum numbers in the excel report.
The interesting part is that conditional red font color if value < 0 comes over properly. At first I thought this was an issue with a particular fr3 file, but I'm experiencing this across all fr3 files that I use. I haven't experienced this issue in previous versions of FastReport with these same fr3 files that haven't changed in over a year.
The only workaround I have come up with at this point is to manually edit the excel file after it is generated which isn't really a viable option for a production environment.
A second issue I'm running into is that the currency number formatting is also not coming over to excel properly, even though it is displayed properly in the FastReport.
Are these bugs in v4.12? Has anyone figured out how to get around this?
Thanks in advance for any assistance in resolving this issue.
I'm trying to export a FastReport to Excel using v4.12. For whatever reason, all negative values in the report (and in the underlying Oracle Data) will only come over to excel as positive values. As I'm sure you can imagine, this causes issues for report users when they try to sum numbers in the excel report.
The interesting part is that conditional red font color if value < 0 comes over properly. At first I thought this was an issue with a particular fr3 file, but I'm experiencing this across all fr3 files that I use. I haven't experienced this issue in previous versions of FastReport with these same fr3 files that haven't changed in over a year.
The only workaround I have come up with at this point is to manually edit the excel file after it is generated which isn't really a viable option for a production environment.
A second issue I'm running into is that the currency number formatting is also not coming over to excel properly, even though it is displayed properly in the FastReport.
Are these bugs in v4.12? Has anyone figured out how to get around this?
Thanks in advance for any assistance in resolving this issue.