[Libreoffice-bugs] [Bug 122727] opening ods file (saved in Office 5.3) and adding new data in office 6.0.7.3; pivot table refresh get errors

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122727

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|NEW                         |RESOLVED

--- Comment #7 from Eike Rathke <erack at redhat.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190227/5f686c63/attachment.html>