I have an .xls file that I need to open in LibreOffice Calc. When I do so, there are cells that are compressed such that multiple lines of text are displayed over the top of each other. This can be resolved by going to Format > Styles > Update Style, which then automatically enlarges the rows that need to display multiple lines of text. I would like to be able to change a global setting so that the style is automatically updated when I open the worksheet, but have been unable to find any such setting.
Is this possible?
Note: This would need to apply to all spreadsheets that get opened by LibreOffice, as I am working within a dynamic list of spreadsheets generated by other software, so I don’t believe that a template or macro will work in this setting, but I am willing to accept either as an answer if needed.