Re: [libreoffice-users] Calc - Keyboard shortcut to go to the first cell of the current column

pierre masci schrieb:
> Hello, with "Home" i can move to the start of the current row.
> How can i do the same thing with a column?
>
> Even if i need to use several Shortcuts to achieve it, it wouldn't be
> a problem: i could always record the series of shortcut as a new
> Macro, and make a custom keyboard shortcut for this macro.
>
>
> Thanks for any help :-)

If you use the dispatcher, you get (all rem lines removed)

sub FirstRow
dim document as object
dim dispatcher as object
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "ToPoint"
args1(0).Value = "1"
dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1())
end sub

Bind it to Strg+Alt+PageUp in Calc, for example.

Kind regards
Regina



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted