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: Re: [office-comment] DCOUNT and DCOUNTA Field argument can be omitted


On May 27, 2016 5:30:13 AM EDT, Eike Rathke <erack@redhat.com> wrote:
>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

Sounds great!

S
--- David A.Wheeler


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