Some default options

Dear Libre Office community:

There are a couple of default options i need to change by default and i could find where:

1st is the auto-complete option in calc. Completing a cell with existing ones when starting to type figures or dates is something i dont really like.

The other is that when sorting data, in the option tab is the “include format”, which i really find annoying in my case. I would like to turn that off

Thanks in advance, and keep the comunity great


  • Switch off Autocomplete: Untick Tools -> Autoinput
  • Switch off “Include Format”: Set the option as per your preference and File -> Save As Template provide a template name (e.g. MyDefaultSheet), select a template category and tick Set as default template