jasper-reportsexport-to-excel

Jasper report Excel row height


I need help with Jasper reports. In XLS when content doesn't fit the row width the row height increases. But at the top and the bottom in some rows content is cut off. I've tried properties:

But there was no effect. Can anybody know the solution? I use Jasper report 6.20.5


Solution

  • try to add the property <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> in the reportElement section and in the paragraph section add <paragraph lineSpacing="1_1_2"/>, don't forget add in the textField textAdjust = 'StretchHeight'