JasperReports Server does not insert page breaks in XLSX while Studio does

[hozawa]

I'm having a problem with JasperReports Server 5.6.1 (and other versions too) with inserting page breaks when I export to xlsx.

Page breaks works as expected on web pages and on Jaspersoft Studio (in xlsx format), but JasperReports Server does not.

Has anybody else experienced this problem? It's kind of strange that JasperReports Server does not work in a similar fashion as Jaspersoft Reports.

[hozawa]

This is caused by differences in default values. Setting properties resolved the problem.

Resolved by adding the following properties in the report:

<property name="net.sf.jasperreports.export.xls.collapse.row.span" value="false"/> <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="false"/>[/code]

There's a bug in JasperReports 5.2 which seems to ignore these properties so be sure use 5.6.x or above.