Source string Source string

Context English Actions
address_auto.xhp
tit
help.text
Recognizing Names as Addressing
address_auto.xhp
bm_id3148797
help.text
<bookmark_value>automatic addressing in tables</bookmark_value> <bookmark_value>natural language addressing</bookmark_value> <bookmark_value>formulas; using row/column labels</bookmark_value> <bookmark_value>text in cells; as addressing</bookmark_value> <bookmark_value>addressing; automatic</bookmark_value> <bookmark_value>name recognition on/off</bookmark_value> <bookmark_value>row headers;using in formulas</bookmark_value> <bookmark_value>column headers;using in formulas</bookmark_value> <bookmark_value>columns; finding labels automatically</bookmark_value> <bookmark_value>rows; finding labels automatically</bookmark_value> <bookmark_value>recognizing; column and row labels</bookmark_value>
address_auto.xhp
hd_id3148797
help.text
<variable id="address_auto"><link href="text/scalc/guide/address_auto.xhp" name="Recognizing Names as Addressing">Recognizing Names as Addressing</link></variable>
address_auto.xhp
par_id3152597
help.text
You can use cells with text to refer to the rows or to the columns that contain the cells.
address_auto.xhp
par_id3156283
help.text
<image id="img_id3154942" src="media/helpimg/names_as_addressing.png" width="5.408cm" height="2.212cm" localize="true"><alt id="alt_id3154942">Example spreadsheet</alt></image>
address_auto.xhp
par_id3154512
help.text
In the example spreadsheet, you can use the string <item type="literal">'Column One'</item> in a formula to refer to the cell range <item type="literal">B3</item> to <item type="literal">B5</item>, or <item type="literal">'Column Two'</item> for the cell range <item type="literal">C2</item> to <item type="literal">C5</item>. You can also use <item type="literal">'Row One'</item> for the cell range <item type="literal">B3</item> to <item type="literal">D3</item>, or <item type="literal">'Row Two'</item> for the cell range <item type="literal">B4</item> to <item type="literal">D4</item>. The result of a formula that uses a cell name, for example, <item type="literal">SUM('Column One')</item>, is 600.
address_auto.xhp
par_id3155443
help.text
This function is active by default. To turn this function off, choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Calculate</emph> and clear the <emph>Automatically find column and row labels</emph> check box.
address_auto.xhp
par_id3149210
help.text
If you want a name to be automatically recognized by Calc, the name must start with a letter and be composed of alphanumeric characters. If you enter the name in the formula yourself, enclose the name in single quotation marks ('). If a single quotation mark appears in a name, you must enter a backslash in front of the quotation mark, for example, <item type="literal">'Harry\'s Bar'</item>.
auto_off.xhp
tit
help.text
Deactivating Automatic Changes
auto_off.xhp
bm_id3149456
help.text
<bookmark_value>deactivating; automatic changes</bookmark_value> <bookmark_value>tables; deactivating automatic changes in</bookmark_value> <bookmark_value>AutoInput function on/off</bookmark_value> <bookmark_value>text in cells;AutoInput function</bookmark_value> <bookmark_value>cells; AutoInput function of text</bookmark_value> <bookmark_value>input support in spreadsheets</bookmark_value> <bookmark_value>changing; input in cells</bookmark_value> <bookmark_value>AutoCorrect function;cell contents</bookmark_value> <bookmark_value>cell input;AutoInput function</bookmark_value> <bookmark_value>lowercase letters;AutoInput function (in cells)</bookmark_value> <bookmark_value>capital letters;AutoInput function (in cells)</bookmark_value> <bookmark_value>date formats;avoiding conversion to</bookmark_value> <bookmark_value>number completion on/off</bookmark_value> <bookmark_value>text completion on/off</bookmark_value> <bookmark_value>word completion on/off</bookmark_value>
auto_off.xhp
hd_id3149456
help.text
<variable id="auto_off"><link href="text/scalc/guide/auto_off.xhp" name="Deactivating Automatic Changes">Deactivating Automatic Changes</link> </variable>
auto_off.xhp
par_id3156442
help.text
By default, $[officename] automatically corrects many common typing errors and applies formatting while you type. You can immediately undo any automatic changes with <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Z.
auto_off.xhp
par_id3145273
help.text
The following shows you how to deactivate and reactivate the automatic changes in $[officename] Calc:
auto_off.xhp
hd_id3145748
help.text
Automatic Text or Number Completion
auto_off.xhp
par_id3154730
help.text
When making an entry in a cell, $[officename] Calc automatically suggests matching input found in the same column. This function is known as <emph>AutoInput</emph>.
auto_off.xhp
par_id3153878
help.text
To turn the AutoInput on and off, set or remove the check mark in front of <link href="text/scalc/01/06130000.xhp" name="Tools - AutoInput"><emph>Tools - AutoInput</emph></link>.

Loading…

No matching activity found.
Browse all component changes

Glossary

English English
No related strings found in the glossary.

String information

Context
address_auto.xhp
tit
help.text
Source string description
NXy6S
Flags
read-only
Source string location
address_auto.xhp
String age
11 months ago
Source string age
11 months ago
Translation file
templates/helpcontent2/source/text/scalc/guide.pot, string 1