https://bugs.documentfoundation.org/show_bug.cgi?id=92616
Bug ID: 92616
Summary: PIVOTTABLE: Grouped Column Fields problems including
with drill to details
Product: LibreOffice
Version: 4.3.5.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: a...@patternjugglers.co.nz
Created attachment 117118
--> https://bugs.documentfoundation.org/attachment.cgi?id=117118&action=edit
Sample workbook with data and multiple demonstroatin pivottables
Sorry, but there may be multiple issues rolled into this.
-I'm also aware that Pivottables are typically for brave souls only.
This arose in assisting a user with an existing Pivottable, but I have
replicated with a simpler example. Original issues were on 4.3.5.2, detailed
testing done on 4.4.3.2 (both windows).
The attached example sets out to create grouped columns of 'category', and then
drill to details within these.
Step 1: Basic table with 'Category' in Columns, 'Type' in Rows, and Value in
data.
Issue 1: Enable Drill to Details hidden and unchecked by default.
IME Drill to details is fairly standard expected behaviour - is there a
performance advantage to disabling it?
Once 'Enable Drill to Details' is checked, drilling works as expected prior to
any grouping being attempted.
Step 2: Attempt to Group the columns so that a1,a2,a3 are together, b1,b2,b3
are together.
-Select column headings a1,a2,a3 and then Data>Group and Outline>Group
Issue 2: Grouping does not work AT ALL if the 'Category' field is beneath the
'Data' field in the 'Edit Layout' dialog (which is the only place you can place
it. To remedy this you need to either demote or delete the 'Data' field.
The sheet 'Pivot Table_Data_1' has been left in the ungroupable state.
The sheet 'Pivot Table_Data_2' has been fixed by removing the 'Data' field
Step 3: Drill to details
-Double-click on values in sheet sheet 'Pivot Table_Data_2' to show rows of
original data in new sheet
Issue 3: Cannot drill into values in a non-grouped column.
In the example sheet 'Pivot Table_Data_2' categories a1/a2/a3 and b1/b2/b2 are
each grouped and category c1 is not grouped. No groups are collapsed.
Double-clicking on Cell B4 will not drill. Cell C4 will drill.
The sheet 'Pivot Table_Data_3' is a direct copy of sheet 'Pivot Table_Data_2',
except with category c1 grouped (into a group of 1).
Issue 4: Attempt to rename Group causes Group to vanish.
The sheet 'Pivot Table_Data_4' is a direct copy of The sheet 'Pivot
Table_Data_3'.
I edited Cell B2 which contained the header for Group1, to attempt to rename it
'Group of A'. At this stage the entire group of records disappears.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
