OpenOffice Calc: Forcing a carriage return in a cell?
Linux - SoftwareThis 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
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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.
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
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.
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.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.