Ask Your Question

Row height automatically increase for additional lines of text?

asked 2017-05-29 10:31:54 +0100

appreciatethehelp gravatar image

updated 2017-05-30 09:36:47 +0100


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?


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-05-29 17:52:20 +0100

peterwt gravatar image

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.

edit flag offensive delete link more


Please see my edited question. Thank you

appreciatethehelp gravatar imageappreciatethehelp ( 2017-05-30 09:37:43 +0100 )edit

answered 2017-05-29 18:16:40 +0100

erAck gravatar image

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

edit flag offensive delete link more


It's still happening even when the row is the default height (4.52mm)

appreciatethehelp gravatar imageappreciatethehelp ( 2017-05-30 09:38:02 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-05-29 10:31:54 +0100

Seen: 536 times

Last updated: May 30 '17