Good morning everyone!
How do I configure Calc so that when I write long text that wraps in a cell, the cell, once I’ve finished typing the text and hit Enter, automatically adjusts its height (and that of the entire line) to the text? I am attaching an image showing an example of how the current situation is. I know that I can do it manually or by acting on the appropriate command, but this only acts on the cell at the moment, and not for all cells automatically as I would like. In “optimum row height” the “Default value” option if unchecked does what I want to achieve, but it does it only for that row and manually. The next line I fill in does not retain this setting, but has to be repeated each time. Thanks in advance for the answers.
On the ribbon, you should be able to identify a small symbol with a number of horizontal lines and a downward curved arrow. It’s between the horizontal and vertical cell alignment indicators. This is “Word Wrap”. Select the entire sheet by left-clicking at the top left corner intersection of column header and row number. Left-click the word wrap button and that should do the trick.
Added. Also, while the entire sheet is selected, right-click the row numbers and select optimal height
It’s not the automatic system I was hoping for, but it’s still a good solution. Thank you very much!
You’re welcome. Something to note is that LO may sometimes lose track of the different heights if the contents are constantly edited or if rows are inserted. Obviously, selecting the entire sheet and redefining everything as word wrapped will correct that but it may be quicker to recognise which column contains the “usual suspects” and select the column by right clicking its header and resetting the word wrap for just that column