https://issues.apache.org/ooo/show_bug.cgi?id=123925
Rainer Bielefeld <rainerbielefeld_ooo...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
Latest|--- |4.1-dev
Confirmation on| |
Version|4.1.0-dev |3.4.0
See Also| |https://issues.apache.org/o
| |oo/show_bug.cgi?id=108991,
| |https://issues.apache.org/o
| |oo/show_bug.cgi?id=65221,
| |https://issues.apache.org/o
| |oo/show_bug.cgi?id=98891,
| |https://issues.apache.org/o
| |oo/show_bug.cgi?id=123063,
| |https://bugs.freedesktop.or
| |g/show_bug.cgi?id=73081
Ever confirmed|0 |1
--- Comment #1 from Rainer Bielefeld
<rainerbielefeld_ooo...@bielefeldundbuss.de> ---
Additional info:
(a) I agree, definitively not in accordance with ODF definition
(b) Competitors Behavior
(b1) Gnumeric 1.10.16: As AOO result = 1
Gnumeric 1.12.9: As AOO result = 1
(b2) OOo 1.1.5. 2.0.2, 3.3.0 As AOO result = 1
(b3) Calligra 4.7.4: As AOO result = 1
(b4) LibO 4.1.3: As AOO result = 1
(b5) SoftMaker FreeOffice: Different to AOO result = 2
(b6) MS Excel 2010: Different to AOO result = 2
(c) Although I see some applications for current behavior (most times nobody
is interested in including empty cells), we should follow the ODF
definition.
Current behavior in Regina's example with correct behavior can be reached
with =COUNTIF(B2:B4;"<>7")-COUNTBLANK(B2:B4)
(d) Already reproducible with Pre-3.4.0 (OOo 1.1.5), but because of crippled
Version selector (Bug 123063) no useful info can be contributed
(e) Related to "Bug 98891 - COUNTIF cannot count blank cells"? May be this one
is more or less a DUP?
(f) Related to "Bug 65221 - SUMIF, COUNTIF, COUNTBLANK, DCOUNT, DSUM, ...
with empty cells and "" and ="" empty string criteria"?
(g) Related to "Bug 108991 - COUNTIF gives inconsistent counts of empty
arrays"?
@Regina:
What do you think concerning relations?
--
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.
