Export markup html fields to csv, character encoding - Jasper

Question

I have text field in Jasper report jrxml template marked as html. This property removes any HTML tags from text and it works fine as html export, as pdf, excel...etc.

Only issue is csv export. It shows strange characters on tags positions.

Changing default encoding from 'UTF-8' to 'ISO-8859-1' did not give results.

<property name="net.sf.jasperreports.export.character.encoding" value="ISO-8859-1"/>

Anyone knows solution?

Thanks

Answer 1

This solved issue

<property name="net.sf.jasperreports.export.csv.write.bom" value="true"/>