how to get Libre Office to adjust row height to accommodate text entry?

Question

I need for LibreOffice to automatically adjust row height for text entries.

I have tried to acomplish this by checking the wrap text option, which I thought would be the solution, but it is not.

How can I do that?

Answer 1

Using LibreOffice Calc 5.4.4.2 on OS X, I found I had to do four things to set every row to its optimum height:

1. Select all cells
2. In the "Format" menu, turn on "Format/Text/Wrap Text"
3. In the "Format" menu, choose "Format/Rows/Optimal Height...", and in the resulting dialog set "Add" to "0.0" and turn on the "Default" checkbox
4. Add and then remove an empty column.

That last step sometimes isn't necessary, but at times LibreOffice will refuse to recalculate the row heights until you dope-slap it into submission.

Answer 2

You need to do both:

Format cells.... / Alignment / Wrap text automatically

and

Select the concerning cells or entire rows: right click on selected row numbers and choose 'optimal row height'

Part of the solution I found here.

Answer 3

I followed Daniel Griscom's answer but after adjusting cell contents you may have to Alt+Shift+Arrow Key (Optimizes the column width or row height based on the current cell).

Source: https://help.libreoffice.org/6.2/en-US/text/scalc/04/01020000.html

Answer 4

It seems to me that you must have one or other, or both, "Default" not ticked in Height/Optimal Height under Format Row.