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


Help: OASIS Mailing Lists Help | MarkMail Help

office message

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

Subject: [OASIS Issue Tracker] Updated: (OFFICE-2256) COUNTA - DCOUNTA -Inconsistent definitions of counting? (Does COUNTA exclude logical types?)

     [ http://tools.oasis-open.org/issues/browse/OFFICE-2256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eike Rathke updated OFFICE-2256:

    Fix Version/s: ODF 1.2

> COUNTA - DCOUNTA - Inconsistent definitions of counting? (Does COUNTA exclude logical types?)
> ---------------------------------------------------------------------------------------------
>                 Key: OFFICE-2256
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2256
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Patrick Durusau
>            Assignee: Eike Rathke
>             Fix For: ODF 1.2
> DCOUNTA reads in part: "Perform COUNTA on data records in database D field F that match criteria C. Note that it counts "Text" or "Number" values; if Logical is a distinct type, such rows will not be counted."
> OK, but if you read COUNTA: "Counts the number of non-blank values in the list of Any sequences provided. A value is non-blank if it contains any content of any type, including an error. In a reference, every cell that is not blank is included in the count. An empty string value ("") is not considered blank. Errors contained in a range are considered a non-blank value for purposes of the count; errors do not propagate. Constant expressions or formulas are allowed; these are evaluated and if they produce an error value the error value is counted as one non-blank value (and not propagated as an error). It is implementation-defined what happens if 0 parameters are passed, but it should be an Error or 0. Any A may be a ReferenceList."
> No mention of not counting logical values. (I am assuming that "any content of any type" means just that.)
> I assume the "it counts "Text" or..." statement under DCOUNTA refers to the COUNTA in the prior sentence. But that is inconsistent with the definition found under COUNTA. 
> I don't know which way to go in terms of "fixing" the language. But, COUNTA really should mean the same thing in both places, at least if it is going to be invoked. If we need a different definition, let's explicitly make one. 

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


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