OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: DCOUNT and DCOUNTA Field argument can be omitted


Hi,

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.


  Eike

-- 
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
GPG key "ID" 0x65632D3A - 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
Better use 64-bit 0x6A6CD5B765632D3A here is why: https://evil32.com/
Care about Free Software, support the FSFE https://fsfe.org/support/?erack

Attachment: signature.asc
Description: PGP signature



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]