Bug 141327 - Right-click to group columns and rows
Summary: Right-click to group columns and rows
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Context-Menu
  Show dependency treegraph
Reported: 2021-03-29 16:10 UTC by Jeff Fortin Tam
Modified: 2021-09-13 11:50 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Jeff Fortin Tam 2021-03-29 16:10:26 UTC
If you right-click selected columns/rows, you can hide/show them. This is what I've been using for years.

Today I've been flabbergasted to discover that you can also "group" columns/rows, not just a cells range, making the columns/rows foldable. I had no idea, even if this was available in the Data menu or the Data tab of the notebookbar!

Since hide/show is available in the right-click menu for rows/columns, I think "Group columns*", "Ungroup columns*" (*: or rows, depending on what is selected) should also be shown within the same separator section of that contextual menu, for discoverability. Google Sheets does exactly that, and that's how I discovered that the feature even existed.
Comment 1 Roman Kuznetsov 2021-08-15 14:22:24 UTC
You can use a F12 key as predefined shortcut for Group/Ungroup

I don't think we need that item in the context menu for selected rows/columns

But let's ask UX-team anyway
Comment 2 Jeff Fortin Tam 2021-08-15 15:15:43 UTC
Well, keyboard shortcuts do not favor discoverability (especially when grouping is sometimes a better alternative to hiding, which is present in that menu), and I can't remember a plethora of keyboard shortcuts for every application out there.

I still think having those group/ungroup actions there alongside hide/show would be a great way for users to organically discover that feature, like I did in other software that actually exposes this in that same contextual menu.
Comment 3 V Stuart Foote 2021-08-15 15:29:26 UTC
(In reply to Jean-François Fortin Tam from comment #2)

So, now that you know the controls exist and are assigned short-cuts--just customize the context menu, the controls to add are .uno:Group and .uno:Ungroup

We don't need them cluttering the context menu *by default*, which has been fully customizable since LO > 6.0

-1, and a clear => WF
Comment 4 Heiko Tietze 2021-08-16 08:40:06 UTC
+1, discoverability is a strong argument and the function is (or rather should be) frequently used. More than Show/Hide.

The downside is marginal, it's just one entry unless a group has been set (Ungroup is hidden if there is no group).

But with 2x -1 vs. 1x +1 I'd like to get more opinions.
Comment 5 Heiko Tietze 2021-08-19 13:55:51 UTC
Had this on the agenda of the design meeting:

   + having an explicit function-key (F12) covers the group/ungroup feature well 
     enough, rather vote to remove the hide/show entries from the context menu and 
     give them a related short-cut e.g. Ctrl+F12 / Shift+F12 (Sascha)
     + shortcuts are nothing without a menu where you learn it
     + having different methods to reach a goal is good practice (Heiko)
   + also the context menu entries are named "Hide Rows", "Show Rows", "Hide Columns" 
     and "Show Columns" while the main menu entries are simply named "Hide" and 
     Show"; IF the context entries are keep up the main menu should changed for 
     consistency (Sascha)
     + Simply Hide/Show can be done when the Column/Row entry comes before, it's the
       contextual variant of the label
   + also you can group the same rows/columns infinite times, that is clearly a bug and 
     should be fixed with a if-range-already-grouped::than-ungroup-statement; this 
     would allow the use of the same short-cut (F12) to group/ungroup and free 
     Ctrl+F12 e.g. for the hide/show feature (Sascha)
     + different topic
   + adding two (actually one in most scenarios) entries to the context menu doesn't 
     hurt and educates people to consider grouping rather than hiding (Heiko)

So we are at 3x con vs 2x pro. Who wants to tip the scales?
Comment 6 Heiko Tietze 2021-09-13 11:50:17 UTC
No clear green from UX people. Nor red. Removing keyword but keeping the ticket open.