From e50d669aa1102b4aa10b4654ad41dc4cdf0025f7 Mon Sep 17 00:00:00 2001 From: Rüdiger Timm Date: Fri, 26 Nov 2004 15:25:58 +0000 Subject: INTEGRATION: CWS helpcontentbeta (1.1.2); FILE MERGED 2004/10/14 13:43:59 fpe 1.1.2.3: Regular Update 2004/10/06 14:55:24 fpe 1.1.2.2: Regular Update 2004/09/16 11:46:24 fpe 1.1.2.1: Regular Update --- helpcontent2/source/text/scalc/guide/auto_off.xhp | 100 +++++++++++----------- 1 file changed, 51 insertions(+), 49 deletions(-) (limited to 'helpcontent2/source/text/scalc/guide/auto_off.xhp') diff --git a/helpcontent2/source/text/scalc/guide/auto_off.xhp b/helpcontent2/source/text/scalc/guide/auto_off.xhp index fb11aa05d1..2c6e625e49 100755 --- a/helpcontent2/source/text/scalc/guide/auto_off.xhp +++ b/helpcontent2/source/text/scalc/guide/auto_off.xhp @@ -1,4 +1,4 @@ - + - - - - -Deactivating Automatic Changes -/text/scalc/guide/auto_off.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - - + ************************************************************************--> + + + + +Deactivating Automatic Changes +/text/scalc/guide/auto_off.xhp + + +Sun Microsystems, Inc. +converted from old format - fpe + + -deactivating; automatic changes -tables; deactivating automatic changes in -AutoInput function;on/off -text in cells;AutoInput function -cells; AutoInput function of text -input support in spreadsheets -changing; input in cells -AutoCorrect function;cell contents -cell input;AutoInput function -lowercase letters;AutoInput function (in cells) +deactivating; automatic changes +tables; deactivating automatic changes in +AutoInput function;on/off +text in cells;AutoInput function +cells; AutoInput function of text +input support in spreadsheets +changing; input in cells +AutoCorrect function;cell contents +cell input;AutoInput function +lowercase letters;AutoInput function (in cells) capital letters;AutoInput function (in cells) - +date formats;avoiding conversion to + Deactivating Automatic Changes - + By default, $[officename] automatically corrects many common typing errors and applies formatting while you type. You can immediately undo any automatic changes with Command -Ctrl+Z. -The following shows you how to deactivate and reactivate the automatic changes in $[officename] Calc: -Automatic text or number completion -When making an entry in a cell, $[officename] 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 - Cell Contents - AutoInput. - - -Automatic conversion to date format -$[officename] Calc automatically converts certain entries to dates. For example, the entry 1.1 may be interpreted as January 1 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.for sure 1.1 will not be interpreted as a date in the USofA !! -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. Go to the Custom Quotes tab and unmark Replace. -Cell content always begins with uppercase -Choose Tools - AutoCorrect. Go to the Options tab. Unmark Capitalize first letter of every sentence. -Replace word with another word -Choose Tools - AutoCorrect. Go to the Replace tab. Select the word pair and click Delete. - -Tools - Cell Contents - AutoInput -Tools - AutoCorrect - - +Ctrl+Z. +The following shows you how to deactivate and reactivate the automatic changes in $[officename] Calc: +Automatic text or number completion +When making an entry in a cell, $[officename] 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 - Cell Contents - AutoInput. + + +Automatic conversion to date format +$[officename] Calc automatically converts certain entries to dates. For example, the entry 1.1 may be interpreted as January 1 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.for sure 1.1 will not be interpreted as a date in the USofA !! +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. Go to the Custom Quotes tab and unmark Replace. +Cell content always begins with uppercase +Choose Tools - AutoCorrect. Go to the Options tab. Unmark Capitalize first letter of every sentence. +Replace word with another word +Choose Tools - AutoCorrect. Go to the Replace tab. Select the word pair and click Delete. +
+Tools - Cell Contents - AutoInput +Tools - AutoCorrect +
+ + -- cgit