« Macros: Getting Cell Information | Main | Basic functions: REPT »
November 26, 2004
Autocorrect
When entering text in OO Calc cells, you may notice that the program makes assumptions about what you are typing and you get unwanted corrections.These corrections are completely configurable throught the AutoCorrect dialog.
The AutoCorrect dialog is invoked by selecting Tools - AutoCorrect as shown below.
The Options tab presents some optional corrections that OOo Calc can perform on any text entered by the user. From the identifier of each option, it should be easy to understand what OOo Calc plans to do - if that option is enabled.
In particular, the user can make use of a replacement table of common mispellings. The replacement table is fully configurable via the Replace tab - shown below.For example, if "acn" is a string you use often (a name of a company perhaps) OOo Calc will always insist on replacing it with "can". By removing this particular entry from the replacement table, OOo Calc will leave "acn" alone.
The Exceptions tab - see below - allows the user to prevent OOo Calc from correcting certain 2-letter initial cap combinations.
Finally, the Custom Quotes tab allows the user to replace single/double quotation marks with any characters of his/her choosing.
Posted by Dave at November 26, 2004 03:14 AM
Comments
You must point out that there is a easy way to make certain cells intouchable by Autocorrent putting a sigle quote "'" in front of the cell content.
Doing this you've ensured that the cell content is not modified for autocorrect.
BUT BEWARE! Do it in cells without formulas or in text cells because the cell content will be shown as text.
If anyone knows a more simple trick do put autocorrect off in a easy way, please leave a coment here!
Posted by: Pere at December 24, 2005 11:46 AM