Export to Excel format: cell type “general” and number turn into scientific notation

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"/>

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

nishigandhalole's picture
Joined: May 6 2018 - 10:48pm
Last seen: 4 years 10 months ago

0 Answers:

No answers yet
Feedback
randomness