Jasper Report - freeze panes and Autofilter in xlsx file.

2

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.

zajicek.marek's picture
Joined: Jan 22 2015 - 11:19pm
Last seen: 4 years 5 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?

Thanks

maxime.belanger - 4 years 3 months ago

0 Answers:

No answers yet
Feedback
randomness