[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

--- 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>