Bug 156417 - Add "Function Keys Used in Spreadsheets" to the "Customize..." dialog keyboard shortcuts
Summary: Add "Function Keys Used in Spreadsheets" to the "Customize..." dialog keyboar...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.5.2 release
Hardware: All macOS (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-07-21 17:44 UTC by Patrick
Modified: 2023-08-13 03:20 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Patrick 2023-07-21 17:44:03 UTC
Description:
LibreOffice has a [helpful page](https://help.libreoffice.org/latest/lo/text/scalc/04/01020000.html) with a list of keyboard shortcuts for Calc. Unfortunately some (or all?) of these don't appear in the menu of customizable keyboard hotkeys that you can access from the Tools > Customize dialog. It seems that there is no way to customize or disable these keyboard shortcuts. [A related question]https://ask.libreoffice.org/t/disable-option-arrow-keyboard-shortcut-in-order-to-move-cursor-by-word-in-cell-edit-mode/78110).

In my particular case, I would like to customize / remove the shortcuts Option + Left/Right Arrow and Option + Shift + Left/Right Arrow on MacOS. These keyboard shortcuts are used for text navigation in every other application, I use them heavily, and I find that I unwantedly trigger the cell resize feature all the time.

Steps to Reproduce:
1. Open the keyboard shortcuts menu from the menu bar: Tools > Customize ...
2. Look for the keyboard shortcuts Option + Left/Right Arrow and Option + Shift + Left/Right Arrow.

Actual Results:
These keyboard shortcuts show as having no function that can be customized.

Expected Results:
The keyboard shortcuts from the "Shortcut Keys for Spreadsheets" page should show their assigned functions, to be removed or customized.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.2.5.2 / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 12; OS: Mac OS X 12.5.1; UI render: default; VCL: osx
Locale: en-CA (en_CA.UTF-8); UI: en-US
Calc: threaded
Comment 1 Mike Little 2023-08-09 08:00:44 UTC
Version: 7.5.2.2 (AARCH64) / LibreOffice Community
Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2
CPU threads: 10; OS: Mac OS X 13.5; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded



Not sure if this is a problem with libre office Calc… as these shortcuts have functions in the macOS operating system:
Where:
	Look for the keyboard shortcuts Option + Left/Right Arrow : I observed that in an ordinary text document, that this moves the insertion point To the beginning of the previous line in MacOS
	Look for the keyboard shortcuts and Option + Shift + Left/Right Arrow: I observed that in an ordinary text document, that this moves the insertion point to the beginning of the next line in MacOS


Could you please elaborate how this is a defect?
Comment 2 Patrick 2023-08-09 15:23:04 UTC
You're right about these keyboard shortcuts do having meaning in MacOS. The default functions are:

Option + left/right arrow: move the cursor one word to the left/right
Option + shift + left/right arrow: extend the text selection one word to the left/right

You can see both of these functions in any simple editable text area in MacOS, like Textedit, or a <textarea> element in the browser. You can also see the text selection feature with non-editable text in the browser, try selecting a word and then use option + shift + arrow to manipulate the selection.

The above shortcuts do something else entirely in Calc though (manipulating cell size), and there seems to be no way to unbind these keyboard shortcuts in Calc to restore the default/system behaviour.