How to select a line height and make it my default height?
The line heights reverts back to the default when I delete data from it, when I copy data from another line it also reverts back some lines of the spreadsheet after its saved. Thank you.
Right-click the row header at the left, select ‘Row height’. Enter your desired height and select the ‘Make default height’ checkbox. Does that keep your sizes?
Also, if you don’t need other formatting, when you paste you can try right-click and use Paste Special.
That said, LO can be quirky about line heights, particularly when there are cell entries with multiple lines, or when using auto-wrap.
In any cell of the desired row, define a character size to change the row height.