LibreOffice Help - master/text/scalc/guide — Gujarati @ TDF Weblate - LibreOffice: Recognizing Names as Addressing

Translation

Context address_auto.xhp tit help.text

English NXy6S

Gujarati

Needs editing

Insufficient privileges for saving translations.

Skip

Context	English	Gujarati
address_auto.xhp tit help.text	Recognizing Names as Addressing	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">Recognizing Names as Addressing</link></variable>	<variable id="address_auto"><link href="text/scalc/guide/address_auto.xhp">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.	You can use cells with text to refer to the rows or to the columns that contain the cells.
address_auto.xhp par_id81713445694889 help.text	If the resulting cell is below or above another cell containing text, %PRODUCTNAME Calc assumes the text as a column label, else %PRODUCTNAME Calc assumes the text as a row label.
address_auto.xhp par_id3156283 help.text	<image id="img_id3154942" src="media/helpimg/names_as_addressing.png" width="380px" height="150px" 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.	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	Automatically finding labels is a legacy feature and deactivated by default as it can produce nondeterministic behavior depending on actual document content. To turn this function on, 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 mark the <emph>Automatically find column and row labels</emph> check box.
address_auto.xhp par_id3155444 help.text	Using defined labels instead is always possible and behaves similar but in a defined way.
address_auto.xhp par_id3149210 help.text	If you enter a label name in the formula yourself, enclose the name in single quotation marks ('). If a single quotation mark appears in a name, you must double it, for example, <item type="literal">'Harry''s Bar'</item>.
auto_off.xhp tit help.text	Deactivating Automatic Changes	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">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:	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	Automatic text or number completion

Loading…

No matching activity found.

Browse all string changes

Things to check

Unchanged translation

Source and translation are identical

Reset

Glossary

English	Gujarati
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

4 years ago

Last updated

9 months ago

Source string age

4 years ago

Translation file

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