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"/>[/code] But it is not working . Also tried with pattern="@" and pattern="0.00" but none of them works. JasperReports version used 5.6.1 and org.grails.plugins:jasper 1.11.0
