https://bugs.documentfoundation.org/show_bug.cgi?id=160393
Bug ID: 160393
Summary: PIVOTTABLE: with Grouping: no Drilldown and Datasets
missing
Product: LibreOffice
Version: 24.2.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 193338
--> https://bugs.documentfoundation.org/attachment.cgi?id=193338&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
