Empty cell in Excel when overflow


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?
pashab's picture
Joined: Nov 3 2014 - 12:12pm
Last seen: 8 years 9 months ago

2 Answers:

try the following:




net.sf.jasperreports.export.xls.remove.empty.space.between.rows = true


net.sf.jasperreports.export.xls.remove.empty.space.between.columns = true

darth_fader's picture
Joined: Mar 7 2010 - 9:45pm
Last seen: 3 months 2 weeks ago

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

pashab - 8 years 9 months ago

This is what I get:

http://c2n.me/39cbljj - link to screenshot

Does anybody know to solve this issue, please help?

pashab's picture
Joined: Nov 3 2014 - 12:12pm
Last seen: 8 years 9 months ago

On the Detail properties, set the Split Type to 'Prevent'. On the field properties, set Stretch Type to 'No stretch'.

janiesprenger - 8 years 6 months ago