Jasper Report - freeze panes and Autofilter in xlsx file.

[zajicek.marek]

Hi,

I created report with *.xls output format with freeze panes and autofilter. All worked correctly. After that I found out that I need more rows (xls has 65000 only) so I decided to use xlsx exporter. Xlsx report was generated but freeze panes and autofilter doesn't work. I used JR version 5.6.1. Where is problem please?

 

Thank you very much.

[maxime.belanger]

I have a similar problem:

<property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Bottom"/> used to work when I exported to xls but not

; <property name="net.sf.jasperreports.export.xls.auto.filter" value="Start"/>

Now that I export to xlsx, using JRXlsxExporter, AutoFilter works properly, but my top row does not freeze anymore.

 

Any ideas?

Thanks