Bug 160393

Summary: PIVOTTABLE: with Grouping: no Drilldown and Datasets missing
Product: LibreOffice Reporter: Michael Otto <Micha.Otto.de>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: UNCONFIRMED ---    
Severity: normal    
Priority: medium    
Version: 24.2.1.2 release   
Hardware: All   
OS: All   
Whiteboard: QA:needsComment
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 103381    
Attachments: 2 Pivot Tables: one bad with groups, and one to show the bad fields

Description Michael Otto 2024-03-27 12:18:08 UTC
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