Row height automatically increase for additional lines of text?


When typing in a cell with wrap text automatically enabled, a new line automatically begins when the edge of the cell is reached.
This is great, however when I’ve finished typing oftentimes some of the text cannot be seen unless the cell containing the text is double-clicked (as the row is too narrow to show all lines of text).

I’m using version on Mac Lion.

It’s strange as I’m trying cells from 2 different documents now and in both examples from both documents wrap text automatically is set. However, in one of the documents the row height is increasing automatically as needed for additional lines of text and in the other it isn’t; instead it is only automatically creating new lines of text as needed, but not increasing the row’s height to allow them space to be seen.

I haven’t made any changes in terms of settings that might cause this discrepancy between the 2 documents….hmm…

How can I set Calc to do this?


“Fit to size” must be checked on the row height.

In LO and on Windows 8 if I set text wrapping on a cell then when the text exceeds the cell width the cell height increases as I type and remains on leaving the cell. This is what you said you wanted and seems to be the default setting. I don’t know of any settings to change this.

Please see my edited question. Thank you

This happens if the row height is not the default height, i.e. already set to some other height.

Why is this called answered when it is not? It’s a pretty simple question, how to make wrapped text increase row height to make all text visible in the column without adding a new line.

Your Answer means your answer to the original question. And obviously your text does not answer the question…

Answered means there are answers to the question, whether those are correct or not is left to be determined, and can be voted on and a correct answer be accepted.