[OASIS Issue Tracker] (OFFICE-3906) DCOUNT and DCOUNTA Field argument can be omitted

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ https://issues.oasis-open.org/browse/OFFICE-3906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=68277#comment-68277 ] 

Michael Stahl commented on OFFICE-3906:
---------------------------------------

Eike says INDEX is an existing function with optional non-last arguments

http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#INDEX

> DCOUNT and DCOUNTA Field argument can be omitted
> ------------------------------------------------
>
>                 Key: OFFICE-3906
>                 URL: https://issues.oasis-open.org/browse/OFFICE-3906
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula, Part 2 (Formulas)
>    Affects Versions: ODF 1.3
>            Reporter: Patrick Durusau
>            Assignee: Patrick Durusau
>             Fix For: ODF 1.3
>
>
> 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



--
This message was sent by Atlassian JIRA
(v6.2.2#6258)