-
Type: Bug
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: ODF 1.2 Part 2 CD 3
-
Component/s: OpenFormula
-
Labels:None
-
Proposal:
-
Resolution:
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.