When a pivot table gets its data changed in MSO it doesnt automatically change to represent the new data you have to use refresh, the same can be said about LO, but when a not refreshed pivot table gets opened in LO it automatically refreshes.
Steps to Reproduce:
1. Create a new xlsx with some data.
2. Insert a pivot table with the data.
3. Change some of the data.
4. Save and close.
5. Open in LO.
In LO the pivot table has the changed data.
It should has the same data as in MSO and only be changed when refreshed.
User Profile Reset: No
Created attachment 148017 [details]
Spreadsheet with pivot table and changed data.
Created attachment 148018 [details]
Screenshot of the original document side by side in Excel and Calc.
Thank you for reporting the bug. I can confirm that the bug is present in
Build ID: 3c964980da07892a02d5ac721d80558c459532d0
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win;
TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45
Locale: en-US (en_US); UI-Language: en-US
Also reproduced in
Version 188.8.131.52.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)