[Libreoffice-bugs] [Bug 108352] New: Structure of pivot table coming from XLS is altered in LO

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
                CC: michael.meeks at collabora.com
            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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170605/0cfe70ed/attachment.html>