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