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.
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 = 4
The 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.