JasperReports: How to format numeric data with Excel exporter

jasper-reports export-to-excel number-formatting ireport
Naim Nsco picture Naim Nsco · May 23, 2012 · Viewed 13.3k times · Source

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).

Answer

Naim Nsco picture Naim Nsco · May 23, 2012

We can use net.sf.jasperreports.export.xls.detect.cell.type property for solving issue.

The quote from documentation:

net.sf.jasperreports.export.xls.detect.cell.type

Property whose value is used as default state of the IS_DETECT_CELL_TYPE export flag.

Specifies whether the exporter should take into consideration the type of the original text field expressions and set the cell types and values accordingly.

For example we can set this property for the whole report:

<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" ...>
    <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>

Related questions

How to show each subreport in a separate Excel sheet

I would like to create a report with iReport for MS Excel. My report includes two subreports. I need each subreport in a separate Excel sheet, but the generated export file has all data in one sheet. I don't know …

Read More
Font is not available to the JVM with Jasper Reports

I'm trying to generate report with DynamicJasper, but I'm getting the following error: net.sf.jasperreports.engine.util.JRFontNotFoundException: Font 'Arial' is not available to the JVM. msttcorefonts is installed, but I guess the JVM is not using any fonts …

Read More
How do I compile jrxml to get jasper?

I have jrxml file, I want to compile this to get .jasper. How do I compile and get that jasper file?

Read More