2013/2/28 pierre masci <[email protected]>: > 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 <[email protected]> wrote: >> 2013/2/27 pierre masci <[email protected]>: >>> 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 <[email protected]> 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: [email protected] >>>> 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: [email protected] >> 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: [email protected] 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
