After a report which has columns using net.sf.jasperreports.export.xls.auto.filter property is exported in XLSX format, and if you try to sort it using applied filter then MS Excel crashes. In case exporting to xls format (Excel 97) it works fine.
Only if you do any other filtering operation first, then you can sort it without crashing.
Please help to resolve this problem?
2 Answers:
Similar ticket exist, and nobody answered for it. Ticket #2679 posted on January 18, 2013.
I need to know is this a bug in jasper report engine or i just doing something wrong? Is someone met this problem?
Problem here because autofilter was seting for entire column. I mean for range from A5 till A1048576(limit of the Excel 2010) cells, but data is only in range A5-A11. After doing some filtering action, filter range changes to A5-A11 and sorting works fine. But problem remains, if use sorting immedeately. How to teach jasper report seting up autofilter only for cells with data?!
