[Libreoffice-bugs] [Bug 126702] New: XLSX FILEOPEN Issues with partially grouped pivot table fields in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126702

            Bug ID: 126702
           Summary: XLSX FILEOPEN Issues with partially grouped pivot
                    table fields in Calc
           Product: LibreOffice
           Version: 6.0.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
            Blocks: 112416

Created attachment 153132
  --> https://bugs.documentfoundation.org/attachment.cgi?id=153132&action=edit
Sample XLSX with one partially grouped row field

In Excel, in a pivot table you can select a couple of entries, open right-click
menu, and select Group to create arbitrary grouping (repeat any number of
times). The group name can be changed by editing its cell. In the PivotTable
Fields you also have the option to remove the original field from the rows, and
only keep the grouped one.

The two attached samples were created this way, one has both the grouped and
non-grouped rows (the layout has also been switched from Compact to Outline
Form), the other only has the grouped row.

In Calc:
- for the file with the one, partially grouped row field no content is
displayed, only the sum at the end,
- for the file with both row fields only the ungrouped one is shown.

Observed using LO 6.4.0.0.alpha0+ (ed882d693f37779e3a09641e7cd43b7a925d2312),
6.0.0.3 / Windows 7.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=112416
[Bug 112416] [META] XLSX pivot table bugs
-- 
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/20190805/218b7af1/attachment-0001.html>