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"/>
Tips and Tutorials
Jasper iReport Property To Format Numbers properly in Excel Print
1 min read
