https://bugs.documentfoundation.org/show_bug.cgi?id=122727
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|NEW |RESOLVED
--- Comment #7 from Eike Rathke <[email protected]> ---
The formula in cell BH2 needs to be changed, it is wrong anyway,
=COUNTIF(J1:AH1;"<>""")
counts cells that do not have a string of " which in this case are all (earlier
versions did not include empty cells there, which was wrong). If that was
supposed to check for not empty string the criteria should had been "<>"""""
instead.
Meant was probably to count cells that are not empty, which would be
=COUNTIF(J1:AH1;"<>")
and results in the desired 13 again.
--
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