how to export "excel compatible" CSV from jasperserver

[florent.j]

Hi,

I'm trying to export a report as CSV that should be openable in Excel.

Right now, excel requires the byte order mark (BOM) to be written in order to recognize UTF-8 files.

I tried using the property net.sf.jasperreports.export.csv.write.bom described here. It works when I do the export from jaspersoft studio but seems to be ignored when I do it from the server. Am I missing something? Is there another point where this should be changed?

Thanks,

Florent

 

Edit to precise: We are using 6.0.1 as 6.1.0 has a blocking bug and we couldn't test 6.1.1 yet. Is this issue really resolved on 6.1?

[hozawa]

I just made the modification to WEB-INF/classes/jasperreports.properties and restarted the system. Also, check JasperReports Server version to make sure it's 6.1.0 or above.