jasperreports autofilter multiple columns

0

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. 

 

xmaster88's picture
Joined: Sep 12 2014 - 12:09am
Last seen: 5 years 2 months ago

DEL

xmaster88 - 5 years 2 months ago

1 Answer:

0

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.

xmaster88's picture
Joined: Sep 12 2014 - 12:09am
Last seen: 5 years 2 months ago
Feedback