Download it now!
Bug 75823 - UI: Grouping/Ungrouping is small scope|FIFO, should be large scope|LIFO?
Summary: UI: Grouping/Ungrouping is small scope|FIFO, should be large scope|LIFO?
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: needsUXEval
Depends on:
Reported: 2014-03-06 06:37 UTC by panoworks
Modified: 2016-08-23 14:09 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description panoworks 2014-03-06 06:37:23 UTC

Select columns A and B, group together.
Select columns C and D, group together.
Select columns A through D, group together.

Select columns A through D, choose ungroup.

Rather than the group for A through D getting ungrouped, the two groups A-B and C-D get ungrouped.

This enhancement request is to either:
A. ungroup the group that best matches the selected range first (going from top to bottom as seen from the UI).
B. ungroup only the last group added that is within the selected range (which means keeping order-of-operations stack internally)

I can think of a reason why it is the way it is right now.  If you...
1. add a bunch of smaller groups
2. group those together in a larger group
3. decide you no longer need the smaller groups
4. select the range inside that larger group
5. hit ungroup.
..then you're left with just the larger group, exactly what you wanted from step 3.

With the proposed change, this would instead leave you with all of the smaller groups.  You would have to select those individually, then ungroup them.  However, a faster method for this specific use case would be to ungroup twice (removing both 1. the larger grouping and 2. the smaller grouping), then group again (re-creating the larger grouping).

A similar workaround does not exist for the current implementation; the first ungrouping removes the smaller groups before the second ungrouping removes the larger group, inherently requiring re-selection of smaller groups' ranges before grouping once more - resulting in more operations.

I may have missed something though.
Comment 1 Robinson Tryon (qubit) 2014-12-27 15:11:56 UTC
Enhancement request re: grouping of columns in Calc. Sounds like something for UX.

Status -> NEW
OS/Arch -> (Generalizing, as I expect this is independent)
Comment 2 mahfiaz 2014-12-27 22:12:46 UTC
TIL there are groups in Calc :)
I agree, the proposed variant makes more sense.

Also there is another possible workaround with the current behavior. First remove one smaller group, then remove the large group and add again the small group.

OT: What bothers me more is that it is possible to add several identical groups.
Comment 3 Heiko Tietze 2016-08-23 14:09:26 UTC
Let's add a third level: AB, CD, EF, GH + ABCD, EFGH + ABCDEFGH (btw: F12 groups in Calc). Select DE and ungroup (ctrl+F12). Do you really expect that this function affects the highest level now? In fact it ungroups CD and EF, and I believe that's much better. Closing this issue as WFM, feel free to reopen.