Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-2030

6.15.59 SUBTOTAL - Fuction definition doesn't mention hidden rows or additional parameters

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      Change Semantics from
      The difference from the standard functions is that all members of the sequence which include a call to SUBTOTAL are ignored.
      to
      The difference from the standard functions is that all members of the sequence are excluded which

      • include a call to SUBTOTAL.
      • are in a row that is hidden by a table:visibility='filter' attribute of the <table:table-row> element.
      • are in a row that is hidden by a table:visibility='collapse' attribute of the <table:table-row> element if the function ID is one of 101...111.

      Change the simple list of functions to a table listing functions on rows, 1st column "Function" names, 2nd column "Exclude hidden by filter" IDs 1 to 11, 3rd column "Exclude hidden by filter or collapsed" IDs 101 to 111.

      Show
      Change Semantics from The difference from the standard functions is that all members of the sequence which include a call to SUBTOTAL are ignored. to The difference from the standard functions is that all members of the sequence are excluded which include a call to SUBTOTAL. are in a row that is hidden by a table:visibility='filter' attribute of the <table:table-row> element. are in a row that is hidden by a table:visibility='collapse' attribute of the <table:table-row> element if the function ID is one of 101...111. Change the simple list of functions to a table listing functions on rows, 1st column "Function" names, 2nd column "Exclude hidden by filter" IDs 1 to 11, 3rd column "Exclude hidden by filter or collapsed" IDs 101 to 111.

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              ericpa Eric Patterson
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: