• Hide

      Accepted for ODF 1.3 as per 6 June 2016

      Show
      Accepted for ODF 1.3 as per 6 June 2016

      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

            Assignee:
            Patrick Durusau
            Reporter:
            Patrick Durusau
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: