Ask Your Question
0

Shortcut of Summation Σ [closed]

asked 2014-03-27 13:21:11 +0200

Rahul Verma gravatar image

updated 2015-09-09 21:13:17 +0200

Alex Kemp gravatar image

Dear All, I am searching for a keyboard shortcut of autosum Σ. As there is a shortcut of alt+= in MS Excel, I want same shortcut for Libre Calc. My Libre office version is latest 4.2.2. Any help Please..

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 2016-02-20 15:52:53.609064

2 Answers

Sort by » oldest newest most voted
0

answered 2014-03-27 16:18:35 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

(I'm using a German GUI, so sry if I make mistakes in the translate the GUI caption)

Click on [Extras] --> [Customize] --> Tab [Keyboard] --> search for alt = and change the shortcut.

At the moment I don't see that the sum is predefined in any shortcut. (if i didn't missed anything)

edit flag offensive delete link more

Comments

Hello Dennis, thanks, I tried it already but there is no shortcut for summation in any application & category.

Rahul Verma gravatar imageRahul Verma ( 2014-03-28 08:00:51 +0200 )edit

Oh yeah. there is only a shortcut available for opening the function-wizard/assistant. well I guess you have to use a macro as @mahfiaz described.

Dennis Roczek gravatar imageDennis Roczek ( 2014-04-02 17:48:26 +0200 )edit
0

answered 2014-03-27 16:25:02 +0200

mahfiaz gravatar image

Not sure if it is the easiest way, but you could create a super simple macro, something like this:

REM  *****  BASIC  *****
Sub Main

End Sub

sub EnterMyName
rem -------------------------------------------------------------
rem define variables
dim document   as object
dim dispatcher as object
rem -------------------------------------------------------------
rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

rem -------------------------------------------------------------
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "Text"
args1(0).Value = "Andrew Pitonyak"

dispatcher.executeDispatch(document, ".uno:InsertText", "", 0, args1())
end sub

(shamelessly copied from "Getting strated with macros" document)

Change the Value to be Σ and finally assign it to a keybinding of your liking under Tools → Customize → Keyboard.

To anyone who is using Linux, you could configure e.g your right Ctrl to change to next layout while pressed and have Greek as the second layout. Now having Σ is as easy as pressing RCtrl + Shift + S and σ is RCtrl + S.

edit flag offensive delete link more

Comments

Hi mahfiaz thanks for ur reply. I followed ur steps, but the macro is not working. I tried to find the ready made macro for summation on google, but i didnt find the same.

Rahul Verma gravatar imageRahul Verma ( 2014-03-28 07:59:24 +0200 )edit

@Rahul Verma - I did try that macro now and it indeed did work. Unfortunately I don't know where yours went wrong. Will it work if you place your cursor inside the code of that macro and press F5? (F5 - Run BASIC, same as button on toolbar with paper and downwards arrow)

mahfiaz gravatar imagemahfiaz ( 2014-03-28 17:18:53 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-03-27 13:21:11 +0200

Seen: 2,656 times

Last updated: Mar 27 '14