https://bugs.documentfoundation.org/show_bug.cgi?id=112115
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #1 from Eike Rathke <[email protected]> ---
Your formula does not count non-blank cells, it ("<>""") counts cells where the
content is unequal to " a double quote. Note that within an inline literal
string constant two double quotes "" represent one escaped double quote.
5.4 changed how empty cells are treated, ie. they are counted for "equals
empty" ("=") or "not-equals not-empty" ("<>X") like other spreadsheet
applications do.
To count non-empty cells your formula should have "<>" as criteria argument,
eg. =COUNTIF(D24:N24,"<>")
Or compare to Y in your case, =COUNTIF(D24:N24,"=Y")
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
