How to assign a hotkey to a dialog command button in Calc

[hvankampen]

I have a dialog with a number of command buttons. Is there a way to assign a specific “hotkey” to them?

As it is, Calc seems to assign hotkeys to some but not all, by itself, but they are often not what I would want them to be. For example, a button with the label “Add New Record” has been given <Alt + N> as a shortcut, rather than <Alt + A> (which I would rather have).

Similarly, 2 buttons with the same label on 2 different pages have been given different hotkeys (I can understand how this might be by design).

In Excel, this is simply done by setting the “Accelerator” parameter of the selected command button in the “Properties” window of the VBA interface. Is there an equivalent parameter setting in Calc?

Thanks in advance.

[Ratslinger]

Hello,

You can assign the Accelerator by placing a tilde (~) before the letter to be used. So button label Add New Record becomes ~Add New Record if Alt + a is wanted.

[hvankampen]

Thanks for the info. The hotkeys are working with LibreOffice 6.0 under Windows 7.

I have an older Mac running OSX 10.7.5 and LibreOffice 4.3.7.2. I can run the file under this OS but the hotkeys are not underlined in the dialog and some of them don’t work as they do in the Windows version. Is this known behavior?

Any info would be appreciated.

[Ratslinger]

Sorry, no real experience with Mac. Also, that is a very old LO version. Could be either as the source of the problem.

Do know it also works in Linux. Have used in 5.x & up.

[hvankampen]

Indeed an old version of LO, but the last that will run on OSX 10.7.5 (according to info I have found. I have not tried later versions).

Thanks again for the help.