Description: Please consider the scenario first: 1. User clicks with the first mouse button on a cell (e. g. "A2") to select the cell; 2. user clicks with the second mouse button to call the Context menu; 3. user chooses "Format Cells…" context menu item to format the cell. **Note:** User *does not* move mouse pointer between the step 1 and the step 2. Such scenario perfectly works for columns, too: 1. User clicks with the first mouse button on a column header (e. g. "A") to select all cells of the column; 2. user clicks with the second mouse button to call the Context menu; 3. user chooses "Format Cells…" context menu item to format the cells. Such scenario perfectly works for rows, too: 1. User clicks on a row header (e. g. "2") with the first mouse button to select all cells of the row; 2. user clicks with the second mouse button to call the Context Menu; 3. user chooses "Format Cells…" context menu item to format the cells. But such scenario **does not** work for a sheet: 1. User clicks on a area in the top-left sheet corner(†) with the first mouse button to select all cells of the sheet; 2. user clicks with the second mouse button to call the Context Menu, but the Context Menu **did not** appear. (†) "Top-left sheet corner" is a rectangle area, intersection of column names row and row names column. The first mouse button click on this area selects all cells of the sheet. It is a usability bug: the same user behavior (first mouse click with following second mouse button click) works for cells, columns, rows, but does not work for all cells in a sheet. There is an easy workaround, though: After the step 1 user should move the mouse pointer to sheet content and then perform the steps 2 and 3, but it is annoying anyway. Steps to Reproduce: 1. Start LibreOffice Calc. 2. Click with the first mouse button on the top-left corner of a sheet to select all cells of the sheet. 3. Do **not** move mouse button. 4. Click with the second mouse button to open Context Menu. Actual Results: Context Menu did **not** appear. Expected Results: Context Menu appeared. Reproducible: Always User Profile Reset: No Additional Info: I specified LibreOffice version as 7.1.6.2 because I do not know exact earlier version affected by the bug, but this bug has been present in LibreOffice Calc for many years. BTW, Microsoft Excel shows the Context Menu when user clicks with the second mouse button on the top-left sheet corner.
Created attachment 175810 [details] Picture shows "top-left sheet corner" to click.
Reproduced in the following environment: Version: 7.2.1.2 / LibreOffice Community Build ID: 87b77fad49947c1441b67c559c339af8f3517e22 CPU threads: 8; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP Calc: threaded I think this is a UX request, not a bug. After selecting the entire sheet, it cannot right-click the top-left sheet corner to bring up the context menu, but it can right-click any of the selected cells to bring up the context menu.
Not sure, Seems like WontFix to me. Asking UX.
On Windows you get the context menu with the key "Context menu" and you get the context menu with the general "Shift+F10" shortcut, but you do not get it with right-click. I think that is inconsistent and should be improved.
Consider simpler scenarios: In the beginning of each scenario, make sure there is no columns or rows selected. Cell: Click with a *second* mouse button on a cell: the cell is selected *and* the context menu is appeared. Column: Click with a *second* mouse button on a column header: the column is selected *and* the context menu is appeared. Row: Click with a *second* mouse button on a row header: the row is selected *and* the context menu is appeared. Up to now, the second mouse button click behavior is consistent: it selects the object *and* shows the context menu. Sheet: Click with a *second* mouse button on a sheet top-left corner: the sheet is selected and… oops, this is all. The context menu is *not* appear. I see no reason why the same action (the second mouse button click) gives different result. I do not know if MS Excel is an argument for you, but the second mouse button click behavior in MS Excel is consistent in all *four* scenarios.
I wonder what actions needs to be run on the whole sheet.
I can follow the idea to have a context menu at this position. And besides there are options to achieve what this menu does I'd say no objection to implement it. Ideally configured that non-matching options for all cells (eg sparklines, merge) are hidden. But with low priority.