-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: ODF 1.3
-
Fix Version/s: ODF 1.3
-
Component/s: OpenFormula, Part 4 (Formula) [1.2: 2]
-
Labels:None
-
Proposal:
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