Bug 122465 - FILEOPEN XLSX, Extra Data line and button appears in pivot table in Calc.
Summary: FILEOPEN XLSX, Extra Data line and button appears in pivot table in Calc.
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 09:34 UTC by NISZ LibreOffice Team
Modified: 2019-01-26 15:38 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
An xlsx with a simple pivot table. (18.70 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-01-04 09:35 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc. (331.83 KB, image/png)
2019-01-04 09:35 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 09:34:33 UTC
Description:
When a simple pivot table in an excel file gets opened in Calc there is an extra line with a Data button in it.

Steps to Reproduce:
    1. Create a simple pivot table with some data in it in Excel.
    2. Save it as xlsx.
    3. Open the xlsx in Calc.


Actual Results:
There is an extra line with a Data button.

Expected Results:
There shouldn’t be any extra line when compared to Excel.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2019-01-04 09:35:06 UTC
Created attachment 147999 [details]
An xlsx with a simple pivot table.
Comment 2 NISZ LibreOffice Team 2019-01-04 09:35:22 UTC
Created attachment 148000 [details]
Screenshot of the original document side by side in Excel and Calc.
Comment 3 Durgapriyanka 2019-01-04 18:51:19 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:02:29 UTC
Also reproduced in

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

Win 10
3.3.0