https://bugs.documentfoundation.org/show_bug.cgi?id=165049
Bug ID: 165049
Summary: PIVOTTABLE: Rows / columns are overwritten when
changing grouping in a Data Pilot; should offer to
shift the cells
Product: LibreOffice
Version: 25.2.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 198982
--> https://bugs.documentfoundation.org/attachment.cgi?id=198982&action=edit
Demonstration video
Related to bug #165048. Please test using the same sample, attachment #198981.
To reproduce:
1. Click one of the two months, in A3 or A4
2. Go to “Data > Group”, then add “Year” AND "Quarter" in addition to Month
Result:
LibreOffice Calc prompts about whether you want to overwrite, but doing so
(clicking "Yes") completely wipes out the contents of the adjacent cells in
columns E and F, which were not part of the pivot table.
The problem is, there is no alternative. Clicking "No" in that dialog (which
should really be labelled "Cancel", because it doesn't do anything) does not
shift the cells for you.
This is not very useful, and it is dangerous, as there is currently no Undo for
this.
Instead, it would be much more useful if it could offer to insert extra columns
(or rows, depending on the situation) for you, so that those adjacent cells are
safely shifted. Or to shift only the affected cells.
(in both cases, formula refs would need to be updated, as per bug #165048)
Maybe the dialog could offer these choice buttons instead:
* "Cancel"
* "Shift the affected cells" (or "Insert 2 columns")
* "Overwrite"
---
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.
