https://bugs.documentfoundation.org/show_bug.cgi?id=162638
Bug ID: 162638
Summary: FILEOPEN: Import pivot table from excel missing row
header
Product: LibreOffice
Version: 24.8.0.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 196025
--> https://bugs.documentfoundation.org/attachment.cgi?id=196025&action=edit
Excel file with a pivot table defined
I'm using:
Version: 24.8.0.3 (X86_64) / LibreOffice Community
Build ID: 0bdf1299c94fe897b119f97f3c613e9dca6be583
CPU threads: 8; OS: Linux 6.9; UI render: default; VCL: qt5 (cairo+xcb)
Locale: en-US (en_DK.UTF-8); UI: en-US
Calc: threaded
Problem:
You can find attached a file produced in excel, example.xlsx, this file has a
pivot table that was created in excel, as shown in
https://i.imgur.com/1CHF7s7.png
When opening this file in calc, the result is https://i.imgur.com/KjFSakf.png
The row header that show up in excel in cell A5 is gone. All the other columns
of the pivot table are shifted one column to the left.
I expected to get in Calc exactly the same we have in excel, or, at least, do
not have the data columns of the pivot table shifted one column to the left.
--
You are receiving this mail because:
You are the assignee for the bug.
