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-2256

COUNTA - DCOUNTA - Inconsistent definitions of counting? (Does COUNTA exclude logical types?)

    XMLWordPrintable

    Details

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

      Change Semantics from
      Perform COUNTA on data records in database D field F that match criteria C. Note that it counts "Text" or "Number" values; if Logical is a distinct type, such rows will not be counted.

      to
      Perform COUNTA on data records in database D field F that match criteria C.

      Show
      Change Semantics from Perform COUNTA on data records in database D field F that match criteria C. Note that it counts "Text" or "Number" values; if Logical is a distinct type, such rows will not be counted. to Perform COUNTA on data records in database D field F that match criteria C.
    • Resolution:
      Hide

      In DCOUNTA changed Semantics from
      Perform COUNTA on data records in database D field F that match criteria C. Note that it counts "Text" or "Number" values; if Logical is a distinct type, such rows will not be counted.

      to
      Perform COUNTA on data records in database D field F that match criteria C.

      Show
      In DCOUNTA changed Semantics from Perform COUNTA on data records in database D field F that match criteria C. Note that it counts "Text" or "Number" values; if Logical is a distinct type, such rows will not be counted. to Perform COUNTA on data records in database D field F that match criteria C.

      Description

      DCOUNTA reads in part: "Perform COUNTA on data records in database D field F that match criteria C. Note that it counts "Text" or "Number" values; if Logical is a distinct type, such rows will not be counted."

      OK, but if you read COUNTA: "Counts the number of non-blank values in the list of Any sequences provided. A value is non-blank if it contains any content of any type, including an error. In a reference, every cell that is not blank is included in the count. An empty string value ("") is not considered blank. Errors contained in a range are considered a non-blank value for purposes of the count; errors do not propagate. Constant expressions or formulas are allowed; these are evaluated and if they produce an error value the error value is counted as one non-blank value (and not propagated as an error). It is implementation-defined what happens if 0 parameters are passed, but it should be an Error or 0. Any A may be a ReferenceList."

      No mention of not counting logical values. (I am assuming that "any content of any type" means just that.)

      I assume the "it counts "Text" or..." statement under DCOUNTA refers to the COUNTA in the prior sentence. But that is inconsistent with the definition found under COUNTA.

      I don't know which way to go in terms of "fixing" the language. But, COUNTA really should mean the same thing in both places, at least if it is going to be invoked. If we need a different definition, let's explicitly make one.

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              patrick Patrick Durusau
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: