When the attached document gets saved in LO a new line appears in the spreadsheet showing the total result.
Steps to Reproduce:
1. Open the attached original document in LO.
2. Save it as xlsx.
The pivot table now has a total result line.
The pivot table should stax the same as it was before saving.
User Profile Reset: No
Created attachment 148006 [details]
The original spreadsheet.
Created attachment 148007 [details]
The saved spreadsheet.
Created attachment 148008 [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
Build ID: 0db96caf0fcce09b87621c11b584a6d81cc7df86
Locale: ca-ES (ca_ES.UTF-8)
(In reply to Xisco Faulí from comment #5)
> Also reproduced in
> Version: 18.104.22.168.alpha1+
> Build ID: 0db96caf0fcce09b87621c11b584a6d81cc7df86
> Locale: ca-ES (ca_ES.UTF-8)
In older versions the pivot table functionality is lost upon saving.