Tools
The Tools menu contains commands to check spelling, to trace sheet references, to find mistakes and to define scenarios.
You can also create and assign macros and configure the look and feel of toolbars, menus, keyboard and set the default options for LibreOffice applications.
Checks spelling manually.
Opens a sub-menu from which you can choose language-specific commands.
Sets the options for automatically replacing text as you type.
Opens a dialogue box in which you can solve an equation with a variable.
Opens the Solver dialogue box. A solver allows you to solve equations with multiple unknown variables by goal-seeking methods.
This command activates the Spreadsheet Detective. With the Detective, you can trace the dependencies from the current formula cell to the cells in the spreadsheet.
Defines a scenario for the selected sheet area.
The Protect Sheet or Protect Spreadsheet commands prevent changes from being made to cells in the sheets or to sheets in a document. As an option, you can define a password. If a password is defined, removal of the protection is only possible if the user enters the correct password.
Lets you record or organise and edit macros.
The Extension Manager adds, removes, disables, enables, and updates LibreOffice extensions.
Opens the XML Filter Settings dialogue box, in which you can create, edit, delete and test filters to import and to export XML files.
Customizes LibreOffice menus, context menus, shortcut keys, toolbars, and macro assignments to events.
This command opens a dialogue box for a customised program configuration.