Ask Your Question

Some default options

asked 2019-06-06 18:26:09 +0200

psaval gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-06-06 18:47:28 +0200

Opaque gravatar image

updated 2019-06-06 18:48:47 +0200


  • 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
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-06 18:26:09 +0200

Seen: 41 times

Last updated: Jun 06 '19