Page style apply on Loading a spreadsheet

Is it possible to load a page style automatically when i load in a different sheet. I set a template as default but as soon as i load the next file it is back to default scaling ? I also tried make a new style but as soon as i exit it is gone ?

[Solved] Change the default in Calc (View topic) • Apache OpenOffice Community Forum might help you

I think I may be experiencing the same issue, perhaps from a slightly different perspective. I have a .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 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.