Excel cell with numeric data formatted as text

[steph_tls]

Hi,

I running a query with numeric data and when the data are displayed in the excel file it shows as text.

I have checked the data in the query and the data are numeric.

I have add this property in the jrxml file but it doesn't change anything.

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

any idea ?

 

[luca.pocchione666]

 Try to insert in the field editor this: Float.valueOf($F{your_field})