Excel Export Currency Column Issue

[pjacobsma_1]

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.

[davidfritch]

I found this answer on Stack Overflow https://stackoverflow.com/a/69773797/3761102

To restate it here

In your Field Expression use 

NumberFormat.getCurrencyInstance($P{REPORT_LOCALE}).format($F{currency_value}).