How do I get dynamic change of height in rows or cells?

libreoffice-calc

Solution

Highlight the cells you want to format in this way.

From the `Format` menu, select `Cells...` (keyboard shortcut Ctrl+1).

Go to the `Alignment` tab.

Check `Wrap text automatically`.

Click `OK`.

Problem

How to get dynamic height in a cell? If I put too much text in a cell it will not show all the info since it's not room for it. I want my calcsheet to dynamically change the height in the entire row when needed.

Original source