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

Thanks a lot Johnny, it works perfectly, as requested, the cursor goes
to the first cell of the current column.
I assigned it to Alt+Home, it will probably get used quite often.

On 27 February 2013 16:53, Johnny Rosenberg <gurus.knugum@gmail.com> wrote:
> 2013/2/27 pierre masci <piemas25@gmail.com>:
> > I solved my problem in another but simple way, finally.
> > It would still be handy to have a shortcut to column start though...
> >
> > I made a Macro that moves the current row up (and another one to go
> > down). And i have a handy shortcut to use it.
> > Step by step, it does:
> >  - select current row: Shift+Space
> >  - copy: Ctrl+C
> >  - delete current row: Ctrl + "-"
> >  - move up: up arrow
> >  - insert row: Shift+Space, Ctrl + "+"
> >  - go to line beginning and copy: Home, Ctrl+C
> >
> > DONE!
> >
> > Intructions for use:
> > Record this Macro, make a customized shortcut for it (in
> > Tools->Customize->Keyboard).
> > It's extremely convenient for me. I hope it helps someone else.
> >
> > To do the same thing for moving columns around, i thought that i
> > needed to go to the first cell of the column, for the last step.
> > In fact i didn't.
> > Same for the "move_row_up" macro that i just presented: there is no
> > need to press "Home" at the last step of the macro.
> > And it's even better without the "Home" in the sequence! Then you can
> > also add this in the end:
> > - unselect row: down arrow, up arrow
> > And the selected cell remains the same as it was initially.
> >
> > On 27 February 2013 11:26, Brian Barker <b.m.barker@btinternet.com> wrote:
> > > At 09:39 27/02/2013 +0000, Pierre Masci wrote:
> > > > Hello, with "Home" i can move to the start of the current row. How can i
> > > > do the same thing with a column?
> > >
> > >
> > > I don't know that you can.  But Ctrl+up-arrow may help.  If the cell
> > > immediately above is occupied, this moves to the top of the current block of
> > > data.  If it is not, this moves to the nearest cell (that is, the lowest) in
> > > the next contiguous block of data in the column.  So repeated use of
> > > Ctrl+up-arrow will get you to the top of the column.  This will work easily
> > > if most cells in your spreadsheet are occupied, but will be pretty useless
> > > with sparse data.
> > >
> > > Note that you can move about in similar ways using combinations of Ctrl plus
> > > the other three arrow keys.
> > >
> > > I trust this helps.
> > >
> > > Brian Barker
> > >
> > >
> > > --
> > > 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
>
> I opened Andrew's macro document and stole some code from there (see
> listing 6.14 – Select a single cell so it has an outline”), which
> after adding and removing some lines, looks like this (and it works):
>
> REM ***** BASIC *****
>
> Option Explicit
>
> Sub Main
>     Dim oSelection As Object
>     oSelection=ThisComponent.getCurrentSelection()
>
>     Dim iColumn As Integer, iSheet As Integer
>     iColumn=oSelection.getCellAddress().Column
>     iSheet=oSelection.getCellAddress().Sheet
>
>     Dim oSheet As Object, oCell As Object
>     oSheet=ThisComponent.getSheets().getByIndex(iSheet)
>     oCell=oSheet.GetCellbyPosition(iColumn, 0)
>
>     ThisComponent.CurrentController.Select(oCell)
>
>     Dim oRanges As Object
>     oRanges=ThisComponent.createInstance("com.sun.star.sheet.SheetCellRanges")
>     ThisComponent.CurrentController.Select(oRanges)
> End Sub
>
>
>
> Johnny Rosenberg
>
> --
> 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

-- 
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