Created attachment 193338 [details] 2 Pivot Tables: one bad with groups, and one to show the bad fields PRECONDITION: see attached Pivot-Spielergebnisse-Dual.ods The Items "Halma" and "Kniffel" in a Row Field were "manually" grouped, i.e. these 2 Items marked and grouped with Data > Group and Outline > Group... (or F12), the 3rd Item "Schach" is grouped with a single entry, the original Row Field "Spiel" is removed from the Row Fields. PROBLEM DESCRITION: Drilldown in the Data Fields of the grouped lines does not work correctly: a) in some Data Fields double click does nothing, and b) in other Data Fields on Drilldown, in the new sheet there are entries missing. DETAILS: in the attached Pivot-Spielergebnisse-Dual.ods there are 2 Pivot-Tables (source data for both is $Spielpunkte.$A$1:$E$55): - left Table at G4, where the Row Field "Spiel2" is a grouping of the category "Spiel" (the bad table) - right table at P4, the same Pivot-Table without grouping (to show the fields with a problem) In the right Pivot-Table, the left table's bad entries are marked: yellow: Drilldown in the related Data Field in the left table does nothing red: Drilldown in the left table opens a new sheet where the red marked data entry is missing green: Drilldown in the left table works fine Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 2; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-US (de_DE.UTF-8); UI: en-US Calc: threaded
Please give exact enumerated steps to see the problem, so testers don't have to understand the inner workings of pivot tables.
in the attached Pivot-Spielergebnisse-Dual.ods the problem can be reproduced in the left table (G4:M21). All the lines for "Halma" and "Kniffel" are grouped into a single line, the lines for "Schach" are not grouped. [The right table (P4:V27) is not grouped and shows no error. The field color shows which fields in the left table show the problem.] DRILLDOWN OPERATION: Drilldown in a pivot table means that a doubleclick on a table entry creates a new sheet that contains the underlying data (it's a copy, you can delete this new sheet without data loss). GOOD CASE: Doubleclick on L12, the new sheet contains 2 lines, one for Kniffel and one for Halma. REPRODUCE PROBLEM a) (no Drilldown): Doubleclick on L6, there should appear a new sheet that contains 2 lines, one for Kniffel and one for Halma. But there is no new sheet created at all, the doubleclick has no effect. [All fields IN THE LEFT TABLE that show this problem are marked _yellow_ in the right table.] REPRODUCE PROBLEM b) (Datasets missing): Doubleclick on K6, the new sheet contains only one line for Halma (34). There should be another line for Kniffel (67), as the underlying data consists of both (grouped) data entries (Halma 34 + Kniffel 67 --> 101). [All fields IN THE LEFT TABLE that show this problem are marked _red_ in the right table.]