diff options
| author | Frank Peters <fpe@openoffice.org> | 2004-08-23 11:17:18 +0000 |
|---|---|---|
| committer | Frank Peters <fpe@openoffice.org> | 2004-08-23 11:17:18 +0000 |
| commit | 800aeab02485f4a992af896f12d8979af319c0dd (patch) | |
| tree | b8ac27407aad192ff256c285bd5da4628e367427 /helpcontent2/source/text/scalc/guide/address_auto.xhp | |
| parent | e9458f602170729bf8814986bf441d3d1f2acbc7 (diff) | |
FPE: Regular Update
Diffstat (limited to 'helpcontent2/source/text/scalc/guide/address_auto.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/guide/address_auto.xhp | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/helpcontent2/source/text/scalc/guide/address_auto.xhp b/helpcontent2/source/text/scalc/guide/address_auto.xhp index 19dde68527..9fb3baf61f 100644 --- a/helpcontent2/source/text/scalc/guide/address_auto.xhp +++ b/helpcontent2/source/text/scalc/guide/address_auto.xhp @@ -62,7 +62,7 @@ </topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2004-08-16T11:29:26">FPE: Rewrote description, cleaned changed screenshot; dedr: reviewed</lastedited>
+<lastedited date="2004-08-20T10:40:03">FPE: Rewrote description, cleaned changed screenshot; dedr: reviewed</lastedited>
</history>
</meta>
<body> @@ -79,15 +79,15 @@ <tablerow>
<tablecell colspan="" rowspan="">
<paragraph role="paragraph" id="par_id3156283" xml-lang="en-US" l10n="E"> -<image id="img_id3154942" src="res/helpimg/names_as_addressing.png" width="108.96mm" height="42.81mm"><alt id="alt_id3154942" xml-lang="en-US">Example spreadsheet</alt> +<image id="img_id3154942" src="res/helpimg/names_as_addressing.png" width="4.2898inch" height="1.6854inch"><alt id="alt_id3154942" xml-lang="en-US">Example spreadsheet</alt> </image></paragraph>
</tablecell>
</tablerow>
</table>
<paragraph role="paragraph" id="par_id3154512" xml-lang="en-US" l10n="CHG" oldref="22">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.</paragraph>
-<paragraph role="paragraph" id="par_id3155443" xml-lang="en-US" l10n="CHG" oldref="24">This function is active by default. To turn this function off, choose <item type="menuitem">Tools - Options - Spreadsheet Document ??? Calculate</item> and clear the <item type="menuitem">Automatically find column and row labels</item> check box.</paragraph>
-<paragraph role="tip" id="par_id3149210" xml-lang="en-US" l10n="CHG" oldref="37">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 want to use non-alphanumeric characters, including spaces, in an name, 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>
+<paragraph role="paragraph" id="par_id3155443" xml-lang="en-US" l10n="CHG" oldref="24">This function is active by default. To turn this function off, choose <item type="menuitem">Tools - Options - %PRODUCTNAME Calc - Calculate</item> and clear the <item type="menuitem">Automatically find column and row labels</item> check box.</paragraph>
+<paragraph role="tip" id="par_id3149210" xml-lang="en-US" l10n="CHG" oldref="37">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>
</paragraph>
<section id="relatedtopics">
<paragraph role="paragraph" id="par_idN106C4" xml-lang="en-US" l10n="NEW">
|