https://bugs.documentfoundation.org/show_bug.cgi?id=108352
Bug ID: 108352
Summary: Structure of pivot table coming from XLS is altered in
LO
Product: LibreOffice
Version: 4.0.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xls
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Blocks: 103381
Created attachment 133866
--> https://bugs.documentfoundation.org/attachment.cgi?id=133866&action=edit
Sample XLS
The attached simple pivot table was created in Excel 2013 with the same method
as in bug 108343, but as an XLS.
In this case if the file is opened in LibreOffice, the structure is different,
instead of "Row Labels", the first item (Banana) is the selector, but if you
click into Country or Banana cells, the view changes slightly, the table
becomes a row taller, and Product becomes the selector again (see attached
comparative screenshots).
The roundtripped table looks similar in Excel as its state in Calc, but the
border is blue when the pivot area has been clicked into.
Observed with LO 5.4beta1 & 4.0.0.3 / Windows 7.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=103381
[Bug 103381] [META] Pivot table (aka Data Pilot) bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
