I have created a Jrxml to generate an excel output. The textfield of data type "String" in iReport is displayed with cell format as 'General' in the generated excel output.<br><br>
When Number is greater than 12 digit it turns into scientific notation. eg 999999999869 turns to 1E+12.
I need cell format to be either 'text' or 'number'.
I have tried with property
<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
No answers yet