diff options
author | Vladimir Glazounov <vg@openoffice.org> | 2005-03-08 13:36:38 +0000 |
---|---|---|
committer | Vladimir Glazounov <vg@openoffice.org> | 2005-03-08 13:36:38 +0000 |
commit | eec981ad896aa7fc7395220c38966e732c6adbfb (patch) | |
tree | 8854b27f2495c5a4dc7dcf351352727690c8e72e /helpcontent2/source/text/scalc/01/04060109.xhp | |
parent | cf2ecd1ba85df49e2011d6fc638bb49bc9607dfd (diff) |
INTEGRATION: CWS hc680pb2 (1.3.16); FILE MERGED
2005/02/21 16:40:20 fpe 1.3.16.1: regular update
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060109.xhp')
-rw-r--r-- | helpcontent2/source/text/scalc/01/04060109.xhp | 19 |
1 files changed, 14 insertions, 5 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060109.xhp b/helpcontent2/source/text/scalc/01/04060109.xhp index 01624ce4eb..2f333e3c2f 100644 --- a/helpcontent2/source/text/scalc/01/04060109.xhp +++ b/helpcontent2/source/text/scalc/01/04060109.xhp @@ -37,8 +37,8 @@ * License at http://www.openoffice.org/license.html. * * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS, + * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, + * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. * See the License for the specific provisions governing your rights and * obligations concerning the Software. @@ -62,7 +62,7 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-10-18T16:19:52">UFI: brushed up this doc due to #i29327# +<lastedited date="2005-02-21T14:12:03">UFI: brushed up this doc due to #i29327# dedr: reviewed UFI: added HYPERLINK function #i27972#; dedr. reviewed</lastedited> </history> @@ -82,7 +82,7 @@ UFI: added HYPERLINK function #i27972#; dedr. reviewed</lastedited> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_ADRESSE" id="bm_id3147546" localize="false"/> <paragraph role="heading" id="hd_id3146968" xml-lang="en-US" level="2" l10n="U" oldref="3">ADDRESS</paragraph> -<paragraph role="paragraph" id="par_id3155762" xml-lang="en-US" l10n="U" oldref="4"><ahelp hid="HID_FUNC_ADRESSE">Returns a cell address (reference) as text, according to the specified row and column numbers.</ahelp> Optionally, you can determine whether the address is interpreted as an absolute address (for example, $A$1) or as a relative address (as A1) or in a mixed form (A$1 or $A1). You can also specify the name of the sheet.</paragraph> +<paragraph role="paragraph" id="par_id3155762" xml-lang="en-US" l10n="CHG" oldref="4"><ahelp hid="HID_FUNC_ADRESSE">Returns a cell address (reference) as text, according to the specified row and column numbers.</ahelp> You can determine whether the address is interpreted as an absolute address (for example, $A$1) or as a relative address (as A1) or in a mixed form (A$1 or $A1). You can also specify the name of the sheet.</paragraph> <paragraph role="heading" id="hd_id3151196" xml-lang="en-US" level="3" l10n="U" oldref="5">Syntax</paragraph> <paragraph role="code" id="par_id3154707" xml-lang="en-US" l10n="U" oldref="6">ADDRESS(row; column; abs;sheet)</paragraph> <paragraph role="paragraph" id="par_id3147505" xml-lang="en-US" l10n="U" oldref="7"> @@ -91,7 +91,7 @@ UFI: added HYPERLINK function #i27972#; dedr. reviewed</lastedited> <emph>column</emph> represents the column number for the cell reference (the number, not the letter)</paragraph> <paragraph role="paragraph" id="par_id3153074" xml-lang="en-US" l10n="U" oldref="9"> <emph>abs</emph> determines the type of reference:</paragraph> -<paragraph role="paragraph" id="par_id3153298" xml-lang="en-US" l10n="U" oldref="10">1 or empty: absolute ($A$1)</paragraph> +<paragraph role="paragraph" id="par_id3153298" xml-lang="en-US" l10n="CHG" oldref="10">1: absolute ($A$1)</paragraph> <paragraph role="paragraph" id="par_id3150431" xml-lang="en-US" l10n="U" oldref="11">2: row reference type is absolute; column reference is relative (A$1)</paragraph> <paragraph role="paragraph" id="par_id3146096" xml-lang="en-US" l10n="U" oldref="12">3: row (relative); column (absolute) ($A1)</paragraph> <paragraph role="paragraph" id="par_id3153334" xml-lang="en-US" l10n="U" oldref="13">4: relative (A1)</paragraph> @@ -206,6 +206,9 @@ UFI: added HYPERLINK function #i27972#; dedr. reviewed</lastedited> <emph>column</emph> (optional) represents the column number of the reference range, for which to return a value.</paragraph> <paragraph role="paragraph" id="par_id3155514" xml-lang="en-US" l10n="U" oldref="54"> <emph>range</emph> (optional) represents the index of the subrange if referring to a multiple range.</paragraph> +<paragraph role="paragraph" id="par_idN10A2E" xml-lang="en-US" l10n="NEW"> +<embedvar href="text/scalc/00/00000004.xhp#optional"/> +</paragraph> <paragraph role="heading" id="hd_id3145264" xml-lang="en-US" level="3" l10n="U" oldref="55">Example</paragraph> <paragraph role="paragraph" id="par_id3159112" xml-lang="en-US" l10n="U" oldref="56">=INDEX(Prices;4;1) returns the value from row 4 and column 1 of the database range defined in <emph>Data - Define</emph> as <emph>Prices</emph>.</paragraph> <paragraph role="paragraph" id="par_id3150691" xml-lang="en-US" l10n="U" oldref="57">=INDEX(SumX;4;1) returns the value from the range <emph>SumX</emph> in row 4 and column 1 as defined in <emph>Insert - Names - Define</emph>.</paragraph> @@ -351,6 +354,9 @@ UFI: added HYPERLINK function #i27972#; dedr. reviewed</lastedited> <emph>Height</emph> is the optional vertical height for an area that starts at the new reference position.</paragraph> <paragraph role="paragraph" id="par_id3147278" xml-lang="en-US" l10n="U" oldref="119"> <emph>Width</emph> is the optional horizontal width for an area that starts at the new reference position.</paragraph> +<paragraph role="paragraph" id="par_idN1104B" xml-lang="en-US" l10n="NEW"> +<embedvar href="text/scalc/00/00000004.xhp#optional"/> +</paragraph> <paragraph role="heading" id="hd_id3155586" xml-lang="en-US" level="3" l10n="U" oldref="120">Example</paragraph> <paragraph role="paragraph" id="par_id3149744" xml-lang="en-US" l10n="CHG" oldref="121">=OFFSET(A1; 2; 2) returns the value in cell C3 (A1 moved by two rows and two columns down). If C3 contains the value 100 this function returns the value 100.</paragraph> <paragraph role="paragraph" id="par_id3153739" xml-lang="en-US" l10n="U" oldref="122">=SUM(OFFSET(A1; 2; 2; 5; 6)) determines the total of the area that starts in cell C3 and has a height of 5 rows and a width of 6 columns (area=C3:H7).</paragraph> @@ -387,6 +393,9 @@ UFI: added HYPERLINK function #i27972#; dedr. reviewed</lastedited> <emph>Time</emph> is an optional time range in seconds. If this parameter is missing the style will not be changed after a certain amount of time has passed.</paragraph> <paragraph role="paragraph" id="par_id3149520" xml-lang="en-US" l10n="U" oldref="139"> <emph>Style2</emph> is the optional name of a cell style assigned to the cell after a certain amount of time has passed. If this parameter is missing "Standard" is assumed.</paragraph> +<paragraph role="paragraph" id="par_idN111CA" xml-lang="en-US" l10n="NEW"> +<embedvar href="text/scalc/00/00000004.xhp#optional"/> +</paragraph> <paragraph role="heading" id="hd_id3159254" xml-lang="en-US" level="3" l10n="U" oldref="140">Example</paragraph> <paragraph role="paragraph" id="par_id3151374" xml-lang="en-US" l10n="U" oldref="141">=STYLE("Invisible";60;"Default") formats the cell in transparent format for 60 seconds after the document was recalculated or loaded, then the Default format is assigned. Both cell formats have to be defined beforehand.</paragraph> </section> |