[Bug 65221] SUMIF, COUNTIF, COUNTBLANK, DCOUNT, DSUM, ... with empty cells and "" and ="" empty string criteria

[bu...@apache.org]

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

orcmid <or...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |orcmid@apache.org

--- Comment #18 from orcmid <or...@apache.org> ---
@rockfx01:

The final OpenFormula specification for ODF 1.2 may resolve the question about
empty strings versus empty cells.  

Try =COUNTIF(<range>;"=")

Note that the "=" operation has no value.

To count empty strings, it looks like you need to use 

  =COUNTIF(<range>;"=""""")

The paired "" introduce single " characters into the literal string, so the
criterion is '=""'.

If these functions have been updated for ODF 1.2 in Apache OpenOffice 3.4.0,
you should be able to tell the difference with these two cases.

PS: Check =COUNTIF(<range>;"") again too.  This should find empty strings, but
it might also catch empty cells (which default to empty strings when referenced
in search of text values).

-- 
You are receiving this mail because:
You are on the CC list for the bug.