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.
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
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.
(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
+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.
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?
No clear green from UX people. Nor red. Removing keyword but keeping the ticket open.