https://issues.apache.org/ooo/show_bug.cgi?id=65221
orcmid <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #18 from orcmid <[email protected]> --- @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.
