Jump to content
JasperReports Library 7.0 is now available ×

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

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...