<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - opening ods file (saved in Office 5.3) and adding new data in office 6.0.7.3; pivot table refresh get errors" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122727#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - opening ods file (saved in Office 5.3) and adding new data in office 6.0.7.3; pivot table refresh get errors" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122727">bug 122727</a> from <a class="email" href="mailto:dragsidor@yahoo.com" title="Dragos <dragsidor@yahoo.com>"> Dragos</a> <pre>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</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>