I would like cell entries to automatically scale to the height required to show all cell contents. I have Word Wrap text turned on via the Default Style.
I select all cells and do Format → Rows → Optimal height with the Default Value checkbox checked. This will change row heights to that of the tallest cell which is good.
But, when I enter new text in other cells, I usually have to do Format Rows again or some information will be hidden. I think there must be some way to make this automatic without macros but I haven’t found it through the documentation or my searches.
I am presently on v24 but also saw this on v7.x
Thanks.
The Old Guy In The Club
Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 8; OS: macOS 10.15.7; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded