Skip to content

start:

This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

These automatisms suck!!

OpenOffice is configured in standard to execute, while typing a text, automatical formatting tasks. Those automatisms can be amazing or boring - especially because they can occure when you don't expect them.

You have two solutions: turn them off or learn to know them and domesticate them.

  • Turn them ALL off/on: under Format-AutoFormat-While Typing.

  • Turn some of them off/on: under Tools-AutoCorrect/Autoformat.

To USE them you have to know them and first recognize them, so...

How to recognize them?


When I type

I get

caused by

module

DNA

And

the replacement table

(3)
(1)

All

XImport

Ximport

 

(3)

All

coordination

Coordination

Capitalize first letter of every sentence

(3)

All

It was excl. on this day

The lowercase won't be replaced by a capital though there is a dot and I check the option "Capitalize first letter of every sentence" in the AutoFormat.

the exceptions table

(2)

Writer only

*Hello* _world_

Hello world

Automatic bold and underline

(3)

All

www.openoffice.org
john@sun.com

www.openoffice.org
john@sun.com

The URL recognition

(3)

All

1st, 2nd, 4th

1st, 2nd, 4th

The AutoFormat of the cardinal numbers

(3)

All

1/2 1/4 3/4

½ ¼ ¾

The AutoFormat of

(3)

All

The man -- yes, him!
The man--yes, him!

The man – yes, him!
The man—yes, him!

Replace dashes

(3)

All

<2_spaces>

The second space doesn't appear

Ignore double spaces

(3)

All

1 bottle of milk <Return>

1. bottle of milk
2.

Apply numbering

(3)

Writer only

---<Return> ===<Return> ___<Return>

horizontal lines created

Apply border

(3)

Writer only

+---+---+

a table

Create table

(3)

Writer only

My title
<Return>
<Return>

My title

Use styles

(3)

Writer only

- one
-

  • one

  • test

Replace bullets

(3)

Writer only

"

« or an other typographical quote

Custom quotes

(4)

Writer only

Int

Int|roduction|
(the word is completed)

Word completion

(5)

 

1.1
in a table

01/01/03
(a date)

Number recognition

(6)

Writer only
(1) Menu Tools-AutoCorrect/AutoFormat, tabpage [Replace]
(2) Menu Tools-AutoCorrect/AutoFormat, tabpage [Exceptions]
(3) Menu Tools-AutoCorrect/AutoFormat, tabpage [Options]
(4) Menu Tools-AutoCorrect/AutoFormat, tabpage [Custom quotes]
(5) Menu Tools-AutoCorrect/AutoFormat, tabpage [Word completion]
(6) Menu Tools-Options-Text document-Table-Input in table-Number recognition

Documentation / User FAQ / Calc / Previous-Next