Tools

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.

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 dialog box to replace the current word with a synonym, or a related term.

Language

Opens a submenu where you can choose language specific commands.

Redact

Redacting documents blocks out words or portions of a document for authorized 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.

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 dialog where you can solve an equation with a variable. After a successful search, a dialog with the results opens, allowing you to apply the result and the target value directly to the cell.

Solver

Opens the Solver dialog. 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 Submenu

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.

Macros

Lets you record or organize and edit macros.

Development Tools

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

XML Filter Settings

Opens the XML Filter Settings dialog, 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 Collabora Office extensions.

Customize

Customizes Collabora Office menus, context menus, shortcut keys, toolbars, and macro assignments to events.

Options

This command opens a dialog for a customized program configuration.

Please support us!