Ask Your Question
0

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

asked 2018-07-08 04:33:40 +0200

hvankampen gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-07-08 04:59:35 +0200

Ratslinger gravatar image

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.

edit flag offensive delete link more

Comments

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.

hvankampen gravatar imagehvankampen ( 2018-07-10 04:30:52 +0200 )edit

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.

Ratslinger gravatar imageRatslinger ( 2018-07-10 05:14:13 +0200 )edit

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.

hvankampen gravatar imagehvankampen ( 2018-07-11 04:58:36 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-07-08 04:33:40 +0200

Seen: 13 times

Last updated: Jul 08