diff options
Diffstat (limited to 'source/text/scalc/01/04060109.xhp')
| -rw-r--r-- | source/text/scalc/01/04060109.xhp | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 99e061ae0c..77d68eddb8 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -157,7 +157,7 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FEHLERTYP" id="bm_id3153000" localize="false"/> <h2 id="hd_id3153114">ERRORTYPE</h2> - <paragraph xml-lang="en-US" id="par_id3148568" role="paragraph"><ahelp hid="HID_FUNC_FEHLERTYP">Returns the number corresponding to an <link href="text/scalc/05/02140000.xhp" name="error value">error value</link> occurring in a different cell.</ahelp> With the aid of this number, you can generate an error message text.</paragraph> + <paragraph xml-lang="en-US" id="par_id3148568" role="paragraph"><ahelp hid="HID_FUNC_FEHLERTYP">Returns the number corresponding to an <link href="text/scalc/05/02140000.xhp">error value</link> occurring in a different cell.</ahelp> With the aid of this number, you can generate an error message text.</paragraph> <embed href="text/shared/00/00000001.xhp#wahr"/> <note id="par_id3149877">The Status Bar displays the predefined error code from <item type="productname">%PRODUCTNAME</item> if you click the cell containing the error.</note> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> @@ -232,7 +232,7 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SPALTE" id="bm_id3156378" localize="false"/> <h2 id="hd_id3154818">COLUMN</h2> - <paragraph xml-lang="en-US" id="par_id3149711" role="paragraph"><ahelp hid="HID_FUNC_SPALTE">Returns the column number of a cell reference.</ahelp> If the reference is a cell the column number of the cell is returned; if the parameter is a cell area, the corresponding column numbers are returned in a single-row <link href="text/scalc/01/04060107.xhp#wasmatrix" name="array">array</link> if the formula is entered <link href="text/scalc/01/04060107.xhp#creating_array_formulas" name="as an array formula">as an array formula</link>. If the COLUMN function with an area reference parameter is not used for an array formula, only the column number of the first cell within the area is determined.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149711" role="paragraph"><ahelp hid="HID_FUNC_SPALTE">Returns the column number of a cell reference.</ahelp> If the reference is a cell the column number of the cell is returned; if the parameter is a cell area, the corresponding column numbers are returned in a single-row <link href="text/scalc/01/04060107.xhp#wasmatrix">array</link> if the formula is entered <link href="text/scalc/01/04060107.xhp#creating_array_formulas">as an array formula</link>. If the COLUMN function with an area reference parameter is not used for an array formula, only the column number of the first cell within the area is determined.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3149447" role="code">COLUMN([Reference])</paragraph> <paragraph xml-lang="en-US" id="par_id3156310" role="paragraph"> @@ -394,7 +394,7 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VERWEIS" id="bm_id3152877" localize="false"/> <h2 id="hd_id3159273">LOOKUP</h2> - <paragraph xml-lang="en-US" id="par_id3153389" role="paragraph"><ahelp hid="HID_FUNC_VERWEIS">Returns the contents of a cell either from a one-row or one-column range.</ahelp> Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to <link href="text/scalc/01/04060109.xhp#Section9" name="VLOOKUP">VLOOKUP</link> and <link href="text/scalc/01/04060109.xhp#Section17" name="HLOOKUP">HLOOKUP</link>, search and result vector may be at different positions; they do not have to be adjacent. Additionally, the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153389" role="paragraph"><ahelp hid="HID_FUNC_VERWEIS">Returns the contents of a cell either from a one-row or one-column range.</ahelp> Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to <link href="text/scalc/01/04060109.xhp#Section9">VLOOKUP</link> and <link href="text/scalc/01/04060109.xhp#Section17">HLOOKUP</link>, search and result vector may be at different positions; they do not have to be adjacent. Additionally, the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results.</paragraph> <note id="par_id4484084">If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion.</note> <embed href="text/shared/00/00000001.xhp#regex"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> @@ -464,7 +464,7 @@ <embed href="text/shared/00/00000001.xhp#regex"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3146070" role="code">HLOOKUP(Lookup; Array; Index [; SortedRangeLookup])</paragraph> - <paragraph xml-lang="en-US" id="par_id3148672" role="paragraph">For an explanation on the parameters, see: <link href="text/scalc/01/04060109.xhp#Section9" name="VLOOKUP">VLOOKUP</link> (columns and rows are exchanged)</paragraph> + <paragraph xml-lang="en-US" id="par_id3148672" role="paragraph">For an explanation on the parameters, see: <link href="text/scalc/01/04060109.xhp#Section9">VLOOKUP</link> (columns and rows are exchanged)</paragraph> <embed href="text/scalc/05/empty_cells.xhp#empty_cells"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id141612447324913">Suppose we have built a small database table occupying the cell range A1:DO4 and containing basic information about 118 chemical elements. The first column contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative Atomic Mass”. Subsequent columns contain the relevant information for each of the elements, ordered left to right by atomic number. For example, cells B1:B4 contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain “Oganesson”, “Og”, “118”, and “294”.</paragraph> @@ -594,7 +594,7 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEILE" id="bm_id3147333" localize="false"/> <h2 id="hd_id3147321">ROW</h2> - <paragraph xml-lang="en-US" id="par_id3154564" role="paragraph"><ahelp hid="HID_FUNC_ZEILE">Returns the row number of a cell reference.</ahelp> If the reference is a cell, it returns the row number of the cell. If the reference is a cell range, it returns the corresponding row numbers in a one-column <link href="text/scalc/01/04060107.xhp#wasmatrix" name="Array">Array</link> if the formula is entered <link href="text/scalc/01/04060107.xhp#creating_array_formulas" name="as an array formula">as an array formula</link>. If the ROW function with a range reference is not used in an array formula, only the row number of the first range cell will be returned.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154564" role="paragraph"><ahelp hid="HID_FUNC_ZEILE">Returns the row number of a cell reference.</ahelp> If the reference is a cell, it returns the row number of the cell. If the reference is a cell range, it returns the corresponding row numbers in a one-column <link href="text/scalc/01/04060107.xhp#wasmatrix">Array</link> if the formula is entered <link href="text/scalc/01/04060107.xhp#creating_array_formulas">as an array formula</link>. If the ROW function with a range reference is not used in an array formula, only the row number of the first range cell will be returned.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph xml-lang="en-US" id="par_id3154916" role="code">ROW([Reference])</paragraph> <paragraph xml-lang="en-US" id="par_id3156336" role="paragraph"> |