Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Deactivating Automatic Changes

By default, Office automatically corrects many common typing errors and applies formatting while you type. You can immediately undo any automatic changes with Ctrl+Z.

The following shows you how to deactivate and reactivate the automatic changes in Office Calc:

Automatic Text or Number Completion

When making an entry in a cell, Office Calc automatically suggests matching input found in the same column. This function is known as AutoInput.

To turn the AutoInput on and off, set or remove the check mark in front of Tools - AutoInput.

Automatic Conversion to Date Format

Office Calc automatically converts certain entries to dates. For example, the entry 1/1 may be interpreted as 1st January of the current year, according to the locale settings of your operating system, and then displayed according to the date format applied to the cell.

To ensure that an entry is interpreted as text, add an apostrophe at the beginning of the entry. The apostrophe is not displayed in the cell.

Quotation Marks Replaced by Custom Quotes

Choose Tools - AutoCorrect - AutoCorrect Options. Go to the Localised Options tab and unmark Replace.

Cell Content Always Begins With Upper-case

Choose Tools - AutoCorrect - AutoCorrect Options. Go to the Options tab. Unmark Capitalise first letter of every sentence.

Replace Word With Another Word

Choose Tools - AutoCorrect - AutoCorrect Options. Go to the Replace tab. Select the word pair and click Delete.