Percentage pattern in excel / xls format

Issue:

We have a report that has a percentage value  in it.  The html result looks like 37% which is correct.  The Excel (xls) output looks like .4.  How do I make the Excel (xls) export format correctly show percentages?

Resolution:

The cause if this issue is that iReport uses a xls different exporter which has no problems with the patterns defined by the user. In JasperReports Server, an additional property is required:

net.sf.jasperreports.export.jxl.cell.complex.format = true

Add this property to the report and the defined pattern will be used. This can be done in iReport by right clicking on the report > Properties > click on the 'edit' button next to 'Properties' > Click 'Add' > and set:

Property Name: net.sf.jasperreports.export.jxl.cell.complex.format Property Value: true

More information about this property can be found here:

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.jxl.cell.complex.format

Ref. Case #00022133 -- 21:40, 16 March 2012 (UTC)