Excel Export Currency Column Issue


I am having a problem with currency fields in an Excel export.  I have the following pattern in my Jasper report for the currency field:  ¤#,##0.##   I am using the REPORT_LOCALE parameter to tell Jasper to use locale to format the currency field, and I use the setDetectCellType(true) option in the JRXlsxExporter configuration.  But when I open the Excel spreadsheet, the column values display like this:  ¤2,722.48.

I am using the jasperreports-6.18.1 jar.

pjacobsma_1's picture
Joined: Jul 17 2019 - 6:35pm
Last seen: 2 weeks 4 days ago

0 Answers:

No answers yet