Description: pivot table refresh get errors for pages saved in office 5.2 and edited in office 6.0.7.3 Steps to Reproduce: 1. open file made in office 5.2 2. add new data 3. data refresh pivot table 4. get error in calculation that office 5.2 doesn't Actual Results: B5 of pivot table give 37.03 Expected Results: B5 of pivot table should give 925.72 like "DATE" J96 give Reproducible: Always User Profile Reset: No Additional Info: it should give 925.72 In this bug repport page I don't see where I can attach documents, so I put this files in the e-mail. Thank you, Dragos dragsidor@yahoo.com
Created attachment 148325 [details] saved in office 5.2
Created attachment 148326 [details] edited in office 6.0.7.3
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
Hello Dragos, I opened your file in version 5.2. and 6.3 and in both version is BH2 = 13 on sheet "date"
Need to recalculate formula BH2 again - F9 This seems to have begun at the below commit. Adding Cc: to Bernhard Widl ; Could you possibly take a look at this one? Thanks f74eb5670fbb48853f6fd7c38f5d3da9a3b42ad0 is the first bad commit commit f74eb5670fbb48853f6fd7c38f5d3da9a3b42ad0 Author: Jenkins Build User <tdf@pollux.tdf> Date: Tue Apr 11 09:25:23 2017 +0200 source 78dfedec7a7ba289691a5d18441796541f3b1812 author Bernhard Widl <bernhard.widl@cib.de> 2017-04-06 18:17:25 +0200 committer Eike Rathke <erack@redhat.com> 2017-04-10 23:56:50 +0200 commit 78dfedec7a7ba289691a5d18441796541f3b1812 (patch) tree 37e8721d56415fa4abde6db56c0d37bfc39ce53f parent 13b70bc6f18f8dd910e373694de5a6a0cd3eb559 (diff) tdf#105044 match empty cells on "<> not-empty" comparisons this affects any formula using <> over a range of cells (not only SUMIF and SUMIFS)
Hi Eike, I'm wondering if this is the expected behaviour since 78dfedec7a7ba289691a5d18441796541f3b1812 and SUMIF formulas need to be adapted or it's a bug... Could you please take a look when you have a moment ?
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.