[Solved] Keyboard Shortcuts

Discuss the spreadsheet application

[Solved] Keyboard Shortcuts

Postby baynoli » Thu Dec 20, 2007 3:27 am

Hello everyone, Good Day! and happy holidays.
I'm new to open office, although I have heard this along time ago way back 2001. My question is, Is there an equivalent keyboard shortcut for open office in relation to MSOffice? I am using OpenOffice Calc, in MSOffice I usually use Alt+Enter to encode multiple lines in one Cell, I try in OO_Calc but it will not move on the next line, instead I used the space bar to move the cursor to the next line. I hope there is an keybrd shortcut on this.

Hoping for a positive response on this.

Thank you,
Noli
Last edited by Hagar Delest on Tue Jun 10, 2008 1:25 pm, edited 2 times in total.
Reason: tagged the thread as Solved and moved it to the right forum.
baynoli
 
Posts: 5
Joined: Thu Dec 20, 2007 2:59 am

Re: Keyboard Shortcuts

Postby acknak » Thu Dec 20, 2007 4:48 am

Double-click the cell text, so you get the editing cursor in the cell itself (not on the formula entry bar. Now, when you want to enter a line break, type Ctrl+Enter.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Keyboard Shortcuts

Postby baynoli » Thu Dec 20, 2007 5:27 am

Thank you for the reply, I try it and it works, instead of ALT+Enter(MSExcel), its' Ctrl+Enter(OpenOfficeCalc).

Thank's acknak.
baynoli
 
Posts: 5
Joined: Thu Dec 20, 2007 2:59 am

Re: Keyboard Shortcuts

Postby huw » Thu Dec 20, 2007 12:15 pm

If you are working with strings, be aware that soft line breaks are sometimes evaluated as spaces - issue 83666.

Also, just so you know, in Writer a soft line break is Shift+Enter.

Edit: corrected terminology
huw
Volunteer
 
Posts: 417
Joined: Wed Nov 21, 2007 1:57 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 32 guests