LibreOffice Help – 7.2

text/scalc/guide

Malay

Translate

	Context	English	Malay	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 string changes

Glossary

English	Malay
No related strings found in the glossary.

String information

Context

address_auto.xhp
tit
help.text

Source string description

NXy6S

Source string location

address_auto.xhp

String age

a year ago

Source string age

a year ago

Translation file

ms/helpcontent2/source/text/scalc/guide.po, string 1