XMLWordPrintable

    Details

    • Proposal:
      Hide

      Accepted for ODF 1.3 as per 6 June 2016

      Show
      Accepted for ODF 1.3 as per 6 June 2016

      Description

      ODF OpenFormula has

      6.9.3 DCOUNT
      Syntax: DCOUNT( Database D ; Field F ; Criteria C )

      6.9.4 DCOUNTA
      Syntax: DCOUNTA( Database D ; Field F ; Criteria C )

      For these two functions the Field argument can be omitted (empty) in
      LibreOffice Calc and Microsoft Excel, it should be defined as

      Syntax: DCOUNT( Database D ; [ Field F ] ; Criteria C )

      Semantics: If the Field argument is omitted, DCOUNT returns the count of
      all records that satisfy Criteria.

      Syntax: DCOUNTA( Database D ; [ Field F ] ; Criteria C )

      Semantics: If the Field argument is omitted, DCOUNTA returns the count
      of all records that satisfy Criteria.

      From Eike Rathke - https://lists.oasis-open.org/archives/office-comment/201605/msg00000.html

        Attachments

          Activity

            People

            • Assignee:
              Patrick Patrick Durusau
              Reporter:
              Patrick Patrick Durusau
            • Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: