Bug 145201 - UI: Context Menu does not appear if user clicks on the top-left sheet corner.
Summary: UI: Context Menu does not appear if user clicks on the top-left sheet corner.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.6.2 release
Hardware: All All
: low trivial
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Context-Menu Cell-Selection
  Show dependency treegraph
 
Reported: 2021-10-18 12:30 UTC by Van
Modified: 2022-09-22 13:08 UTC (History)
2 users (show)

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


Attachments
Picture shows "top-left sheet corner" to click. (45.14 KB, image/png)
2021-10-18 12:31 UTC, Van
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Van 2021-10-18 12:30:18 UTC
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.
Comment 1 Van 2021-10-18 12:31:35 UTC
Created attachment 175810 [details]
Picture shows "top-left sheet corner" to click.
Comment 2 Shinji Enoki 2021-10-19 12:07:32 UTC
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.
Comment 3 Timur 2022-09-14 11:46:05 UTC
Not sure, Seems like WontFix to me. Asking UX.
Comment 4 Regina Henschel 2022-09-14 12:16:50 UTC
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.
Comment 5 Van 2022-09-17 20:01:20 UTC
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.
Comment 6 Heiko Tietze 2022-09-19 08:41:01 UTC
I wonder what actions needs to be run on the whole sheet.
Comment 7 Heiko Tietze 2022-09-22 13:08:23 UTC
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.