Hi,
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?
2 Answers:
Posted on December 15, 2014 at 4:45pm
try the following:
http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasper...
net.sf.jasperreports.export.xls.remove.empty.space.between.rows = true
net.sf.jasperreports.export.xls.remove.empty.space.between.columns = true
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?
Hi gertbeedfrobe,
Thanks for your response.
But it is not exactly that I mean
I have problem during the export to excel when textfiled have big word, that does not fit within the boundaries of the field. Then this value is losted and is not contained in cell.
Does jasperreports have some settings for hyphenation?
In HTML it also doesn't work as I expected:
the field stretches horizontally and pushes the columns on the right, over another fields