[Solved] Keyboard shortcut for autosum

Discuss the spreadsheet application

[Solved] Keyboard shortcut for autosum

Postby Ripcord » Wed Nov 20, 2019 5:55 pm

Is there one, or is it possible for me to program one? In Excel it's Alt + =
Last edited by Hagar Delest on Fri Nov 22, 2019 9:09 am, edited 1 time in total.
Reason: tagged solved
Open Office 4.0.1 on Windows 7
Ripcord
 
Posts: 12
Joined: Sat May 23, 2015 6:06 pm

Re: Keyboard shortcut for autosum

Postby Zizi64 » Wed Nov 20, 2019 7:08 pm

The hotkey associations depended on the locale settings of the operating system and the office suite.
But you can customize the keyboard inside the office suite. Here is a screeshot from my LibreOffice 6.2.8:

AutoSum.png
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.0; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8773
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Keyboard shortcut for autosum

Postby Ripcord » Wed Nov 20, 2019 7:24 pm

Thanks, now I know where to look...but ODP doesn't seem to list the "all commands" option on the customize menu.
Open Office 4.0.1 on Windows 7
Ripcord
 
Posts: 12
Joined: Sat May 23, 2015 6:06 pm

Re: Keyboard shortcut for autosum

Postby Zizi64 » Wed Nov 20, 2019 7:38 pm

The LibreOffice has some new features relative to the Apache OpenOffice.

Try it.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.0; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8773
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Keyboard shortcut for autosum

Postby Ripcord » Thu Nov 21, 2019 4:55 pm

Thank you, I downloaded LibreOffice and it seems to open the Open Office files with no problems. I'll use it from now on and my new shortcut for autosum is F3. :D
Open Office 4.0.1 on Windows 7
Ripcord
 
Posts: 12
Joined: Sat May 23, 2015 6:06 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 6 guests