Empty cell in Excel when overflow
Posted on December 14, 2014 at 11:26am
When I am trying to export report to xls format I get empty cells, if textfield value overflow.
I set textfiled property stretch with overflow to the true and added these properties to report:
<property name="net.sf.jasperreports.print.keep.full.text" value="true"/>
<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
<property name="net.sf.jasperreports.export.xls.wrap.text" value="false"/>
<property name="net.sf.jasperreports.export.xls.auto.fit.row" value="true"/>
<property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/>
But it doesn't help!
Does anybody know how to solve this issue?
Posted on December 15, 2014 at 4:45pm
Posted on December 21, 2014 at 10:19am
This is what I get:
http://c2n.me/39cbljj - link to screenshot
Does anybody know to solve this issue, please help?