Bug 122469 - FILESAVE XLSX, A total result line appears in pivot table after saving
Summary: FILESAVE XLSX, A total result line appears in pivot table after saving
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
5.0 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
: 143329 (view as bug list)
Depends on:
Blocks: Pivot-Table-XLSX
  Show dependency treegraph
Reported: 2019-01-04 10:20 UTC by NISZ LibreOffice Team
Modified: 2021-08-21 05:49 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

The original spreadsheet. (40.76 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-01-04 10:20 UTC, NISZ LibreOffice Team
The saved spreadsheet. (97.00 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-01-04 10:21 UTC, NISZ LibreOffice Team
Screenshot of the original document side by side in Excel and Calc. (277.90 KB, image/png)
2019-01-04 10:21 UTC, NISZ LibreOffice Team

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:20:33 UTC
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.
    3. Reload.

Actual Results:
The pivot table now has a total result line.

Expected Results:
The pivot table should stax the same as it was before saving.

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 NISZ LibreOffice Team 2019-01-04 10:20:55 UTC
Created attachment 148006 [details]
The original spreadsheet.
Comment 2 NISZ LibreOffice Team 2019-01-04 10:21:12 UTC
Created attachment 148007 [details]
The saved spreadsheet.
Comment 3 NISZ LibreOffice Team 2019-01-04 10:21:35 UTC
Created attachment 148008 [details]
Screenshot of the original document side by side in Excel and Calc.
Comment 4 Durgapriyanka 2019-01-04 19:03:47 UTC
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
Calc: threaded
Comment 5 Xisco Faulí 2019-01-16 18:00:35 UTC Comment hidden (obsolete)
Comment 6 Buovjaga 2019-01-26 16:16:20 UTC
(In reply to Xisco Faulí from comment #5)
> Also reproduced in
> Version:
> Build ID: 0db96caf0fcce09b87621c11b584a6d81cc7df86
> Locale: ca-ES (ca_ES.UTF-8)

In older versions the pivot table functionality is lost upon saving.
Comment 7 QA Administrators 2021-01-26 05:12:12 UTC Comment hidden (obsolete)
Comment 8 NISZ LibreOffice Team 2021-01-26 09:11:08 UTC
Still the same in:

Version: (x64) / LibreOffice Community
Build ID: 6c8a6b6aa2f962bd2fadbdf27405bfcd7d167fec
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL
Comment 9 NISZ LibreOffice Team 2021-07-13 15:51:55 UTC
*** Bug 143329 has been marked as a duplicate of this bug. ***