Issue:
[toc on_off::hide=1]
If the Excel export layout does not align correctly, you can try changing the default properties.
The default properties are set to a more data centric view.
Resolution:
Try these properties for a more layout centric Excel export of a report.
<property name="net.sf.jasperreports.export.xls.collapse.row.span" value="false"></property>
<property name="net.sf.jasperreports.export.xls.create.custom.palette" value="true"></property>
<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"></property>
<property name="net.sf.jasperreports.export.xls.font.size.fix.enabled" value="true"></property>
<property name="net.sf.jasperreports.export.xls.ignore.cell.background" value="false"></property>
<property name="net.sf.jasperreports.export.xls.ignore.cell.border" value="false"></property>
<property name="net.sf.jasperreports.export.xls.ignore.graphics" value="false"></property>
<property name="net.sf.jasperreports.export.xls.image.border.fix.enabled" value="true"></property>
<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="false"></property>
<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="false"></property>
<property name="net.sf.jasperreports.export.xls.white.page.background" value="true"> </property>
Ref. Case #00020803 -- 14:15, 1 September 2011 (UTC)
Recommended Comments
There are no comments to display.