Hide Forgot
Description of problem: Complicated excel sheet with lots of data. A pivot table created with Excel, the output (sum figures etc) from the pivot are displayed as they left excel. If one "refresh" the pilot table, totally different figures are shown. If one has "getpivotdata" function referring to the pivot, one gets the recalculated values, not the ones visible on the sheet (though this is not a bug, just adding to confusion). Example: Pivot calculated by excel shows total sum of 10 000. When doing refresh with Oo, the sum changes to something else (say for example 9000). Even without doing refresh, "getpivotdata" function referring to that pivot will return 9000. Above numbers are arbitary, picked for illustration purposes only. Version-Release number of selected component (if applicable): openoffice.org-calc-3.3.0-20.2.fc14.x86_64 and openoffice.org-calc-3.3.0-20.5.fc14.i686 File created with Ms Excel 2003 (11.8324.8324) sp3 How reproducible: Always Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info:
Creating a separate OpenOffice datapivot with same fields and selection criteria as the excel pivot results to correct figures. Still working on data obfuscation to be able to submit a sample file. So as summary: -Open excel file with Pivot in it. Pivot total shows 10000. - Press Refresh (or use getpivotdata), pivot total updates to incorrect result (eg 9000) - Create Oo Datapilot over the same data, same selection and grouping criteria as with the Pivot -> datapilot shows correct result (eg 10000) Ps. I would rate this bug as critical: spreadsheet calculating incorrectly is not a nice thing.
caolanm->erathke: This problem ring any bells with you ?, there's no example attached unfortunately
feel free to reopen this bug if you can attach something we can reproduce this with