LibreOffice Calc - Keyboard shortcut for drop-down menu for spellcheck

GaXve · December 1, 2019, 6:03am

Is there a keyboard shortcut to activate the spellchecker in a cell?

Right Click produces two kinds of Drop Down Context Menus. One “General”, and one Spell Checker when the focus is on a word that LibreOffice Calc does not recognize.

The Context Menu Key (on the keyboard) only produces the “General” Drop Down Context Menu. Is there a Keyboard Shortcut that can produce the Spell Checker Drop Down Menu?

Cheers!

image description

mikekaganski · December 1, 2019, 9:11am

A bug IMO.

anon73440385 · December 2, 2019, 10:56am

Hopefully not a bug but intended behavior - The context menu depends, where you right click. If mouse pointer hoovers over the incorrectly written word you get the spelling dialog on right click (incl. selection of the word) and if the mouse pointer is beside the word you get the normal context dialog. In fact I don’t see any other way how a context menu could work, if I imagine that there may be more than one word incorrectly spelled. What should the context menu present on a keyboard shortcut in that case (the context dialog needs the wrong spelling as parameter, thus could not imagine that there can be a shortcut)? IMO - perfectly implemented as it is right now (using LibreOffice 6.3.3.2)

mikekaganski · December 2, 2019, 11:20am

The context menu depends, where you right click.

Exactly. Now there are scenarios. For testing, prepare this: in a new spreadsheet, type qwert to A1 (this will trigger the spellcheck error).

== Select cell A1 ==

Test 1. Right-click A1 in the word’s area => spell check context menu is shown.
Test 2. Right-click A1 outside the word’s area => normal context menu is shown.
Test 3: Use Context Menu button (Ctrl+F10) => normal context menu is shown

I consider test 3 OK, since it naturally has only one context (selected range), and no point to further refine the context.

== Select text in A1, e.g. by using F2 ==

Test 4. Right-click A1 in the word’s area => spell check context menu is shown.
Test 5. Right-click A1 outside the word’s area => normal context menu is shown.
Test 6: Make sure cursor is inside the bad word, and use Context Menu button (Ctrl+F10) => normal context menu is shown!

See how it knows the context now!

mikekaganski · December 2, 2019, 11:23am

Now compare that to analogous test in Writer and see that having cursor inside quert and using a context menu button/shortcut does bring spellcheck context menu => this is a bug in Calc.

GaXve · December 2, 2019, 1:21pm

@anon73440385, the behavior in Calc, with the mouse is not the issue. The mouse Right Click works well. The issue is with the Context Menu key on the keyboard. If my cursor is blinking within a word that calc does not recognize (underlined in red), the Context Menu key should roll down the “Spell Checker” menu, but it does not.

anon73440385 · December 2, 2019, 3:16pm

Sorry - oversaw the Ctrl+F10 case, since I never ever even had the idea to use a key code to call a context menu.