Ask Your Question

Row height automatically increase for additional lines of text? [closed]

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

appreciatethehelp gravatar image

updated 2020-08-05 23:22:54 +0100

Alex Kemp gravatar image


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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2019-06-09 03:55:29.766261

4 Answers

Sort by » oldest newest most voted

answered 2019-06-09 03:55:07 +0100

appreciatethehelp gravatar image

"Fit to size" must be checked on the row height.

edit flag offensive delete link more

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

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 2019-03-25 18:59:07 +0100

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.

edit flag offensive delete link more


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.

erAck gravatar imageerAck ( 2019-03-25 20:30:56 +0100 )edit

Question Tools

1 follower


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

Seen: 2,378 times

Last updated: Jun 20 '19