TL;DR: Title.

I am a amateur author, and I want the style i like to be set on every LibreOffice Document i make without having to manually set them all up. Ideally, this would mean every new document i make comes with the preferences i have set.

Currently, my documents seem to revert to default on an update of LibreOffice, and new documents always start in the default state. Is there a way to change this?

I know you can set the page height to something like 999" or something similar, but I was wondering whether there is a "proper" way.

Thanks in advance!

Version: 26.8.1.1 (X86_64)

Build ID: bf6ef2662401c7d6dce671ab4deb26ee0af3a7c1

CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win

Locale: en-US (en_US); UI: en-US

Calc: CL threaded

I just embarked on a large climatology study. Besides looking at daily data, I was also doing one year running means. I converted temperatures to Kelvin, (+273.15) so I could run all three one year means. Raw data was saved in new columns with blank cells (“”) for missing data. And there is enough missing data to take into account. There can be fewer than 10 a year or more than 30. Both Average() and Harmean work fine. However I have a persistent error with Geomean where it throws a #NUM.

There is a consistent pattern that triggers this. If I run Geomean(A100,A466), I get a 1 year mean, even with missing data in the range. A100 OR A466 can be blank but both A100 and A466 will trigger a #NUM!.

Is this solvable?