[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
bugzilla-daemon at bugs.documentfoundation.org
Thu Jan 17 08:29:54 UTC 2019
https://bugs.documentfoundation.org/show_bug.cgi?id=122727
--- Comment #3 from Dragos <dragsidor at yahoo.com> ---
I SOLVED THE PROBLEM FOR ME
IS NOT THE PIVOT TABLE BUT A COUNTING PROBLEM IN "DATE":
BH2 CELL
=COUNTIF(J1:AH1,"<>""")
IN OPENOFFICE 5.2 IS COUNTING COLUMNS WHERE I WROTE SOMETHING, 3 FOR EXAMPLE
=COUNTIF(J1:AH1,"<>""")
IN OPENOFFICE 6.0.7.3 I DON'T KNOW WHAT IS COUNTING, THE RESULT BECOME 25, ALL
THE EXISTENT COLUMNS NO MATTER IF I WROTE SOMETHING IN IT
I CHANGED WITH
=COUNTIF(J1:AH1,">=0")
AND I SOLVED MY PROBLEM, BUT WHY DO I HAVE TO CHANGE THAT ?
HAVE A NICE DAY !
DRAGOS
--
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/20190117/6da350ef/attachment-0001.html>
More information about the Libreoffice-bugs
mailing list