Bug 165049 - PIVOTTABLE: Rows / columns are overwritten when changing grouping in a Data Pilot; should offer to shift the cells
Summary: PIVOTTABLE: Rows / columns are overwritten when changing grouping in a Data P...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.0.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table Calc-UX
  Show dependency treegraph
 
Reported: 2025-02-04 21:22 UTC by Jeff Fortin Tam
Modified: 2025-02-04 21:22 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Demonstration video (694.16 KB, video/mp4)
2025-02-04 21:22 UTC, Jeff Fortin Tam
Details

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:22:16 UTC
Created attachment 198982 [details]
Demonstration video

Related to bug #165048. Please test using the same sample, attachment #198981 [details].


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