diff options
| author | Rüdiger Timm <rt@openoffice.org> | 2004-11-26 15:25:29 +0000 |
|---|---|---|
| committer | Rüdiger Timm <rt@openoffice.org> | 2004-11-26 15:25:29 +0000 |
| commit | 6401c1680071e65dcf4f3ea70ef5d682b2f54ec2 (patch) | |
| tree | cd4ad7f582df8a6e5df804cea9f0ce26ab18715a /helpcontent2/source | |
| parent | 66da01b863c020af757341409bc02445ca1541db (diff) | |
INTEGRATION: CWS helpcontentbeta (1.2.2); FILE MERGED
2004/09/16 11:46:24 fpe 1.2.2.1: Regular Update
Diffstat (limited to 'helpcontent2/source')
| -rwxr-xr-x | helpcontent2/source/text/scalc/05/02140000.xhp | 4 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/guide/address_auto.xhp | 92 |
2 files changed, 48 insertions, 48 deletions
diff --git a/helpcontent2/source/text/scalc/05/02140000.xhp b/helpcontent2/source/text/scalc/05/02140000.xhp index 1a628cd8ee..441fae5525 100755 --- a/helpcontent2/source/text/scalc/05/02140000.xhp +++ b/helpcontent2/source/text/scalc/05/02140000.xhp @@ -62,7 +62,7 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-08-10T10:56:39">converted from old format - fpe</lastedited> +<lastedited date="2004-09-03T15:38:45">converted from old format - fpe</lastedited> </history> </meta> <body> @@ -291,7 +291,7 @@ <paragraph role="paragraph" id="par_id3150930" xml-lang="en-US" l10n="U" oldref="73">The calculation procedure does not converge</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3150272" xml-lang="en-US" l10n="U" oldref="74">Financial statistics function missed a targeted value or iterations of circular references do not reach the minimum change within the maximum steps that are set.</paragraph> +<paragraph role="paragraph" id="par_id3150272" xml-lang="en-US" l10n="CHG" oldref="74">Function missed a targeted value, or <link href="text/shared/optionen/01060500.xhp">iterative references</link> do not reach the minimum change within the maximum steps that are set.<comment>UFI: see #33769#</comment></paragraph> </tablecell> </tablerow> <tablerow> diff --git a/helpcontent2/source/text/scalc/guide/address_auto.xhp b/helpcontent2/source/text/scalc/guide/address_auto.xhp index 9fb3baf61f..96e704e33f 100644 --- a/helpcontent2/source/text/scalc/guide/address_auto.xhp +++ b/helpcontent2/source/text/scalc/guide/address_auto.xhp @@ -1,4 +1,4 @@ -<?xml version="1.0" encoding="UTF-8"?>
+<?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * * The Contents of this file are made available subject to the terms of @@ -52,53 +52,53 @@ * Contributor(s): _______________________________________ * * - ************************************************************************-->
-
-<helpdocument version="1.0">
-<meta>
-<topic id="textscalcguideaddress_autoxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Recognizing Names as Addressing</title>
-<filename>/text/scalc/guide/address_auto.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2004-08-20T10:40:03">FPE: Rewrote description, cleaned changed screenshot; dedr: reviewed</lastedited>
-</history>
-</meta>
+ ************************************************************************--> + +<helpdocument version="1.0"> +<meta> +<topic id="textscalcguideaddress_autoxml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Recognizing Names as Addressing</title> +<filename>/text/scalc/guide/address_auto.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2004-09-09T14:57:06">FPE: Rewrote description, cleaned changed screenshot; dedr: reviewed</lastedited> +</history> +</meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3148797"><bookmark_value>automatic addressing in tables</bookmark_value>
-<bookmark_value>natural language addressing</bookmark_value>
-<bookmark_value>formulas; addressing by names</bookmark_value>
-<bookmark_value>names; as addressing</bookmark_value>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3148797"><bookmark_value>automatic addressing in tables</bookmark_value> +<bookmark_value>natural language addressing</bookmark_value> +<bookmark_value>formulas; addressing by names</bookmark_value> +<bookmark_value>names; as addressing</bookmark_value> <bookmark_value>addressing; automatic</bookmark_value> -</bookmark>
+</bookmark> <paragraph role="heading" id="hd_id3148797" xml-lang="en-US" level="1" l10n="U" oldref="20"><variable id="address_auto"><link href="text/scalc/guide/address_auto.xhp" name="Recognizing Names as Addressing">Recognizing Names as Addressing</link> -</variable></paragraph>
-<paragraph role="paragraph" id="par_id3152597" xml-lang="en-US" l10n="CHG" oldref="21">You can use cells with text to refer to the rows or to the columns that contain the cells.</paragraph>
-<table id="tbl_id3152577">
-<tablerow>
-<tablecell colspan="" rowspan="">
+</variable></paragraph> +<paragraph role="paragraph" id="par_id3152597" xml-lang="en-US" l10n="CHG" oldref="21">You can use cells with text to refer to the rows or to the columns that contain the cells.</paragraph> +<table id="tbl_id3152577"> +<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="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 - %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">
-<embedvar href="text/scalc/guide/address_byname.xhp#address_byname"/>
-</paragraph>
-<paragraph role="paragraph" id="par_idN106CC" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/01/04070400.xhp#define_label_range"/>
-</paragraph>
-<paragraph role="paragraph" id="par_idN106D4" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/>
-</paragraph>
-</section>
-</body>
-</helpdocument>
+ </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 <emph>Tools - Options - %PRODUCTNAME Calc - Calculate</emph> and clear the <emph>Automatically find column and row labels</emph> 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"> +<embedvar href="text/scalc/guide/address_byname.xhp#address_byname"/> +</paragraph> +<paragraph role="paragraph" id="par_idN106CC" xml-lang="en-US" l10n="NEW"> +<embedvar href="text/scalc/01/04070400.xhp#define_label_range"/> +</paragraph> +<paragraph role="paragraph" id="par_idN106D4" xml-lang="en-US" l10n="NEW"> +<embedvar href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/> +</paragraph> +</section> +</body> +</helpdocument> |