Bug 165048 - PIVOTTABLE: When changing the grouping of a range of cells in a Data Pilot, cell references to that adjacent ranges are broken during shifting
Summary: PIVOTTABLE: When changing the grouping of a range of cells in a Data Pilot, c...
Status: RESOLVED DUPLICATE of bug 160515
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency tree / graph
 
Reported: 2025-02-04 21:05 UTC by Jeff Fortin Tam
Modified: 2025-02-06 01:04 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Sample file (13.56 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-02-04 21:05 UTC, Jeff Fortin Tam 		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 Jeff Fortin Tam 2025-02-04 21:05:34 UTC 
Created attachment 198981 [details]
Sample file

Please use the attached simplified sample spreadsheet.

To reproduce:

1. Click one of the two months, in A3 or A4
2. Go to “Data > Group”, then add “Year” in addition to Month

Result: the yellow numbers in F3-F4 will break (their calculated results will completely change) because column D has shifted to E, but the refs have not been updated to E.

---

Tested on:

Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Flatpak
Calc: threaded
Comment 1 m_a_riosv 2025-02-06 01:01:39 UTC 
I think this is not a bug, references to a pivot table are not updated when PT changes.

Maybe
 GETPIVOTDATA function
https://help.libreoffice.org/latest/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id7682424
 can help to obtain those values, no matter where the column is, 
be aware that dates are searched with their text value.
or look for the column values with INDEX and MATCH, I think the easiest way.
Comment 2 m_a_riosv 2025-02-06 01:04:39 UTC 

*** This bug has been marked as a duplicate of bug 160515 ***