JasperReports: How to format numeric data with Excel exporter

[briana_01_gonzales]

I'm using version 6.5. I have a problem with formatting numeric data after generating report with help of Excel exporter. 

add the following to my jrxml file a report properties section but it does not work:

<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>

And my code set property:  xlsReportConfiguration.setDetectCellType(true);

 

help me!!!

[mlopez_1]

I have no problem with excel exporter, but yes with ods exporter.

My fields are BigDecimal and exports like cells numbers right.

Working wiht JSS 6.5.1 and JasperServer 6.4.2

Mariano