Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I am wondering how to wrap text in a single cell in libreoffice Calc. Does anyone know?

share|improve this question
add comment

5 Answers 5

up vote 10 down vote accepted

An image is worth a thousand words... so I got 2 thousand words (Plus change) right here:

  1. Select in the Menu: Format -> Cells...

    enter image description here

  2. Select in the Format Cells Window: Alignment Tab

    enter image description here

  3. Select Wrap Text Automatically from the Properties Section.

The end result will be something similar to this:

enter image description here

Note that, at least up to LibreOffice 4.0, this option only works on cells that I written in after the option is activated. It will not work with the ones that were created before. See the following image:

enter image description here

The cell above was written before the option was activated. The bottom cell was written after the option was activated.

share|improve this answer
    
I use a dutch version so I could not make nice images :( Can you check if when you set this BEFORE typing it changes wrap? Mine did not... –  Rinzwind Mar 25 '13 at 12:49
    
Mine does not either. For what I can see (Even on LibreOffice 4.0) is that it takes effect on newly written cells. Not one already created ones. Will make an image of this. –  Luis Alvarado Mar 25 '13 at 12:59
    
Thanks...that did the magic. :) Do you know if there is a way to add that to the toolbar instead of accessing it all the time thru the menu? –  Elysium Mar 26 '13 at 15:03
    
@Elysium You can select all the cells then apply the above option to do them all at once. –  gmaggio Jun 12 at 3:28
    
What if I want to wrap text but I do not want cell height to change automatically? –  Trismegistos Jul 1 at 17:55
show 2 more comments

You can use Format > Cells > Alignment to have a variety of effects including Wrap text automatically.
Use Ctrl+Enter to have more than one line of text per cell if that's what you mean.

share|improve this answer
add comment

Manually

Type control + enter from inside a cell.

Automatically

Seems bugged if you set it before editing the cell: https://bugs.freedesktop.org/show_bug.cgi?id=57519

Setting the 'wrap' from a column or field in the tab 'alignment' works but you need to do this after inserting text.

share|improve this answer
add comment

http://extensions.libreoffice.org/extension-center/wrap-unwrap-insert-copied-row-or-column-and-paste-value/releases/1.0.1

This extension for calc create a toolbar which has button for wrap text in selected cell(s), unwrap text in selected cell(s), insert copied row(s) or cell(s), insert copied column(s)or cell(s) and paste value

share|improve this answer
add comment

Select the cell, follow the path "Format\Cells\Allignment" and mark "Wrap text automatically".

share|improve this answer
    
There isnt such a "wrap text automatical" option there. –  Elysium Mar 25 '13 at 10:25
1  
@Elysium The option is "Wrap text automatically." It appears near the bottom off the window. Make sure the Alignment tab is up. –  Eliah Kagan Mar 25 '13 at 11:40
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.