marunchuk Posted July 27, 2014 Share Posted July 27, 2014 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? Link to comment Share on other sites More sharing options...
hozawa Posted July 27, 2014 Share Posted July 27, 2014 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. Link to comment Share on other sites More sharing options...
marunchuk Posted July 28, 2014 Author Share Posted July 28, 2014 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?! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now