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.
The pivot table has an extra empty column
It should have the same amount of columns.
User Profile Reset: No
Created attachment 148004 [details]
A spreadsheet with a pivot table.
Created attachment 148005 [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 220.127.116.11.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
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.