23

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?

4 Answers 4

15

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.

4
  • Thank you @Daniel. Exactly what I'm looking for! :)
    – Clicker
    Apr 8, 2020 at 9:03
  • 1
    Everytime I change text, I have to reset height to 0.0
    – Adam
    Jul 17, 2020 at 18:22
  • 1
    My god! This works! I can't believe it! It's half an hour that I try to auto-set optimal width for all columns! Just setting 0.0 default in optimal width did the trick! Thanks man!
    – Avio
    Mar 19, 2021 at 11:26
  • Seconding Adam's comment. Selecting all rows + invoking the Optimal Height dialog box does adjust the row heights properly, but only once. It doesn't fix the underlying problem, which is that the rows don't auto-adjust.
    – Violets
    Aug 2, 2021 at 10:09
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.

    0

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

    0

    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

    2

    You must log in to answer this question.

    Not the answer you're looking for? Browse other questions tagged .