LibreOffice Help – 7.6/text/scalc/guide — Hebrew @ TDF Weblate - LibreOffice: <bookmark_value>automatic addressing in tables</bookmark_value> <bookmark_value>natural language addressing</bookmark_value> <bookmark

Translation

Context address_auto.xhp bm_id3148797 help.text

English

QvKmR

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

Hebrew

Needs editing

Skip

Context	English	Hebrew
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>	\<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>
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_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.	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
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>.	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"><emph>Tools - AutoInput</emph></link>.

Loading…

None

String updated in the repository

English

Hebrew 735 characters edited Current translation Translated

\<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\>

a year ago

Browse all string changes

Things to check

XML syntax

The translation is not valid XML

Reset

Glossary

English	Hebrew
No related strings found in the glossary.

String information

Context

address_auto.xhp
bm_id3148797
help.text

Source string description

QvKmR

Source string location

address_auto.xhp

String age

a year ago

Last updated

a year ago

Source string age

a year ago

Translation file

he/helpcontent2/source/text/scalc/guide.po, string 2