Bug 160393 - PIVOTTABLE: with Grouping: no Drilldown and Datasets missing
Summary: PIVOTTABLE: with Grouping: no Drilldown and Datasets missing
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: QA:needsComment
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2024-03-27 12:18 UTC by Michael Otto
Modified: 2024-04-22 03:15 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
2 Pivot Tables: one bad with groups, and one to show the bad fields (33.17 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-03-27 12:18 UTC, Michael Otto
Details

Note You need to log in before you can comment on or make changes to this bug.
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