-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: ODF 1.2
-
Component/s: OpenFormula
-
Labels:None
-
Proposal:
One of the primary reasons for having a SUBTOTAL function is the special behavior of ignoring hidden rows and other subtotal functions within the input range. Also, some implementations also support values for functions in the range 101 to 111.
The treatment of hidden cells needs to be described clearly. Excel ignores cells hidden by autofilter when the function arguments are in the range 1 to 11. When the function argument is in the range 101 to 111, cells hidden by other methods (manually hidden, table filter) are also excluded.