[Bug 123925] COUNTIF with criterium <>number does not count empty cells

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=123925

Rainer Bielefeld <ra...@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 <ra...@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.