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: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, regression
Depends on:
Blocks: Pivot-Table
  Show dependency tree / graph
 
Reported: 2024-03-27 12:30 UTC by Michael Otto
Modified: 2024-07-23 08:22 UTC (History)
3 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
View All Add an attachment (proposed patch, testcase, etc.)

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
Comment 1 Buovjaga 2024-07-23 08:22:44 UTC 
Steps:
1. Open attachment 193340 [details]
2. Ctrl-click P6, P9 and P11
3. Data > Group and Outline > Group

Observe the grouping "Spiel2" in the table on the left is lost.

Bibisected with Linux 43all to range
https://git.libreoffice.org/core/+log/9e6b086c62b4144058eb52ca40b562ff61e26a68..cc9a10185749210825fe6970ea4b103eb78e329e

Relevant seems to be 49d3e30ec975a348b7b3d82c37137eb8ff6bb52e
When changing grouping in one pivot table, update all linked tables.

Arch Linux 64-bit
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a7de9cc5e89cd0d0c2f6363b2c0cc265c528b121
CPU threads: 8; OS: Linux 6.9; UI render: default; VCL: kf6 (cairo+wayland)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: CL threaded
Built on 23 July 2024