Locale not considered when exporting to Excel

[ktrinad]

By: josep - josepse

Locale not considered when exporting to Excel

2004-05-13 00:48

Hi,

 

When exporting a number to Excel the code expects the "." as a decimal separator and doesn't treat de grouping separator.

 

My locale has "," as decimal separator and "." as grouping separator. Here is a possible modification to update this bug:

 

protected void exportText(JRPrintText text, JRExporterGridCell gridCell, int x, int y)

{

....

if (isAutoDetectCellType)

{

try

{

java.text.DecimalFormat dec = new java.text.DecimalFormat();

java.text.ParsePosition pos = new java.text.ParsePosition(0);

Number num = dec.parse(text.getText().trim(), pos);

if (pos.getIndex() != text.getText().trim().length())

cell.setCellValue(text.getText());

else

cell.setCellValue(num.doubleValue());

}

catch(Exception e)

{

cell.setCellValue(text.getText());

}

}

...

}