Jasper Export XLS Multiline textfields

0
votes

I have a problem with export report in excel. I 'm using an Ireport. I'm trying to print multiline text in textfield

(TextField parameters : Height=20, Font=Arial, Font Size=10).

I set the Positition Type = Float and Stretch type= Relative to Band Height. Аnd I got this result: enter image description here

The last line is eating. Im 'trying to set the property Stretch With Overflow=true. I got the same result. What I'm doing wrong.

1
jasper-reportsireport
Are you getting same problem in pdf. – user1791574
@user1791574 Not there are no problem in pdf, no problem when I print xls file. I have this problem only in xls file. And I don't understand how to solve it. – Fantomas
Have you tried Stretch type= Relative to tallest object for this. – user1791574
@user1791574 Yes I tried. But it is not works – Fantomas

1 Answers

1
votes

Try adding bottom padding or spacing after on that cell. You can also try disabling collapse row span property on the report, it solves some excel layout problems: