[OASIS Issue Tracker] Updated: (OFFICE-2443) 3.10.9 Criteria -incoherent use of the term criteria

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

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

Eike Rathke updated OFFICE-2443:
--------------------------------

    Fix Version/s: ODF 1.2 Part 2 CD 3
                       (was: ODF 1.2 Part 2 CD 2)

> 3.10.9 Criteria - incoherent use of the term criteria
> -----------------------------------------------------
>
>                 Key: OFFICE-2443
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2443
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>            Reporter: Patrick Durusau
>            Assignee: Patrick Durusau
>             Fix For: ODF 1.2 Part 2 CD 3
>
>
> We say:
> ****
> A criteria is a set of selectors that select records from a database. A criteria is a rectangular set of values, with at least one column and at least two rows. The first row lists the fields that are to be considered. 3.10.8 The rest of the rows list criteriasets.
> For a record to be selected from a database, all of the requirements of at least one row of criteriasets shall match. Inside each criteriasets are zero or more criteria.
> Criteria can be one of the following: (number or logical value for instance, in contrast to the first paragraph where it is said to have at least one column and at least two rows)
> ****
> Note that "criteria C" occurs all over the place. If it is supposed to be bound to this section, delete explanations elsewhere and write this properly. 
> Question: Do we need to say that "A reference to an empty cell is interpreted as the numeric value 0." here?
> I ask because we inconsistently say that elsewhere when we redundantly talk about criteria C:
> **
> 5.13.9 COUNTIF, 5.13.10 COUNTIFS,
> The criteria may be a number, an expression, or a text string. A text string starting with a comparison operator is interpreted as a comparison criteria. A reference to an empty cell is interpreted as the numeric value 0.
> 5.16.62 SUMIF
> The criteria C may be a number, an expression, or a text string. A text string starting with a comparison operator is interpreted as a comparison criteria.
> 5.16.63 SUMIFS
> The criteria may be a number, an expression, or a text string. A text string starting with a comparison operator is interpreted as a comparison criteria. A reference to an empty cell is interpreted as the numeric value 0.
> 5.18.5 AVERAGEIF, 5.18.6 AVERAGEIFS
> The criteria may be a number, an expression, or a text string. A text string starting with a comparison operator is interpreted as a comparison criteria. A reference to an empty cell is interpreted as the numeric value 0.
> **
> Note that SUMIF is the odd-man out. No reference to what happens for no match. 

-- 
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