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:
net.sf.jasperreports.export.xls.auto.fit.row
net.sf.jasperreports.export.xls.auto.fit.column
net.sf.jasperreports.print.keep.full.text
But there was no effect. Can anybody know the solution? I use Jasper report 6.20.5
I found another solution. According to https://github.com/Jaspersoft/jasperreports/issues/245 in Excel export isn't as perfect as in PDF.
One of the solutions is use the property net.sf.jasperreports.export.xls.font.size.fix.enabled
.