Jasper CSV export: decimals in german format with , instead of .

[bmservices]

Hi together,

is it possible to change the decimal separator in Jasper CSV export?

I need decimals formatted like this:

1,2345 instead of 1.2345

Otherwise Excel will misinterpret the CSV after opening with doubl click.
Especially f.e. 3.5 becomes 3. Mai!

I searched here: http://jasperreports.sourceforge.net/config.reference.html
but did not find anything useful here: net.sf.jasperreports.export.csv.*

Thx for tips, Bernd

PS: xlsx/xls export is not possible... too much data :-(

 

 

[hozawa]

Not sure but have you tried setting the following property?

net.sf.jasperreports.csv.field.delimiter

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.csv.field.delimiter

[bmservices]

Sorry hozawa, field delimiter is not correct. This is the delimiter between the columns. I want to change the decimal separator from "." to ",".

[riodavid]

The internal function SUBSTITUTE works for me.

SUBSTITUTE($V{A_DECIMAL_NUMBER}.toString(),".",",")