Spreadsheet -- creating a shortcut key

Discuss the spreadsheet application

Spreadsheet -- creating a shortcut key

Postby Andynic » Wed Aug 22, 2018 1:25 pm

I read this post and followed the instructions substituting "rows" for "columns" assigning ^R for insert row:
=======
Re: shortcut to insert rows?

Postby kingfisher » Wed Nov 02, 2011 5:05 am
In my version of Open Office, there are no shortcut keys to insert rows or columns. You can create shortcuts using Tools > Customise > Keyboard tab.

On that tab, in the box labelled 'Category' select 'Insert'. In the next box (labelled 'Function'), scroll down to 'Insert Columns', for example. In the top box labelled "Shortcut Keys," select a shortcut you wish to use. Press the button labelled 'Modify' and the name of the function you have allocated to the shortcut keys will appear in the box at the bottom right labelled 'Keys'. When you have finished allocating shortcuts, press 'OK'.
Apache OpenOffice 4.1.2 (64 bit) on PCLinuxOS
=======

When I come back into the spreadsheet, it does not insert rows. ^R writes R in the cell in column A of the highlighted row ^r writes r in the cell --

What might I be doing incorrectly.

Thanks for your help.
Andynic
OpenOffice v 4.1.5
Mac OS High Sierra 10.13.5 on Macbook
Andynic
 
Posts: 2
Joined: Wed Aug 22, 2018 1:11 pm

Re: Spreadsheet -- creating a shortcut key

Postby Andynic » Wed Aug 22, 2018 2:04 pm

Just realized that in my version of Open Office, insert row already has a shortcut, namely holding down the option key and typing R.
Still, should not what I've done above, enable ^R?
OpenOffice v 4.1.5
Mac OS High Sierra 10.13.5 on Macbook
Andynic
 
Posts: 2
Joined: Wed Aug 22, 2018 1:11 pm

Re: Spreadsheet -- creating a shortcut key

Postby Villeroy » Wed Aug 22, 2018 2:19 pm

This works for me:
Calc_Shortcut.png

Strg is the German equivalent of Ctrl.
In the top-right corner you have to choose "Calc" rather than "OpenOffice". There are not many shortcuts making sense throughout the whole office suite.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28670
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Spreadsheet -- creating a shortcut key

Postby MrProgrammer » Thu Aug 23, 2018 7:12 am

Andynic wrote:shortcut to insert rows?
See Help → Index → shortcut keys;spreadsheets. There is a standard shortcut ⌘+ for this on your Mac and no need for you to create one.
Screen Shot 2018-08-22 at 23.43.24 .png

Here's how ⌘+ works:
• If N complete rows are selected, ⌘+ inserts N empty rows before them
• If N complete columns are selected, ⌘+ inserts N empty columns before them
• Otherwise ⌘+ opens the Insert Cells dialog.
So, to insert a row before row 5, I click the 5 at the left side of the screen to select row 5 then press ⌘+.
Or if a cell in row 5 is selected but not the entire row, I hold Shift and press the spacebar to select row 5, then press ⌘+.

Andynic wrote:I read this post and followed the instructions substituting "rows" for "columns" assigning ^R for insert row
Control key not recognized on Mac

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3946
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to Calc

Who is online

Users browsing this forum: Majestic-12 [Bot] and 30 guests