Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


2013/2/28 pierre masci <piemas25@gmail.com>:
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.



You’re welcome!
:)


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

He he he… it's easy to see what part I wrote and what part I stole;
there is some inconsistency in the code…
”ThisComponent.getCurrentSelection()”
I use a method to get the current selection.

”ThisComponent.CurrentController.Select(oCell)”
To be consistent, I think I could have written the following instead:
”ThisComponent.getCurrentController().Select(oCell)”
or something like that.

Well, now I didn't and it still works…


Johnny Rosenberg




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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.