I'm using iReport 2.0.2.
I have a problem with formatting numeric data after generating report with help of Excel exporter.
For example, the 85110057689
string is showing as 8.51100e+10
in Excel file (as result of using "preview in Excel" button in iReport).
Please suggest how to change the format to the simple (not scientific).
Best Answer
We can use net.sf.jasperreports.export.xls.detect.cell.type property for solving issue.
The quote from documentation:
For example we can set this property for the whole report: