Ask Your Question
1

What is keyboard shortcut for Sum function? [closed]

asked 2013-01-29 10:46:14 +0200

froz gravatar image

updated 2015-10-21 01:56:13 +0200

Alex Kemp gravatar image

Hi, LibreOffice 3.6.4.3 on Windows XP.

I constantly copy numbers from my txt files to LibreOffice in single colum. Copy/paste done by keyboard shortcuts. But then I have to "release" the keyboard and click "Sum" icon on toolbar to sum the column. I would like to do all of the tasks only by using keyboard.

What is the keyboard shortcut for Sum function? Thanks

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-21 01:56:34.876977

2 Answers

Sort by » oldest newest most voted
1

answered 2013-01-31 00:07:49 +0200

jorendc gravatar image

As far I can read there is currently no Sum-function shortcut. See https://bugs.freedesktop.org/show_bug...

edit flag offensive delete link more

Comments

@froz -- Does the linked bug characterize your problem? Please make a comment on that bug if you have suggestions about how you would like such a keyboard shortcut implemented.

qubit gravatar imagequbit ( 2013-02-24 21:30:13 +0200 )edit

@froz -- If the linked bug covers your desired use case, please consider marking this Answer as correct so we can resolve this Question as BUG FILED.

Thanks!

qubit gravatar imagequbit ( 2013-02-24 21:32:02 +0200 )edit
0

answered 2013-01-30 23:34:37 +0200

razon_22 gravatar image

LibreOffice does not assign a keyboard shortcut for the Sum function by default. Here are two options. 1 uses the keyboard exclusively and 2 still uses the mouse, but may reduce the number of clicks.

Option 1: Create a macro that executes the Sum function and then assign a keyboard shortcut to the macro. Once the macro is written, go to Tools > Customize and click on the Keyboard tab. Once here, select the shortcut combination and macro you want to associate with it and click Save.

Option 2: Paste all your data from the TXT files into Calc. Then select the cell range that contains your data using the keyboard and then click the Sum button once. This will sum all the columns with one click.

edit flag offensive delete link more

Comments

Option 1: 1. In Tools | Options | General | I have checked "Enable macro recording" option and restarted LibreOffice. 2. In cell A1 I have written number 100 and in cell A2 I have also written number 100. 2. Click on cell A3. 4. Tools | Macro | Record Macro. 5. Clicked on Sum button from toolbar.

froz gravatar imagefroz ( 2013-02-06 10:23:07 +0200 )edit

(continue)6. Click on Stop Recording. And nothing happens! Note: I have tried some other actions to macro record and at this stage it should offer an window to write a macro name. So it looks like nothing is really recorded so that is why save window does not appear.

froz gravatar imagefroz ( 2013-02-06 10:23:27 +0200 )edit

(continue) Is there any there other any other way of doing this? Like creating macro manually and copy/paste the macro code?er way of doing this? Like creating macro manually and copy/paste the macro code?

froz gravatar imagefroz ( 2013-02-06 10:24:27 +0200 )edit
1

(continue) Option 2: There is even simpler way of doing it. Just click on the first empty row in the column of data and click on Sum button. LibreOffice automatically selects the cells above. I don't like this option. I still need to release my keyboard and click on mouse. This is annoying.

froz gravatar imagefroz ( 2013-02-06 10:25:21 +0200 )edit

Question Tools

Stats

Asked: 2013-01-29 10:46:14 +0200

Seen: 5,666 times

Last updated: Jan 31 '13