https://bz.apache.org/bugzilla/show_bug.cgi?id=60724
Bug ID: 60724
Summary: SUBTOTAL() function doesn't skip auto-filtered rows
Product: POI
Version: 3.16-dev
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Per the Excel documentation:
https://support.office.com/en-us/article/SUBTOTAL-function-7b027003-f060-4ade-9040-e478765b9939
In the "Remarks" section, both the all rows and "ignore hidden rows" versions
of the totals functions should ignore all rows hidden by an auto-filter. POI
isn't doing that yet.
I see this empirically, with the additional behavior that if you manually hide
a row that passes an auto-filter, it is also ignored by BOTH versions of the
formula methods.
I don't even know where to start looking to figure out if a row is hidden or
not in the formula evaluation flow. It will require investigating whether there
are TwoDEvals in the operands we can use or if the Ptg array has anything we
can use to look back at the row properties for a cell value, or if this needs
to be handled at a higher level somewhere.
One of the sheets in a new test workbook I'm building for conditional
formatting has this case as well, discovered by accident. Once I check that
in, I'll point to it here as a test case that can be used to verify a fix.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
