How to wrap text in a cell in LibreOffice Calc
An image is worth a thousand words… so I got 2 thousand words (Plus change) right here:
Select in the Menu: Format → Cells…
Select in the Format Cells window: Alignment Tab
Select Wrap Text Automatically from the Properties section.
The end result will be something similar to this:
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 automatically wrap cells created before.1 See the following image:
The cell above was written before the option was activated. The bottom cell was written after the option was activated.
1 For those wanting to wrap all of their already existing cells in a spreadsheet, simply execute Ctrl+A, following by Ctrl+C, and finally Ctrl+V.
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.
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.