Options
Select the options for automatically correcting errors as you type, and then click OK.
To access this command...
Choose Tools - AutoCorrect - AutoCorrect Options - Options tab.
In text documents, you can choose to apply [T] AutoCorrect options while you type. Enable this feature by using Tools - AutoCorrect - While Typing.
You can also apply [M] AutoCorrect options to a selection or a whole document of existing text by using Tools - AutoCorrect - Apply. In general, [M] options are applied only to paragraphs with Default Paragraph Style.
All non-empty paragraphs with "Default Paragraph Style" are converted to "Text Body" paragraph style when Tools - AutoCorrect - Apply is used.
[M] and [T] options
Use replacement table
If you type a letter combination that matches a shortcut in the replacement table, the letter combination is replaced with the replacement text.
Correct TWo INitial CApitals
If you type two upper-case letters at the beginning of a "WOrd", the second upper-case letter is automatically replaced with a lower-case letter.
No corrections are made to entries found in an applicable spelling dictionary.
Capitalise first letter of every sentence.
Capitalises the first letter of every sentence
The first letter in a Calc cell will never be capitalised automatically.
Automatic *bold*, /italic/, -strikeout- and -underline-
Automatically applies bold, italic, strikethrough or underline formatting to text enclosed by asterisks (*), slashes (/), hyphens (-), and underscores (-), respectively. These characters disappear after the formatting is applied.
This feature does not work if the formatting characters * / - - are entered with an Input Method Editor.
URL Recognition
Automatically creates a hyperlink when you type a URL.
Replace Dashes
Replaces one or two hyphens with a long dash (see the following table).
Text will be replaced after you type a trailing white space (space, tab, or return). In the following table, the A and B represent text consisting of letters A to z or digits 0 to 9. N represents digits only.
| Text that you type: | Result that you get: |
|---|---|
| A - B (A, space, minus, space, B) | A – B (A, space, en-dash, space, B) |
| A -- B (A, space, minus, minus, space, B) | A – B (A, space, en-dash, space, B) |
| A--B (A, minus, minus, B) | A—B (A, em-dash, B)(see note below the table) |
| N--N (N, minus, minus, N) | N–N (N, en-dash, N) |
| A-B (A, minus, B) | A-B (unchanged) |
| A -B (A, space, minus, B) | A -B (unchanged) |
| A --B (A, space, minus, minus, B) | A –B (A, space, en-dash, B) |
If the text has the Hungarian or Finnish language attribute, then two hyphens in the sequence A--B are replaced by an en-dash instead of an em-dash.
Delete spaces and tabs at beginning and end of paragraph
Removes spaces and tabs at the beginning of a paragraph. To use this option, the Apply Styles option must also be selected.
Delete spaces and tabs at end and start of line
Removes spaces and tabs at the beginning of each line. To use this option, the Apply Styles option must also be selected.
[T] options only
Ignore double spaces
Replaces two or more consecutive spaces with a single space.
Correct accidental use of cAPS LOCK key
Inverts a capitalised word entered with the Caps Lock key enabled, after a space is entered, and disables the Caps Lock key. For example, entering Libre with Caps Lock enabled appears as lIBRE, which is converted automatically to Libre.
Bulleted and numbered lists. Bullet symbol:
Automatically creates a numbered list when you press Enter at the end of a line that starts with a number followed by a full stop, a space, and text. If a line starts with a hyphen (-), a plus sign (+), or an asterisk (*), followed by a space, and text, a bulleted list is created when you press Enter.
To cancel automatic numbering when you press Enter at the end of a line that starts with a numbering symbol, press Enter again.
The automatic numbering option is only applied to paragraphs that are formatted with the "Default", "Text body", or "Text body indent" paragraph style.
Apply border
Automatically applies a border at the base of the preceding paragraph when you type three or more specific characters, and then press Enter.
-
To create a single line, type three or more hyphens (
-), or underscores (-), and then pressEnter. To create a double line, type three or more equal signs (=), asterisks (*), tildes (~), or hash marks (#), and then pressEnter.
The following table summarises the line thickness for the different characters:
| --- | 0.05pt single underline |
| --- | 1.0pt single underline |
| === | 1.0pt double underline |
| *** | 4.0pt thick-thin double underline |
| ~~~ | 4.0pt thin-thick double underline |
| ### | 2.5pt double underline |
-
To modify attributes of a predefined border, such as colour, style, width and shadow, click the paragraph above the line, choose Format - Paragraph - Borders tab.
-
To delete the created line, click the paragraph above the line, choose Format - Paragraph - Borders, delete the bottom border.
To remove a line created with Apply Border, place the cursor above the line, press Ctrl+M.
Create table
+-----------------+---------------+------+
Apply Styles
Automatically apply a Heading 1 to Heading 8 paragraph style to a text that starts with an uppercase letter and does not end with a period.
To get a Heading 1 paragraph style, type the text that you want to use as a heading, then press Enter twice.
For other Heading N styles, press the Tab key N-1 times before typing the text to get the desired level. For example, to get a "Heading 4" paragraph style press the Tab key three times, type something, then press Enter twice.
This feature works only with "Default Paragraph Style", "Text Body" and "Text Body Indent" paragraph styles, and there must be one empty paragraph before the text, if the text is not at the top of a page.
[M] options only
Remove blank paragraphs
Removes empty paragraphs and paragraphs that contain only spaces or tabs from the current document. This option works for any paragraph style.
Replace Custom Styles
Replaces custom paragraph styles applied in the current document to "Text Body", "Text Body Indent", "First Line Indent" or "Hanging Indent" paragraph style.
Replace bullets with
Converts paragraphs that start with a hyphen (-), a plus sign (+), or an asterisk (*) directly followed by a space or a tab, to bulleted lists. This option only works on paragraphs that are formatted with the "Default Paragraph Style". To change the bullet style that is used, select this option, and then click Edit.
Combine single line paragraphs if length greater than...
Combines consecutive single-line paragraphs into a single paragraph. This option only works on paragraphs that use the "Default" paragraph style. If a paragraph is longer than the specified length value, the paragraph is combined with the next paragraph. To enter a different length value, select the option, and then click Edit.
Edit
Modifies the selected AutoCorrect option.
Dialog Buttons
Reset
Resets modified values back to the tab page previous values.
Cancel
Closes dialogue box and discards all changes.
OK
Saves all changes and closes dialogue box.