https://issues.apache.org/ooo/show_bug.cgi?id=123925
--- Comment #3 from Regina Henschel <[email protected]> --- @Rainer: (a)(b) The specification is unambiguous here. For me it is not the question whether to change the value but when. Changing the result for an existing function is always difficult and a plan for change-over is needed. (c)(d) COUNTBLANK has implementation dependent handling of zero-length strings and should be avoided in environments where interoperability is needed. The concept of a namespace for formulas (especially the namespace "OpenFormula") and the exact definitions of function results for OpenFormula is new in ODF1.2. Therefore older behavior cannot determine the current results. But we need to think about a way to handle old documents. That problem exists in general, not only with function COUNTIF. (e) Bug 98891 was a problem how to write a criterion. It is not relevant here. (f) Bug 65221 is about handling of zero-length strings. Those are not included here. Therefore it is no duplicate. But bug 65221 needs to be re-examined carefully, because in the meantime OpenFormula is specified in ODF1.2. (g) Bug 108991 is about handling of a constant matrix with missing element as part of the search range of COUNTIF. Constant matrices are new in ODF1.2. That is a very special case because of the array formula and should not be mixed with other problems. It is not related to this issue. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
