Bug 160394 - PIVOTTABLE: Grouping in a 2nd table removes grouping in the first table
Summary: PIVOTTABLE: Grouping in a 2nd table removes grouping in the first table
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:30 UTC by Michael Otto
Modified: 2024-04-22 03:15 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
2 Pivot Tables: one with group Spiel2, and one where to group some dates (33.17 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-03-27 12:30 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:30:40 UTC
Created attachment 193340 [details]
2 Pivot Tables: one with group Spiel2, and one where to group some dates

+++ This bug was initially created as a clone of Bug #160393 +++

PRECONDITION (same as Bug #160393):
see attached Pivot-Spielergebnisse-Dual.ods (same as Bug #160393)
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:
creating a grouping in the second table (which has the same source data) 
removes the grouping of the first table

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"
- right table at P4, the same Pivot-Table without grouping 
when adding a grouping in the right Pivot-Table:
- mark several dates in the Row Field "Datum" and Data > Group and Outline > Group... (or F12)
the grouping "Spiel2" in the first table is lost.


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