Bug 122474 - FILEOPEN XLSX, Pivot table gets refreshed automatically when opened in LO
Summary: FILEOPEN XLSX, Pivot table gets refreshed automatically when opened in LO
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: Pivot-Table-XLSX
  Show dependency treegraph
 
Reported: 2019-01-04 10:53 UTC by NISZ LibreOffice Team
Modified: 2019-01-26 15:26 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet with pivot table and changed data. (17.92 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-01-04 10:54 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc. (299.49 KB, image/png)
2019-01-04 10:54 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-01-04 10:53:45 UTC
Description:
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.

Actual Results:
In LO the pivot table has the changed data.


Expected Results:
It should has the same data as in MSO and only be changed when refreshed.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2019-01-04 10:54:29 UTC
Created attachment 148017 [details]
Spreadsheet with pivot table and changed data.
Comment 2 NISZ LibreOffice Team 2019-01-04 10:54:47 UTC
Created attachment 148018 [details]
Screenshot of the original document side by side in Excel and Calc.
Comment 3 Durgapriyanka 2019-01-04 20:52:13 UTC
Thank you for reporting the bug. I can confirm that the bug is present in

Version: 6.3.0.0.alpha0+
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
Calc: threaded
Comment 4 Xisco Faulí 2019-01-16 17:40:46 UTC
Also reproduced in

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 5 Buovjaga 2019-01-26 15:26:23 UTC
Confirmed.

Win 10
3.3.0