https://bugs.documentfoundation.org/show_bug.cgi?id=165048
Bug ID: 165048
Summary: PIVOTTABLE: When changing the grouping of a range of
cells in a Data Pilot, cell references to that
adjacent ranges are broken during shifting
Product: LibreOffice
Version: 25.2.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 198981
--> https://bugs.documentfoundation.org/attachment.cgi?id=198981&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
