MS Excel crashes after applying sorting
Posted on July 27, 2014 at 1:23pm
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?
Posted on July 27, 2014 at 3:30pm
Posting to a wrong place. This is just a forum. If you want to file a bug report, create a new bug report at Tracker.
Posted on July 28, 2014 at 12:03am
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?!