Using LibreOffice 7.4.7.2, Debian 12, KDE
The cell has the following value
Line1
Line2
Line3
Line4
But it only shows Line1 and a bit of the next line. Can you please show how to make the cell height to expand automatically to show all the text content?
Thanks very much for any help
ANSWER: copied from @JohnSUN comments below
LibreOffice calc 7.4: Menu Format, Rows, Optimal Height. Leave "Default value" option checked. Click OK. Documentation: Optimal Row Height
LibreOffice calc 7.6+: no need to do anything. The row height increases immediately after typing is completed
