Excel Reports store "Number as Text"

[omb]

Hi,

 

I am using JavaBeanDataSource to populate reports. The field values are defined as java.math.BigDecimal types in .jrxml files. Corresponding bean methods return BigDecimal values to populate the report. I see that xls file contain "Number as text" warning instead of these BigDecimal fields stored as numerical values.

 

I saw an earlier thread that recommended using JExcelApi instead of POI to export to XLS file. I have tried both the libraries with same result.

 

Appreciate any help in this regard.

 

Thanks.

[lucianc]

Which JasperReports version are you using? Do you set the IS_DETECT_CELL_TYPE flag to true?

 

If this happens when IS_DETECT_CELL_TYPE is set, please include more information (e.g. JRXML template, XLS output, etc).

 

Regards,

Lucian

[omb]

Thanks, setting the IS_DETECT_CELL_TYPE fixed the XLS output.