Empty cell in Excel when overflow

[pashab]

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?

[darth_fader]

try the following:

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.remove.empty.space.between.rows

 

 

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

 

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

[pashab]

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]

This is what I get:

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

Does anybody know to solve this issue, please help?

[janiesprenger]

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