[#13781] - Excel Export: Faulty interaction between New Sheet and Auto Filter

Category:
Bug report
Priority:
Normal
Status:
New
Project: Severity:
Minor
Resolution:
Open
Component: Reproducibility:
N/A
Assigned to:
0

When using the properties
net.sf.jasperreports.export.xls.break.before.row
net.sf.jasperreports.export.xls.auto.filter

both in the group header of a table, the excel export correctly prints eacht group on it's own sheet.
The Filter is only active in the last sheet though.

Attached you can find a simple report illustrating this behaviour.
I tested it with Jaspersoft Studio 6.17.0.

I run it with the folling data:
Line Group Value
1 1 A
2 1 B
3 1 A
4 2 B
5 2 A
6 2 B
7 3 A
8 3 B

JRXLSExporter
johannes.hafner's picture
Joined: Aug 16 2021 - 12:19am
Last seen: 1 month 2 days ago

1 Comment:

#1
AttachmentSize
Binary Data testfilter.jrxml7.08 KB
Feedback
randomness