incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject [Bug 65221] SUMIF, COUNTIF, COUNTBLANK, DCOUNT, DSUM, ... with empty cells and "" and ="" empty string criteria
Date Mon, 02 Jul 2012 11:37:38 GMT

orcmid <> changed:

           What    |Removed                     |Added
                 CC|                            |

--- Comment #18 from orcmid <> ---

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 


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.

View raw message