lotion46 Posted July 22, 2009 Share Posted July 22, 2009 Dear all,I'm looking for a option how to set the Autofilter in Excel. We provide our reports via a web application based on Websphere 6. For our users it would be great if this filter is already set since we have some reports with many worksheets within one workbook.In Excel produced XML it's quiet easy but how to tell iReport or Jasper: </WorksheetOptions> <AutoFilter x:Range="R1C1:R1C2" xmlns="urn:schemas-microsoft-com:office:excel"> </AutoFilter> Has anybody an idea or is impossible? Post Edited by lotion46 at 07/22/2009 15:15 Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted July 22, 2009 Share Posted July 22, 2009 An XLSX exporter is currenly under development.How this AutoFilter is supposed to work?Giulio Link to comment Share on other sites More sharing options...
lotion46 Posted July 23, 2009 Author Share Posted July 23, 2009 Nothing special. Just display the filter so the report is fully prepared to work with. Otherwise everybody who is using the report have to display the filter for every page on his own. A pre-definition of the filter is not necessary in this case. (see attachment)Also nice would be a similar function to fix the header (simple excel function) 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