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…
(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)
Hello Dennis, thanks, I tried it already but there is no shortcut for summation in any application & category.
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.
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.
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.
@RahulVerma - 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)