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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
