One field that is 2 rows tall becomes 2 rows when exporting to Excel on TIBCO JasperReports® Server but works fine in TIBCO Jaspersoft® Studio

Problem Description:

You have successfully added to a report a text field that is as tall as 2 fields stacked together right next to it in TIBCO Jaspersoft^® Studio.  The fields are displayed exactly when running the report on TIBCO JasperReports^® Server.  However, when exporting to Excel, the first field is split into 2 Excel rows just like the 2 fields right next to it.

Solution:

Add the following to the jrxml file where all the properties are in the beginning of the jrxml file,

<property name="net.sf.jasperreports.export.xls.collapse.row.span" value="false"/>

This setting is for the report only.   If you add the following to WEB-INF/classes/jasperreports.properties file, restart jasperserver, it should work for all reports when export to Excel.

net.sf.jasperreports.export.xls.collapse.row.span=false

This setting is in the default properties [Window->Preferences->Jaspersoft Studio->Properties->Jasper Reports Properties] in Jaspersoft Studio.  That is why it works when exporting from Jaspersoft Studio and not on jasperserver.