Autofilter is not working when the property “xls.break.before.row” is set

[shuhovivan]

I need that the report could be exported to excel format with the autofilter and a crossbar on separate sheet. So for that purpose i set a "Break Before" property on one of the cells in first row in a crosstab. Works great - crosstab moves to separate sheet, but autofilter dissapears.

I use the following properties to place crosstab on the separate sheet:

<property name="net.sf.jasperreports.export.xls.break.before.row" value="true"/><property name="net.sf.jasperreports.export.xls.sheet.name" value="Summary"/>[/code]