Jasper iReport Property To Format Numbers properly in Excel Print


Ashvin Gami

2023-09-13 11:42:12


For excel to automatically detect what type of format the cell should be, add the following to your jrxml file at the top in the report properties section:

<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
 

More details here