xmaster88 Posted September 12, 2014 Share Posted September 12, 2014 Hey guys. I'm having a problem, when trying to make autofilter for multiple columns. The example XlsFeaturesReport.jrxml contains only one autofilter. If I write fields with autofilter, then the last autofilter is applied. I set autofilter with property "net.sf.jasperreports.export.xls.auto.filter" applied on a column header. The original Excel does support many lines of autofilter. Is there any way to make it with jasperreport? Also I've frozen the header. When use JrxlsExporter it works, but when use JrxlsxExporter frozen doesn't work. I'm using latest version of jasperreports. Link to comment Share on other sites More sharing options...
xmaster88 Posted September 17, 2014 Author Share Posted September 17, 2014 The solution was simple:autofilter works this way Start _ _ _ _ _ _ _ _ _ End So instead of placing everywhere Start, you should mark rows with markers. It is logical. Frozen feature fixed by option net.sf.jasperreports.export.xls.freeze.row = 4The last thing I cannot solve is adding original cell borders of excel. Tried this one but it doesnt work. Added and removed in ReportConfiguration, in report properties. Link to comment Share on other sites More sharing options...
xmaster88 Posted September 17, 2014 Author Share Posted September 17, 2014 DEL 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