Bug 122468 - FILEOPEN XLSX, Pivot table gets an extra empty column in LO.
Summary: FILEOPEN XLSX, Pivot table gets an extra empty column 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 major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: dataLoss, filter:xlsx
Depends on:
Blocks: Pivot-Table-XLSX
  Show dependency treegraph
 
Reported: 2019-01-04 10:17 UTC by NISZ LibreOffice Team
Modified: 2019-03-28 09:39 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
A spreadsheet with a pivot table. (21.93 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-01-04 10:18 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc. (332.76 KB, image/png)
2019-01-04 10:18 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:17:44 UTC
Description:
When a pivot table with one line label gets opened in LO it gets an extra empty column which can overlap other parts of the spreadsheet.

Steps to Reproduce:
    1. Create a new xlsx with some data.
    2. Create a pivot table from some data with one line label.
    3. Save it as xlsx.
    4. Open it in LO.

Actual Results:
The pivot table has an extra empty column

Expected Results:
It should have the same amount of columns.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2019-01-04 10:18:08 UTC
Created attachment 148004 [details]
A spreadsheet with a pivot table.
Comment 2 NISZ LibreOffice Team 2019-01-04 10:18:27 UTC
Created attachment 148005 [details]
Screenshot of the original document side by side in Excel and Calc.
Comment 3 Durgapriyanka 2019-01-04 18:56:53 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 18:01:29 UTC
Also reproduced in

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

Win 10
3.3.0
Comment 6 Gabor Kelemen 2019-03-28 09:38:19 UTC
Also: if there is some cell content in the cells right of the pivot table, the new column overwrites all of it, effectively causing data loss.

I'm bumping the severity because of this.