Created attachment 205107 [details] Screenshot of the popup menu in Excel Hiding or showing rows and columns in Calc is possible only when the user highlights some rows/columns and right clicks on the row/column headers. If the user highlights a rows/column and clicks on the document area, the popup menu does not offer hiding/showing - unlike in Excel. It would be more convenient to 1. Open an empty Calc sheet 2. Click on a column header to highlight a column 3/a. Right click on the column header -> The popup has the Hide Columns / Show Columns commands 3/b Right click on the highlighted column in the document body area -> The popup does not have the above commands. Version: 26.8.0.0.alpha0+ (X86_64) Build ID: 680(Build:0) CPU threads: 24; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: threaded
Created attachment 205108 [details] Screenshot of the popup menu in Calc
Created attachment 205109 [details] The Customize dialog where it would be necessary to enhance it Note: adding the commands in the Customize dialog is rather simple, and they do work as well. However, the 4 commands are not context sensitive: if I add all 4 commands, all of them are usable when a column or a row is selected. This is problematic, because the Hide Row command hides ALL rows when a column is selected, and the Hide Column command hides ALL columns when a row is selected. So the commands also need to be modified, to disable the ones not applicable for the current selection.
> If the user highlights a rows/column and clicks on the document area FWIW, if the user already has highlighted the rows/column, then instead of clicking on the document area he could just right-click on (one of) the selected/relevant headers. Same amount of clicks (and possibly less traveling distance?). OTOH, selecting areas by keyboard and then also using the keyboard to pop the context menu is a valid alternative (for more-experienced users). Or, using a keyboard shortcut in order to show/hide columns/rows after they have been pre-selected (by keyboard), in which case the context menu would be irrelevant for these commands. As you mention, the Hide/Show Columns/Rows commands are already available when right-clicking on the relevant headers, and they are also on commonly-used toolbars. Having the commands also listed on the context menu on every single cell could be considered as clutter by some users. If I understand correctly, you are asking to make the appropriate commands available for customization _according to the relevant context_, not to make them show up by default on every cell's context menu.
We need input from UX team here I think
The context for row/col operations is the header not a single cell. And we have Show/Hide in these popup menus. If a whole column or row is selected, Excel is in the header context not only at the header itself but also at any selected cell and shows the header context menu respectively. No (strong) objection to this modification but it sounds like a lot of work for not much benefit. And the current behavior more clearly separates cell and header context, which has some advantage.