https://bugs.documentfoundation.org/show_bug.cgi?id=121696
--- Comment #8 from Mike Kaganski <[email protected]> ---
(In reply to Oliver Brinzing from comment #7)
> the "[ ] Treat empty string as zero" compatibility option seems to have no
> influence. is this correct?
Citing bug 73081 comment 0:
> Notice the part "including empty cells".
>
> Notice, that this is not about the problem, whether a zero-length string is
> to be considered as empty cell.
So clearly this is the case where empty cells and zero-length-strings cells can
be treated differently.
> and the question is: which formula's are affected?
citing bug 73081 comment 14:
> So COUNTIF() is inconsistent and now Calc does the same.
Some proper formulas for current state:
=SUMPRODUCT(A2:A7;B2:B7<>"";B2:B7<>0)
=SUMIFS(A2:A7;B2:B7;"<>0";B2:B7;"<>")
--
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
