Calc: Customize 'General' number format

Is there any way I can adjust the behaviour of the default ‘General’ number format in LibreOffice Calc? In particular, I’d like to set it to use thousands separators.

I know how to customize the format of any particular cell, but:

  • This requires me to apply the format manually to the cells in question, instead of having it just work like I want it to by default
  • The General format does a lot of things automatically - real numbers are displayed with the right number of decimal places, integers are displayed with no decimal sign at all, if I type in a number as a percentage or dollar amount it automatically gets formatted correctly - which I lose if I apply a specific number format to a cell

Modify the Default style in the Styles and Formatting sidebar. Changes apply throughout the current spreadsheet. To change all new spreadsheets as well, modify the default template.

…real numbers are displayed with the right number of decimal places.

A limited number of decimal places can be set at Tools → Options → LibreOffice Calc → Calculate → Limit decimals for general number format.

…if I type in a number as a percentage or dollar amount it automatically gets formatted correctly.

This behavior depends on settings at Tools → Options → Language Settings → Languages.

Using the Styles and Formatting sidebar, I am able to change the default number format from ‘General’ to a specific format code of my choosing, but that’s not what I’m asking. What I’m trying to do is change the behaviour of the ‘General’ format. The ‘General’ format does various magic things that, as far as I can tell, cannot be done with other format codes. I want to keep that magic, while also having thousands separators.