Jasper Report - freeze panes and Autofilter in xlsx file.


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.

zajicek.marek's picture
Joined: Jan 22 2015 - 11:19pm
Last seen: 7 years 7 months ago

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?


maxime.belanger - 7 years 6 months ago

0 Answers:

No answers yet