Contents

# Tools

Contains spelling tools, redact options, mail merge wizard, macros, development tools, extension manager, as well as tools for configuring and customizing menus, and setting program preferences.

The Tools menu contains commands to check spelling, to trace sheet references, to find mistakes and to define scenarios, as well as tools for configuring menus, and setting program preferences.

Contains spelling tools, media player, color replacer, presentation minimizer and tools for configuring menus, and setting program preferences.

This menu provides tools for LibreOffice Draw as well as access to language and system settings.

To access this command...

#### From the menu bar:

Choose Tools.

## Spelling

Checks spelling manually.

## Automatic Spell Checking

Automatically checks spelling as you type, and underlines errors.

## Thesaurus

Opens a dialogue box to replace the current word with a synonym, or a related term.

## Language

Opens a sub-menu from which you can choose language-specific commands.

## Redact

Redacting documents blocks out words or portions of a document for authorised use or viewing.

## Auto-Redact

Use automatic redaction to define words and patterns that are automatically marked for redaction.

## ImageMap Editor

Allows you to attach URLs to specific areas, called hotspots, on a graphic or a group of graphics. An image map is a group of one or more hotspots.

## Word Count

Counts the words and characters, with or without spaces, in the current selection and in the whole document. The count is kept up to date as you type or change the selection.

## Accessibility Check

Review common accessibility problems in the document, and support for PDF/UA specifications in the PDF export dialogue box.

## Translate

Translate the selected text or the whole document using DeepL automatic translation.

## AutoCorrect

Automatically formats the file according to the options that you set under Tools - AutoCorrect - AutoCorrect Options.

## AutoText

Creates, edits, or inserts AutoText. You can store formatted text, text with graphics, tables and fields as AutoText. To quickly insert AutoText, type the shortcut for the AutoText in your document, and then press F3.

## Heading Numbering

Specify the numbering format used for automatic numbering of headings in the current document.

## Line Numbering

Adds or removes and formats line numbers in the current document.

## Footnotes/Endnotes Settings

Specifies the display settings for footnotes and endnotes.

## Mail Merge Wizard

Starts the Mail Merge Wizard to create form letters or send email messages to many recipients.

## Bibliography Database

Insert, delete, edit and organise records in the bibliography database.

## Address Book Source

Edit the field assignments and the data source for your address book.

## Update

Updates items in the current document that have dynamic contents, so as fields and indexes.

## Protect Document

Toggles write protection for fields and bookmarks in the document.

## Calculate

Calculates the selected formula and copies the result to the clipboard.

## Sort

Sorts the selected paragraphs or table rows alphabetically or numerically. You can define up to three sort keys as well as combine alphanumeric and numeric sort keys.

## AutoCorrect Options

Sets the options for automatically replacing text as you type.

## AutoInput

Switches the AutoInput function on and off, which automatically completes entries, based on other entries in the same column. The column is scanned up to a maximum of 2000 cells or 200 different strings.

## Goal Seek

Opens a dialogue box in which you can solve an equation with a variable. After a successful search, a dialogue box with the result opens, allowing you to apply the result and the target value directly to the cell.

## Solver

Opens the Solver dialogue box. A solver allows you to solve mathematical problems with multiple unknown variables and a set of constraints on the variables by goal-seeking methods.

## Detective

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.

## Scenarios

Defines a scenario for the selected sheet area.

## Forms Sub-menu

Contains commands for activate form design mode, enable/disable control wizards and insert form controls in your document.

## Share Spreadsheet

Sharing a spreadsheet allows several users to open the same file for editing at the same time.

## Protect Sheet

Protects the cells in the current sheet from being modified.

## Protect Spreadsheet Structure

Protects the sheet structure of your document from modifications. It is impossible to insert, delete, rename, move or copy sheets.

## Presentation Minimizer

Opens the Presentation Minimizer dialog to reduce the file size of the current presentation.

## Colour Replacer

Opens the Colour Replacer dialogue box, where you can replace colours in bitmap and meta file graphics.

## Media Player

Opens the Media Player window in which you can preview movie and sound files as well as insert these files into the current document.

## Forms Sub-menu

Contains commands for activate form design mode, enable/disable control wizards and insert form controls in your document.

## Colour Replacer

Opens the Colour Replacer dialogue box, where you can replace colours in bitmap and meta file graphics.

## Media Player

Opens the Media Player window in which you can preview movie and sound files as well as insert these files into the current document.

## Forms Sub-menu

Contains commands for activate form design mode, enable/disable control wizards and insert form controls in your document.

## Macros

Lets you record or organise and edit macros.

## Development Tools

Inspects objects in LibreOffice documents and shows supported UNO services, as well as available methods, properties and implemented interfaces.

## XML Filter Settings

Opens the XML Filter Settings dialogue box, where you can create, edit, delete, and test filters to import and to export XML files.

## Extension Manager

The Extension Manager adds, removes, disables, enables, and updates LibreOffice extensions.

## Customize

Customises LibreOffice menus, context menus, shortcut keys, toolbars, and macro assignments to events.

## Options

This command opens a dialogue box for a customised program configuration.