Incorrect currency symbol in xlsx export

Issue Description:

When report created in studio and deployed on Jasper server. It shows currency symbol ($) correctly on the report but when export this in xlsx it does not show correctly.

Resolution

Please edit the file applicationContext.xml under the directory ...webappsjasperserver-proWEB-INF and locate the bean "xlsExportParameters".

1) Change the value of detectCellType from "true" to "false"

2) Clear temp and work folder of tomcat and restart JasperServer.

The "$" sign should then appear properly in the xlsx export.

--------------------------------------

Hope this helps..