LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-28-2009, 10:20 AM   #1
peteyperson
Member
 
Registered: Jan 2009
Distribution: openSUSE 11.1, with KDE 4
Posts: 71

Rep: Reputation: 16
OpenOffice Calc: Forcing a carriage return in a cell?


Hi,

In Excel you can force a carriage return within a cell, i.e. to have two lines of text in a cell but determine where the line breaks, but I cannot figure how to do the same with OpenOffice Calc.

Anyone know?

Thanks,
Petey

Last edited by peteyperson; 02-28-2009 at 10:21 AM.
 
Old 02-28-2009, 11:07 AM   #2
David the H.
Bash Guru
 
Registered: Jun 2004
Location: Osaka, Japan
Distribution: Arch + Xfce
Posts: 6,852

Rep: Reputation: 2037Reputation: 2037Reputation: 2037Reputation: 2037Reputation: 2037Reputation: 2037Reputation: 2037Reputation: 2037Reputation: 2037Reputation: 2037Reputation: 2037
From the Open Office help pages (remember those?):

Quote:
Inserting line breaks in OpenOffice.org Calc spreadsheet cells

To insert a line break in a spreadsheet cell, press the Ctrl+Enter keys.
This will work only with the text edit cursor inside the cell, not at the input line. So first double-click the cell, then single-click at the text position where you want the line break.

Formatting OpenOffice.org Calc cells for automatic line wrapping

1.Select the cells for which you want an automatic line break.
2.Choose Format - Cells - Alignment.
3.Select Wrap text automatically.

Last edited by David the H.; 02-28-2009 at 11:10 AM. Reason: minor edit
 
Old 03-09-2009, 11:26 AM   #3
tobindia
LQ Newbie
 
Registered: Mar 2009
Posts: 2

Rep: Reputation: 0
Manual line break in Calc

OK, I have checked the help pages, and I have followed the instructions (cursor inside cell, cell formatted with "Wrap text automatically", but Ctrl-Enter still doesn't cause a break in the line inside the cell. Using version 3.0.0 on a MacBook OS X 10.5.
 
Old 03-09-2009, 01:37 PM   #4
farslayer
LQ Guru
 
Registered: Oct 2005
Location: Northeast Ohio
Distribution: linuxdebian
Posts: 7,249
Blog Entries: 5

Rep: Reputation: 191Reputation: 191
Dunno what to tell you, I just tried it in OO.o calc 2.4 and OO.o 3.0 and it worked perfectly on both..

You clicked twice in the cell so the cursor showed up where you wanted the text to break ?
 
Old 03-09-2009, 07:23 PM   #5
tobindia
LQ Newbie
 
Registered: Mar 2009
Posts: 2

Rep: Reputation: 0
Yes, I clicked twice. Cursor was where I wanted it. Pressed (and held) Control, then pressed Enter. No line break...
 
Old 03-09-2009, 09:43 PM   #6
jimjones
Member
 
Registered: May 2005
Location: Belgium
Distribution: slackware 10.2
Posts: 43

Rep: Reputation: 15
just off the top of my head ...

if you want to force a linebreak shouldnt you turn off autowrap?
 
Old 03-09-2009, 11:48 PM   #7
farslayer
LQ Guru
 
Registered: Oct 2005
Location: Northeast Ohio
Distribution: linuxdebian
Posts: 7,249
Blog Entries: 5

Rep: Reputation: 191Reputation: 191
Good question,

I applied no formatting to the Cell before testing, and it worked fine..
I just tried again with auto-wrap enabled and it still works..

Maybe there is a bug in the mac version ?
 
Old 03-20-2009, 09:53 AM   #8
peq
LQ Newbie
 
Registered: Mar 2009
Posts: 1

Rep: Reputation: 0
Pressing the Ctrl+Enter keys inserts a manual line break. This shortcut only works directly in the cell, not in the input line.
 
Old 03-20-2009, 01:10 PM   #9
gael
Member
 
Registered: Aug 2008
Posts: 41

Rep: Reputation: 15
On Mac, try command (Apple key) and enter. It works for me!
And it works even with "Wrap text automatically" enabled.
Gael
 
Old 08-03-2009, 08:30 AM   #10
lostcarpark
LQ Newbie
 
Registered: Aug 2009
Posts: 4

Rep: Reputation: 0
Thanks for the tips! I finally figured it out.

You have to be editing the cell directly, not in the edit bar. To edit a cell directly, click on it and press F2. You can then move around the text and press ctrl+enter to enter line breaks.

Thanks for the help.

James
 
Old 08-03-2009, 09:16 AM   #11
catkin
LQ 5k Club
 
Registered: Dec 2008
Location: Tamil Nadu, India
Distribution: Debian
Posts: 8,578
Blog Entries: 31

Rep: Reputation: 1208Reputation: 1208Reputation: 1208Reputation: 1208Reputation: 1208Reputation: 1208Reputation: 1208Reputation: 1208Reputation: 1208
Quote:
Originally Posted by lostcarpark View Post
To edit a cell directly, click on it and press F2.
Or you can double click on it which is quicker.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
grep detecting carriage return, how ? Grafbak Programming 22 01-13-2010 01:19 PM
workaround for C++ printf carriage return idc12 Programming 2 09-11-2006 12:13 PM
carriage return in emac lisp balloon Programming 1 11-23-2004 08:29 AM
unescaping a carriage return in perl acid_kewpie Programming 10 09-20-2002 02:20 PM
pppd...carriage return?!? icyfire Linux - Software 1 02-14-2002 07:07 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:16 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration