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.
Dear Van, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Repro with: Version: 24.2.0.0.beta1 (X86_64) / LibreOffice Community Build ID: 5f390384195b7264c6e52add9e90a39790285249 CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: fr-FR Calc: threaded
(In reply to Regina Henschel from comment #4) > 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. FWIW... The selected area is "all the cells" of the worksheet, but the focus is on one particular cell (exactly the same as with any kind of range's selection). Both, the "context menu key" and the "Shift+F10" shortcut, show the context menu of the cell that has the focus (e.g. click on cell D10, click on the top-left corner, press "Shift+F10" shortcut). While the right-click action on the top-left corner does not show the context menu when right-clicking on it, the same relevant context menu can be shown when right-clicking on any cell of the already-selected range (as with any selected range, when right-clicking on any of the already-selected cells).