This is an automated email from the ASF dual-hosted git repository.
mseidel pushed a commit to branch trunk
in repository https://gitbox.apache.org/repos/asf/openoffice.git
The following commit(s) were added to refs/heads/trunk by this push:
new 24b3f72e2c Remove 'oldref' entries (work in progress)
24b3f72e2c is described below
commit 24b3f72e2cd4d11ab8f7f698a89297b1971c946d
Author: mseidel <[email protected]>
AuthorDate: Sat Mar 15 15:22:27 2025 +0100
Remove 'oldref' entries (work in progress)
---
.../helpcontent2/source/text/scalc/01/04060109.xhp | 569 ++++++++-------------
.../source/text/shared/01/ref_pdf_export.xhp | 29 +-
.../source/text/shared/02/01170100.xhp | 38 +-
.../source/text/shared/autopi/01110600.xhp | 42 +-
.../source/text/simpress/guide/table_insert.xhp | 30 +-
5 files changed, 277 insertions(+), 431 deletions(-)
diff --git a/main/helpcontent2/source/text/scalc/01/04060109.xhp
b/main/helpcontent2/source/text/scalc/01/04060109.xhp
index 6676b66b75..97f599016c 100644
--- a/main/helpcontent2/source/text/scalc/01/04060109.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04060109.xhp
@@ -34,8 +34,8 @@
<bookmark_value>Function Wizard; spreadsheets</bookmark_value>
<bookmark_value>functions; spreadsheets</bookmark_value>
</bookmark>
-<paragraph xml-lang="en-US" id="hd_id3148522" role="heading" level="1"
l10n="U" oldref="1">Spreadsheet Functions</paragraph>
-<paragraph xml-lang="en-US" id="par_id3144508" role="paragraph" l10n="U"
oldref="2"><variable id="tabelletext">This section contains descriptions of the
<emph>Spreadsheet</emph> functions together with an example.
+<paragraph xml-lang="en-US" id="hd_id3148522" role="heading" level="1"
l10n="U">Spreadsheet Functions</paragraph>
+<paragraph xml-lang="en-US" id="par_id3144508" role="paragraph"
l10n="U"><variable id="tabelletext">This section contains descriptions of the
<emph>Spreadsheet</emph> functions together with an example.
</variable></paragraph>
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#efefft"/>
@@ -46,8 +46,8 @@
<bookmark_value>ADDRESS function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ADRESSE" id="bm_id3147546"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3146968" role="heading" level="2"
l10n="U" oldref="3">ADDRESS</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155762" role="paragraph" 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 xml-lang="en-US" id="hd_id3146968" role="heading" level="2"
l10n="U">ADDRESS</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155762" role="paragraph"
l10n="CHG"><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>
<section id="r1c1">
<paragraph xml-lang="en-US" id="par_id1027200802301348" role="paragraph"
l10n="NEW">For interoperability the ADDRESS and INDIRECT functions support an
optional parameter to specify whether the R1C1 address notation instead of the
usual A1 notation should be used.</paragraph>
<paragraph xml-lang="en-US" id="par_id1027200802301445" role="paragraph"
l10n="NEW">In ADDRESS, the parameter is inserted as the fourth parameter,
shifting the optional sheet name parameter to the fifth position.</paragraph>
@@ -59,241 +59,175 @@
<paragraph xml-lang="en-US" id="par_id102720080230162" role="note"
l10n="NEW">Do not save a spreadsheet in the old ODF 1.0/1.1 format if the
ADDRESS function's new fourth parameter was used with a value of 0.</paragraph>
<paragraph xml-lang="en-US" id="par_id1027200802301756" role="note"
l10n="NEW">The INDIRECT function is saved without conversion to ODF 1.0/1.1
format. If the second parameter was present, an older version of Calc will
return an error for that function.</paragraph>
</section>
-<paragraph xml-lang="en-US" id="hd_id3151196" role="heading" level="3"
l10n="U" oldref="5">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154707" role="code" l10n="U"
oldref="6">ADDRESS(Row; Column; Abs; A1; "Sheet")</paragraph>
-<paragraph xml-lang="en-US" id="par_id3147505" role="paragraph" l10n="U"
oldref="7">
-<emph>Row</emph> represents the row number for the cell reference</paragraph>
-<paragraph xml-lang="en-US" id="par_id3145323" role="paragraph" l10n="U"
oldref="8">
-<emph>Column</emph> represents the column number for the cell reference (the
number, not the letter)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153074" role="paragraph" l10n="U"
oldref="9">
-<emph>Abs</emph> determines the type of reference:</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153298" role="paragraph" l10n="CHG"
oldref="10">1: absolute ($A$1)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150431" role="paragraph" l10n="U"
oldref="11">2: row reference type is absolute; column reference is relative
(A$1)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3146096" role="paragraph" l10n="U"
oldref="12">3: row (relative); column (absolute) ($A1)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153334" role="paragraph" l10n="U"
oldref="13">4: relative (A1)</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3151196" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154707" role="code"
l10n="U">ADDRESS(Row; Column; Abs; A1; "Sheet")</paragraph>
+<paragraph xml-lang="en-US" id="par_id3147505" role="paragraph"
l10n="U"><emph>Row</emph> represents the row number for the cell
reference</paragraph>
+<paragraph xml-lang="en-US" id="par_id3145323" role="paragraph"
l10n="U"><emph>Column</emph> represents the column number for the cell
reference (the number, not the letter)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153074" role="paragraph"
l10n="U"><emph>Abs</emph> determines the type of reference:</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153298" role="paragraph" l10n="CHG">1:
absolute ($A$1)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150431" role="paragraph" l10n="U">2:
row reference type is absolute; column reference is relative (A$1)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3146096" role="paragraph" l10n="U">3:
row (relative); column (absolute) ($A1)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153334" role="paragraph" l10n="U">4:
relative (A1)</paragraph>
<paragraph xml-lang="en-US" id="par_id1027200802465915" role="paragraph"
l10n="NEW">
<emph>A1</emph> (optional) - if set to 0, the R1C1 notation is used. If this
parameter is absent or set to another value than 0, the A1 notation is
used.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153962" role="paragraph" l10n="U"
oldref="14">
-<emph>Sheet</emph> represents the name of the sheet. It must be placed in
double quotes.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3147299" role="heading" level="3" l10n="U"
-oldref="15">Example:</paragraph>
-<paragraph xml-lang="en-US" id="par_id3148744" role="paragraph" l10n="CHG"
oldref="16">
-<item type="input">=ADDRESS(1;1;2;;"Sheet2")</item> returns the following:
Sheet2.A$1<comment>i 101187</comment></paragraph>
-<paragraph xml-lang="en-US" id="par_id3159260" role="paragraph" l10n="U"
oldref="17">If the cell A1 in sheet 2 contains the value <item
type="input">-6</item>, you can refer indirectly to the referenced cell using a
function in B2 by entering <item type="input">=ABS(INDIRECT(B2))</item>. The
result is the absolute value of the cell reference specified in B2, which in
this case is 6.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153962" role="paragraph"
l10n="U"><emph>Sheet</emph> represents the name of the sheet. It must be placed
in double quotes.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3147299" role="heading" level="3"
l10n="U">Example:</paragraph>
+<paragraph xml-lang="en-US" id="par_id3148744" role="paragraph"
l10n="CHG"><item type="input">=ADDRESS(1;1;2;;"Sheet2")</item> returns the
following: Sheet2.A$1<comment>i 101187</comment></paragraph>
+<paragraph xml-lang="en-US" id="par_id3159260" role="paragraph" l10n="U">If
the cell A1 in sheet 2 contains the value <item type="input">-6</item>, you can
refer indirectly to the referenced cell using a function in B2 by entering
<item type="input">=ABS(INDIRECT(B2))</item>. The result is the absolute value
of the cell reference specified in B2, which in this case is 6.</paragraph>
</section>
<section id="Section2">
<bookmark xml-lang="en-US" branch="index" id="bm_id3150372">
<bookmark_value>AREAS function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BEREICHE" id="bm_id3149721"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3150372" role="heading" level="2" l10n="U"
-oldref="19">AREAS</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150036" role="paragraph" l10n="U"
oldref="20"><ahelp hid="HID_FUNC_BEREICHE">Returns the number of individual
ranges that belong to a multiple range.</ahelp> A range can consist of
contiguous cells or a single cell.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3150372" role="heading" level="2"
l10n="U">AREAS</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150036" role="paragraph"
l10n="U"><ahelp hid="HID_FUNC_BEREICHE">Returns the number of individual ranges
that belong to a multiple range.</ahelp> A range can consist of contiguous
cells or a single cell.</paragraph>
<paragraph xml-lang="en-US" id="par_id061020090307073" role="paragraph"
l10n="NEW">The function expects a single argument. If you state multiple
ranges, you must enclose them into additional parentheses. Multiple ranges can
be entered using the semicolon (;) as divider, but this gets automatically
converted to the tilde (~) operator. The tilde is used to join
ranges.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3145222" role="heading" level="3" l10n="U"
-oldref="21">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155907" role="code" l10n="U"
oldref="22">AREAS(Reference)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153118" role="paragraph" l10n="U"
oldref="23">Reference represents the reference to a cell or cell
range.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3148891" role="heading" level="3" l10n="U"
-oldref="24">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149946" role="paragraph" l10n="U"
oldref="25">
-<item type="input">=AREAS((A1:B3;F2;G1))</item> returns 3, as it is a
reference to three cells and/or areas. After entry this gets converted to
=AREAS((A1:B3~F2~G1)).</paragraph>
-<paragraph xml-lang="en-US" id="par_id3146820" role="paragraph" l10n="U"
oldref="26">
-<item type="input">=AREAS(All)</item> returns 1 if you have defined an area
named All under <emph>Data - Define Range</emph>.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3145222" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155907" role="code"
l10n="U">AREAS(Reference)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153118" role="paragraph"
l10n="U">Reference represents the reference to a cell or cell range.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3148891" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149946" role="paragraph" l10n="U"><item
type="input">=AREAS((A1:B3;F2;G1))</item> returns 3, as it is a reference to
three cells and/or areas. After entry this gets converted to
=AREAS((A1:B3~F2~G1)).</paragraph>
+<paragraph xml-lang="en-US" id="par_id3146820" role="paragraph" l10n="U"><item
type="input">=AREAS(All)</item> returns 1 if you have defined an area named All
under <emph>Data - Define Range</emph>.</paragraph>
</section>
<section id="Section3">
<bookmark xml-lang="en-US" branch="index" id="bm_id3148727">
<bookmark_value>DDE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DDE" id="bm_id3154680"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3148727" role="heading" level="2" l10n="U"
-oldref="28">DDE</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149434" role="paragraph" l10n="U"
oldref="29"><ahelp hid="HID_FUNC_DDE">Returns the result of a DDE-based
link.</ahelp> If the contents of the linked range or section changes, the
returned value will also change. You must reload the spreadsheet or choose
<emph>Edit - Links</emph> to see the updated links. Cross-platform links, for
example from a <item type="productname">%PRODUCTNAME</item> installation
running on a Windows machine to a document crea [...]
-<paragraph xml-lang="en-US" id="hd_id3150700" role="heading" level="3" l10n="U"
-oldref="30">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3148886" role="code" l10n="U"
oldref="31">DDE("Server"; "File"; "Range"; Mode)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154842" role="paragraph" l10n="U"
oldref="32">
-<emph>Server</emph> is the name of a server application. <item
type="productname">%PRODUCTNAME</item>applications have the server name
"Soffice".</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153034" role="paragraph" l10n="U"
oldref="33">
-<emph>File</emph> is the complete file name, including path
specification.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3147472" role="paragraph" l10n="U"
oldref="34">
-<emph>Range</emph> is the area containing the data to be evaluated.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3152773" role="paragraph" l10n="U"
oldref="184">
-<emph>Mode</emph> is an optional parameter that controls the method by which
the DDE server converts its data into numbers.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3148727" role="heading" level="2"
l10n="U">DDE</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149434" role="paragraph"
l10n="U"><ahelp hid="HID_FUNC_DDE">Returns the result of a DDE-based
link.</ahelp> If the contents of the linked range or section changes, the
returned value will also change. You must reload the spreadsheet or choose
<emph>Edit - Links</emph> to see the updated links. Cross-platform links, for
example from a <item type="productname">%PRODUCTNAME</item> installation
running on a Windows machine to a document created on a Lin [...]
+<paragraph xml-lang="en-US" id="hd_id3150700" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3148886" role="code"
l10n="U">DDE("Server"; "File"; "Range"; Mode)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154842" role="paragraph"
l10n="U"><emph>Server</emph> is the name of a server application. <item
type="productname">%PRODUCTNAME</item>applications have the server name
"Soffice".</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153034" role="paragraph"
l10n="U"><emph>File</emph> is the complete file name, including path
specification.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3147472" role="paragraph"
l10n="U"><emph>Range</emph> is the area containing the data to be
evaluated.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3152773" role="paragraph"
l10n="U"><emph>Mode</emph> is an optional parameter that controls the method by
which the DDE server converts its data into numbers.</paragraph>
<table id="tbl_id3155828">
<tablerow>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3154383" role="paragraph" l10n="U"
oldref="185">
-<emph>Mode</emph>
-</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154383" role="paragraph"
l10n="U"><emph>Mode</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3145146" role="paragraph" l10n="U"
oldref="186">
-<emph>Effect</emph>
-</paragraph>
+<paragraph xml-lang="en-US" id="par_id3145146" role="paragraph"
l10n="U"><emph>Effect</emph></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3154558" role="paragraph" l10n="U"
oldref="187">0 or missing</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154558" role="paragraph" l10n="U">0 or
missing</paragraph>
</tablecell>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3145596" role="paragraph" l10n="U"
oldref="188">Number format from the "Default" cell style</paragraph>
+<paragraph xml-lang="en-US" id="par_id3145596" role="paragraph"
l10n="U">Number format from the "Default" cell style</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3152785" role="paragraph" l10n="U"
oldref="189">1</paragraph>
+<paragraph xml-lang="en-US" id="par_id3152785" role="paragraph"
l10n="U">1</paragraph>
</tablecell>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3154380" role="paragraph" l10n="U"
oldref="190">Data are always interpreted in the standard format for US
English</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154380" role="paragraph" l10n="U">Data
are always interpreted in the standard format for US English</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3150279" role="paragraph" l10n="U"
oldref="191">2</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150279" role="paragraph"
l10n="U">2</paragraph>
</tablecell>
<tablecell>
-<paragraph xml-lang="en-US" id="par_id3153775" role="paragraph" l10n="U"
oldref="192">Data are retrieved as text; no conversion to numbers</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153775" role="paragraph" l10n="U">Data
are retrieved as text; no conversion to numbers</paragraph>
</tablecell>
</tablerow>
</table>
-<paragraph xml-lang="en-US" id="hd_id3149546" role="heading" level="3" l10n="U"
-oldref="35">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3148734" role="paragraph" l10n="U"
oldref="36">
-<item
type="input">=DDE("soffice";"c:\office\document\data1.ods";"sheet1.A1")</item>
reads the contents of cell A1 in sheet1 of the <item
type="productname">%PRODUCTNAME</item> Calc spreadsheet data1.ods.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153081" role="paragraph" l10n="U"
oldref="37">
-<item type="input">=DDE("soffice";"c:\office\document\motto.odt";"Today's
motto")</item> returns a motto in the cell containing this formula. First, you
must enter a line in the motto.odt document containing the motto text and
define it as the first line of a section named <item type="literal">Today's
Motto</item> (in <item type="productname">%PRODUCTNAME</item> Writer under
<emph>Insert - Section</emph>). If the motto is modified (and saved) in the
<item type="productname">%PRODUCTNAME< [...]
+<paragraph xml-lang="en-US" id="hd_id3149546" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3148734" role="paragraph" l10n="U"><item
type="input">=DDE("soffice";"c:\office\document\data1.ods";"sheet1.A1")</item>
reads the contents of cell A1 in sheet1 of the <item
type="productname">%PRODUCTNAME</item> Calc spreadsheet data1.ods.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153081" role="paragraph" l10n="U"><item
type="input">=DDE("soffice";"c:\office\document\motto.odt";"Today's
motto")</item> returns a motto in the cell containing this formula. First, you
must enter a line in the motto.odt document containing the motto text and
define it as the first line of a section named <item type="literal">Today's
Motto</item> (in <item type="productname">%PRODUCTNAME</item> Writer under
<emph>Insert - Section</emph>). If the mo [...]
</section>
<section id="Section4">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153114">
<bookmark_value>ERRORTYPE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FEHLERTYP"
id="bm_id3153000" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153114" role="heading" level="2" l10n="U"
-oldref="38">ERRORTYPE</paragraph>
-<paragraph xml-lang="en-US" id="par_id3148568" role="paragraph" l10n="U"
oldref="39"><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="hd_id3153114" role="heading" level="2"
l10n="U">ERRORTYPE</paragraph>
+<paragraph xml-lang="en-US" id="par_id3148568" role="paragraph"
l10n="U"><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>
<embed href="text/shared/00/00000001.xhp#wahr"/>
-<paragraph xml-lang="en-US" id="par_id3149877" role="note" l10n="U"
oldref="40">The Status Bar displays the predefined error code from <item
type="productname">%PRODUCTNAME</item> if you click the cell containing the
error.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3154327" role="heading" level="3" l10n="U"
-oldref="41">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3151322" role="code" l10n="U"
oldref="42">ERRORTYPE(Reference)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150132" role="paragraph" l10n="U"
oldref="43">
-<emph>Reference</emph> contains the address of the cell in which the error
occurs.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3145248" role="heading" level="3" l10n="U"
-oldref="44">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3146904" role="paragraph" l10n="U"
oldref="45">If cell A1 displays Err:518, the function <item
type="input">=ERRORTYPE(A1)</item> returns the number 518.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149877" role="note" l10n="U">The Status
Bar displays the predefined error code from <item
type="productname">%PRODUCTNAME</item> if you click the cell containing the
error.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3154327" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3151322" role="code"
l10n="U">ERRORTYPE(Reference)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150132" role="paragraph"
l10n="U"><emph>Reference</emph> contains the address of the cell in which the
error occurs.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3145248" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3146904" role="paragraph" l10n="U">If
cell A1 displays Err:518, the function <item type="input">=ERRORTYPE(A1)</item>
returns the number 518.</paragraph>
</section>
<section id="Section5">
<bookmark xml-lang="en-US" branch="index" id="bm_id3151221">
<bookmark_value>INDEX function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_INDEX" id="bm_id3157989"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3151221" role="heading" level="2" l10n="U"
-oldref="47">INDEX</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150268" role="paragraph" l10n="CHG"
oldref="48"><ahelp hid="HID_FUNC_INDEX">INDEX returns a sub range, specified by
row and column number, or an optional range index. Depending on context, INDEX
returns a reference or content.</ahelp><comment>UFI: will change with i4904;
see
http://so-web.germany.sun.com/iBIS/servlet/edit.ControlPanel?tid=i57108</comment><comment>changed
by i83070</comment></paragraph>
-<paragraph xml-lang="en-US" id="hd_id3156063" role="heading" level="3" l10n="U"
-oldref="49">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149007" role="code" l10n="U"
oldref="50">INDEX(Reference; Row; Column; Range)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153260" role="paragraph" l10n="CHG"
oldref="51">
-<emph>Reference</emph> is a reference, entered either directly or by
specifying a range name. If the reference consists of multiple ranges, you must
enclose the reference or range name in parentheses.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3145302" role="paragraph" l10n="CHG"
oldref="52">
-<emph>Row</emph> (optional) represents the row index of the reference range,
for which to return a value. In case of zero (no specific row) all referenced
rows are returned.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154628" role="paragraph" l10n="CHG"
oldref="53">
-<emph>Column</emph> (optional) represents the column index of the reference
range, for which to return a value. In case of zero (no specific column) all
referenced columns are returned.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155514" role="paragraph" l10n="U"
oldref="54">
-<emph>Range</emph> (optional) represents the index of the subrange if
referring to a multiple range.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3145264" role="heading" level="3" l10n="U"
-oldref="55">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3159112" role="paragraph" l10n="U"
oldref="56">
-<item type="input">=INDEX(Prices;4;1)</item> 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 xml-lang="en-US" id="par_id3150691" role="paragraph" l10n="U"
oldref="57">
-<item type="input">=INDEX(SumX;4;1)</item> returns the value from the range
<emph>SumX</emph> in row 4 and column 1 as defined in <emph>Insert - Names -
Define</emph>.</paragraph>
-<paragraph xml-lang="en-US" id="par_id4109012" role="paragraph" l10n="NEW">
-<item type="input">=INDEX(A1:B6;1)</item> returns a reference to the first row
of A1:B6.</paragraph>
-<paragraph xml-lang="en-US" id="par_id9272133" role="paragraph" l10n="NEW">
-<item type="input">=INDEX(A1:B6;0;1)</item> returns a reference to the first
column of A1:B6.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3158419" role="paragraph" l10n="U"
oldref="58">
-<item type="input">=INDEX((multi);4;1)</item> indicates the value contained in
row 4 and column 1 of the (multiple) range, which you named under <emph>Insert
- Names - Set</emph> as <emph>multi</emph>. The multiple range may consist of
several rectangular ranges, each with a row 4 and column 1. If you now want to
call the second block of this multiple range enter the number <item
type="input">2</item> as the <emph>range</emph> parameter.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3148595" role="paragraph" l10n="U"
oldref="59">
-<item type="input">=INDEX(A1:B6;1;1)</item> indicates the value in the
upper-left of the A1:B6 range.</paragraph>
-<paragraph xml-lang="en-US" id="par_id9960020" role="paragraph" l10n="NEW">
-<item type="input">=INDEX((multi);0;0;2)</item> returns a reference to the
second range of the multiple range.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3151221" role="heading" level="2"
l10n="U">INDEX</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150268" role="paragraph"
l10n="CHG"><ahelp hid="HID_FUNC_INDEX">INDEX returns a sub range, specified by
row and column number, or an optional range index. Depending on context, INDEX
returns a reference or content.</ahelp><comment>UFI: will change with i4904;
see
http://so-web.germany.sun.com/iBIS/servlet/edit.ControlPanel?tid=i57108</comment><comment>changed
by i83070</comment></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3156063" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149007" role="code"
l10n="U">INDEX(Reference; Row; Column; Range)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153260" role="paragraph"
l10n="CHG"><emph>Reference</emph> is a reference, entered either directly or by
specifying a range name. If the reference consists of multiple ranges, you must
enclose the reference or range name in parentheses.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3145302" role="paragraph"
l10n="CHG"><emph>Row</emph> (optional) represents the row index of the
reference range, for which to return a value. In case of zero (no specific row)
all referenced rows are returned.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154628" role="paragraph"
l10n="CHG"><emph>Column</emph> (optional) represents the column index of the
reference range, for which to return a value. In case of zero (no specific
column) all referenced columns are returned.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155514" role="paragraph"
l10n="U"><emph>Range</emph> (optional) represents the index of the subrange if
referring to a multiple range.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3145264" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3159112" role="paragraph" l10n="U"><item
type="input">=INDEX(Prices;4;1)</item> 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 xml-lang="en-US" id="par_id3150691" role="paragraph" l10n="U"><item
type="input">=INDEX(SumX;4;1)</item> returns the value from the range
<emph>SumX</emph> in row 4 and column 1 as defined in <emph>Insert - Names -
Define</emph>.</paragraph>
+<paragraph xml-lang="en-US" id="par_id4109012" role="paragraph"
l10n="NEW"><item type="input">=INDEX(A1:B6;1)</item> returns a reference to the
first row of A1:B6.</paragraph>
+<paragraph xml-lang="en-US" id="par_id9272133" role="paragraph"
l10n="NEW"><item type="input">=INDEX(A1:B6;0;1)</item> returns a reference to
the first column of A1:B6.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3158419" role="paragraph" l10n="U"><item
type="input">=INDEX((multi);4;1)</item> indicates the value contained in row 4
and column 1 of the (multiple) range, which you named under <emph>Insert -
Names - Set</emph> as <emph>multi</emph>. The multiple range may consist of
several rectangular ranges, each with a row 4 and column 1. If you now want to
call the second block of this multiple range enter the number <item
type="input">2</item> as the <emph>r [...]
+<paragraph xml-lang="en-US" id="par_id3148595" role="paragraph" l10n="U"><item
type="input">=INDEX(A1:B6;1;1)</item> indicates the value in the upper-left of
the A1:B6 range.</paragraph>
+<paragraph xml-lang="en-US" id="par_id9960020" role="paragraph"
l10n="NEW"><item type="input">=INDEX((multi);0;0;2)</item> returns a reference
to the second range of the multiple range.</paragraph>
</section>
<section id="Section6">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153181">
<bookmark_value>INDIRECT function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_INDIREKT" id="bm_id3153922"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153181" role="heading" level="2" l10n="U"
-oldref="62">INDIRECT</paragraph>
-<paragraph xml-lang="en-US" id="par_id3147169" role="paragraph" l10n="U"
oldref="63"><ahelp hid="HID_FUNC_INDIREKT">Returns the <emph>reference</emph>
specified by a text string.</ahelp> This function can also be used to return
the area of a corresponding string.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3153181" role="heading" level="2"
l10n="U">INDIRECT</paragraph>
+<paragraph xml-lang="en-US" id="par_id3147169" role="paragraph"
l10n="U"><ahelp hid="HID_FUNC_INDIREKT">Returns the <emph>reference</emph>
specified by a text string.</ahelp> This function can also be used to return
the area of a corresponding string.</paragraph>
<embed href="text/scalc/01/04060109.xhp#r1c1"/>
-<paragraph xml-lang="en-US" id="hd_id3153717" role="heading" level="3" l10n="U"
-oldref="64">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149824" role="code" l10n="U"
oldref="65">INDIRECT(Ref; A1)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154317" role="paragraph" l10n="U"
oldref="66">
-<emph>Ref</emph> represents a reference to a cell or an area (in text form)
for which to return the contents.</paragraph>
-<paragraph xml-lang="en-US" id="par_id1027200802470312" role="paragraph"
l10n="NEW">
-<emph>A1</emph> (optional) - if set to 0, the R1C1 notation is used. If this
parameter is absent or set to another value than 0, the A1 notation is
used.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3153717" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149824" role="code"
l10n="U">INDIRECT(Ref; A1)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154317" role="paragraph"
l10n="U"><emph>Ref</emph> represents a reference to a cell or an area (in text
form) for which to return the contents.</paragraph>
+<paragraph xml-lang="en-US" id="par_id1027200802470312" role="paragraph"
l10n="NEW"><emph>A1</emph> (optional) - if set to 0, the R1C1 notation is used.
If this parameter is absent or set to another value than 0, the A1 notation is
used.</paragraph>
<paragraph xml-lang="en-US" id="par_idN10CAE" role="note" l10n="NEW">If you
open an Excel spreadsheet that uses indirect addresses calculated from string
functions, the sheet addresses will not be translated automatically. For
example, the Excel address in INDIRECT("filename!sheetname"&B1) is not
converted into the Calc address in
INDIRECT("filename.sheetname"&B1).<comment>UFI: for
#i34465#</comment></paragraph>
-<paragraph xml-lang="en-US" id="hd_id3150389" role="heading" level="3" l10n="U"
-oldref="67">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150608" role="paragraph" l10n="U"
oldref="68">
-<item type="input">=INDIRECT(A1)</item> equals 100 if A1 contains C108 as a
reference and cell C108 contains a value of <item
type="input">100</item>.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3083286" role="paragraph" l10n="CHG"
oldref="181">
-<item type="input">=SUM(INDIRECT("a1:" & ADDRESS(1;3)))</item> totals the
cells in the area of A1 up to the cell with the address defined by row 1 and
column 3. This means that area A1:C1 is totaled.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3150389" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150608" role="paragraph" l10n="U"><item
type="input">=INDIRECT(A1)</item> equals 100 if A1 contains C108 as a reference
and cell C108 contains a value of <item type="input">100</item>.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3083286" role="paragraph"
l10n="CHG"><item type="input">=SUM(INDIRECT("a1:" & ADDRESS(1;3)))</item>
totals the cells in the area of A1 up to the cell with the address defined by
row 1 and column 3. This means that area A1:C1 is totaled.</paragraph>
</section>
<section id="Section7">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154818">
<bookmark_value>COLUMN function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SPALTE" id="bm_id3156378"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154818" role="heading" level="2" l10n="U"
-oldref="70">COLUMN</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149711" role="paragraph" l10n="U"
oldref="193"><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#somatrixformel" [...]
-<paragraph xml-lang="en-US" id="hd_id3149283" role="heading" level="3" l10n="U"
-oldref="72">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149447" role="code" l10n="U"
oldref="73">COLUMN(Reference)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3156310" role="paragraph" l10n="U"
oldref="74">
-<emph>Reference</emph> is the reference to a cell or cell area whose first
column number is to be found.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155837" role="paragraph" l10n="U"
oldref="194">If no reference is entered, the column number of the cell in which
the formula is entered is found. <item type="productname">%PRODUCTNAME</item>
Calc automatically sets the reference to the current cell.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3152932" role="heading" level="3" l10n="U"
-oldref="75">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3147571" role="paragraph" l10n="U"
oldref="76">
-<item type="input">=COLUMN(A1)</item> equals 1. Column A is the first column
in the table.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3147079" role="paragraph" l10n="U"
oldref="77">
-<item type="input">=COLUMN(C3:E3)</item> equals 3. Column C is the third
column in the table.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3146861" role="paragraph" l10n="U"
oldref="195">
-<item type="input">=COLUMN(D3:G10)</item> returns 4 because column D is the
fourth column in the table and the COLUMN function is not used as an array
formula. (In this case, the first value of the array is always used as the
result.)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3156320" role="paragraph" l10n="U"
oldref="196">
-<item type="input">{=COLUMN(B2:B7)}</item> and <item
type="input">=COLUMN(B2:B7)</item> both return 2 because the reference only
contains column B as the second column in the table. Because single-column
areas have only one column number, it does not make a difference whether or not
the formula is used as an array formula.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150872" role="paragraph" l10n="U"
oldref="197">
-<item type="input">=COLUMN()</item> returns 3 if the formula was entered in
column C.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153277" role="paragraph" l10n="U"
oldref="198">
-<item type="input">{=COLUMN(Rabbit)}</item> returns the single-row array (3,
4) if "Rabbit" is the named area (C1:D3).</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3154818" role="heading" level="2"
l10n="U">COLUMN</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149711" role="paragraph"
l10n="U"><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#somatrixformel" name="as an a [...]
+<paragraph xml-lang="en-US" id="hd_id3149283" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149447" role="code"
l10n="U">COLUMN(Reference)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3156310" role="paragraph"
l10n="U"><emph>Reference</emph> is the reference to a cell or cell area whose
first column number is to be found.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155837" role="paragraph" l10n="U">If no
reference is entered, the column number of the cell in which the formula is
entered is found. <item type="productname">%PRODUCTNAME</item> Calc
automatically sets the reference to the current cell.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3152932" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3147571" role="paragraph" l10n="U"><item
type="input">=COLUMN(A1)</item> equals 1. Column A is the first column in the
table.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3147079" role="paragraph" l10n="U"><item
type="input">=COLUMN(C3:E3)</item> equals 3. Column C is the third column in
the table.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3146861" role="paragraph" l10n="U"><item
type="input">=COLUMN(D3:G10)</item> returns 4 because column D is the fourth
column in the table and the COLUMN function is not used as an array formula.
(In this case, the first value of the array is always used as the
result.)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3156320" role="paragraph" l10n="U"><item
type="input">{=COLUMN(B2:B7)}</item> and <item
type="input">=COLUMN(B2:B7)</item> both return 2 because the reference only
contains column B as the second column in the table. Because single-column
areas have only one column number, it does not make a difference whether or not
the formula is used as an array formula.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150872" role="paragraph" l10n="U"><item
type="input">=COLUMN()</item> returns 3 if the formula was entered in column
C.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153277" role="paragraph" l10n="U"><item
type="input">{=COLUMN(Rabbit)}</item> returns the single-row array (3, 4) if
"Rabbit" is the named area (C1:D3).</paragraph>
</section>
<section id="Section8">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154643">
<bookmark_value>COLUMNS function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SPALTEN" id="bm_id3156134"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154643" role="heading" level="2" l10n="U"
-oldref="79">COLUMNS</paragraph>
-<paragraph xml-lang="en-US" id="par_id3151182" role="paragraph" l10n="U"
oldref="80"><ahelp hid="HID_FUNC_SPALTEN">Returns the number of columns in the
given reference.</ahelp></paragraph>
-<paragraph xml-lang="en-US" id="hd_id3149141" role="heading" level="3" l10n="U"
-oldref="81">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154047" role="code" l10n="U"
oldref="82">COLUMNS(Array)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154745" role="paragraph" l10n="U"
oldref="83">
-<emph>Array</emph> is the reference to a cell range whose total number of
columns is to be found. The argument can also be a single cell.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3153622" role="heading" level="3" l10n="U"
-oldref="84">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149577" role="paragraph" l10n="U"
oldref="200">
-<item type="input">=COLUMNS(B5)</item> returns 1 because a cell only contains
one column.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3145649" role="paragraph" l10n="U"
oldref="85">
-<item type="input">=COLUMNS(A1:C5)</item> equals 3. The reference comprises
three columns.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155846" role="paragraph" l10n="U"
oldref="201">
-<item type="input">=COLUMNS(Rabbit)</item> returns 2 if <item
type="literal">Rabbit</item> is the named range (C1:D3).</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3154643" role="heading" level="2"
l10n="U">COLUMNS</paragraph>
+<paragraph xml-lang="en-US" id="par_id3151182" role="paragraph"
l10n="U"><ahelp hid="HID_FUNC_SPALTEN">Returns the number of columns in the
given reference.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3149141" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154047" role="code"
l10n="U">COLUMNS(Array)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154745" role="paragraph"
l10n="U"><emph>Array</emph> is the reference to a cell range whose total number
of columns is to be found. The argument can also be a single cell.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3153622" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149577" role="paragraph" l10n="U"><item
type="input">=COLUMNS(B5)</item> returns 1 because a cell only contains one
column.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3145649" role="paragraph" l10n="U"><item
type="input">=COLUMNS(A1:C5)</item> equals 3. The reference comprises three
columns.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155846" role="paragraph" l10n="U"><item
type="input">=COLUMNS(Rabbit)</item> returns 2 if <item
type="literal">Rabbit</item> is the named range (C1:D3).</paragraph>
</section>
<section id="Section9">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153152">
@@ -301,30 +235,21 @@ oldref="84">Example</paragraph>
<bookmark_value>VLOOKUP function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SVERWEIS" id="bm_id3152809"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153152" role="heading" level="2" l10n="U"
-oldref="87">VLOOKUP</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149984" role="paragraph" l10n="CHG"
oldref="88"><ahelp hid="HID_FUNC_SVERWEIS">Vertical search with reference to
adjacent cells to the right.</ahelp> This function checks if a specific value
is contained in the first column of an array. The function then returns the
value in the same row of the column named by <item type="literal">Index</item>.
If the <item type="literal">SortOrder</item> parameter is omitted or set to
TRUE or one, it is assumed tha [...]
+<paragraph xml-lang="en-US" id="hd_id3153152" role="heading" level="2"
l10n="U">VLOOKUP</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149984" role="paragraph"
l10n="CHG"><ahelp hid="HID_FUNC_SVERWEIS">Vertical search with reference to
adjacent cells to the right.</ahelp> This function checks if a specific value
is contained in the first column of an array. The function then returns the
value in the same row of the column named by <item type="literal">Index</item>.
If the <item type="literal">SortOrder</item> parameter is omitted or set to
TRUE or one, it is assumed that the data i [...]
<embed href="text/shared/00/00000001.xhp#regulaer"/>
-<paragraph xml-lang="en-US" id="hd_id3146898" role="heading" level="3" l10n="U"
-oldref="89">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150156" role="code" l10n="U"
oldref="90">=VLOOKUP(SearchCriterion; Array; Index; SortOrder)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149289" role="paragraph" l10n="U"
oldref="91">
-<emph>SearchCriterion</emph> is the value searched for in the first column of
the array.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153884" role="paragraph" l10n="U"
oldref="92">
-<emph>Array</emph> is the reference, which is to comprise at least two
columns.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3156005" role="paragraph" l10n="U"
oldref="93">
-<emph>Index</emph> is the number of the column in the array that contains the
value to be returned. The first column has the number 1.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3151208" role="paragraph" l10n="U"
oldref="94">
-<emph>SortOrder</emph> is an optional parameter that indicates whether the
first column in the array is sorted in ascending order. Enter the Boolean value
FALSE or zero if the first column is not sorted in ascending order. Sorted
columns can be searched much faster and the function always returns a value,
even if the search value was not matched exactly, if it is between the lowest
and highest value of the sorted list. In unsorted lists, the search value must
be matched exactly. Otherwis [...]
+<paragraph xml-lang="en-US" id="hd_id3146898" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150156" role="code"
l10n="U">=VLOOKUP(SearchCriterion; Array; Index; SortOrder)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149289" role="paragraph"
l10n="U"><emph>SearchCriterion</emph> is the value searched for in the first
column of the array.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153884" role="paragraph"
l10n="U"><emph>Array</emph> is the reference, which is to comprise at least two
columns.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3156005" role="paragraph"
l10n="U"><emph>Index</emph> is the number of the column in the array that
contains the value to be returned. The first column has the number
1.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3151208" role="paragraph"
l10n="U"><emph>SortOrder</emph> is an optional parameter that indicates whether
the first column in the array is sorted in ascending order. Enter the Boolean
value FALSE or zero if the first column is not sorted in ascending order.
Sorted columns can be searched much faster and the function always returns a
value, even if the search value was not matched exactly, if it is between the
lowest and highest value of the sorted li [...]
<embed href="text/scalc/05/empty_cells.xhp#empty_cells"/>
-<paragraph xml-lang="en-US" id="hd_id3147487" role="heading" level="3" l10n="U"
-oldref="95">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154129" role="paragraph" l10n="U"
oldref="96">You want to enter the number of a dish on the menu in cell A1, and
the name of the dish is to appear as text in the neighboring cell (B1)
immediately. The Number to Name assignment is contained in the D1:E100 array.
D1 contains <item type="input">100</item>, E1 contains the name <item
type="input">Vegetable Soup</item>, and so forth, for 100 menu items. The
numbers in column D are sorted in ascending ord [...]
-<paragraph xml-lang="en-US" id="par_id3145663" role="paragraph" l10n="U"
oldref="97">Enter the following formula in B1:</paragraph>
-<paragraph xml-lang="en-US" id="par_id3151172" role="paragraph" l10n="U"
oldref="98">
-<item type="input">=VLOOKUP(A1;D1:E100;2)</item>
-</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149200" role="paragraph" l10n="U"
oldref="99">As soon as you enter a number in A1 B1 will show the corresponding
text contained in the second column of reference D1:E100. Entering a
nonexistent number displays the text with the next number down. To prevent
this, enter FALSE as the last parameter in the formula so that an error message
is generated when a nonexistent number is entered.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3147487" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154129" role="paragraph" l10n="U">You
want to enter the number of a dish on the menu in cell A1, and the name of the
dish is to appear as text in the neighboring cell (B1) immediately. The Number
to Name assignment is contained in the D1:E100 array. D1 contains <item
type="input">100</item>, E1 contains the name <item type="input">Vegetable
Soup</item>, and so forth, for 100 menu items. The numbers in column D are
sorted in ascending order; thus, th [...]
+<paragraph xml-lang="en-US" id="par_id3145663" role="paragraph" l10n="U">Enter
the following formula in B1:</paragraph>
+<paragraph xml-lang="en-US" id="par_id3151172" role="paragraph" l10n="U"><item
type="input">=VLOOKUP(A1;D1:E100;2)</item></paragraph>
+<paragraph xml-lang="en-US" id="par_id3149200" role="paragraph" l10n="U">As
soon as you enter a number in A1 B1 will show the corresponding text contained
in the second column of reference D1:E100. Entering a nonexistent number
displays the text with the next number down. To prevent this, enter FALSE as
the last parameter in the formula so that an error message is generated when a
nonexistent number is entered.</paragraph>
</section>
<section id="Section10">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153905">
@@ -332,18 +257,13 @@ oldref="95">Example</paragraph>
<bookmark_value>SHEET function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TABELLE" id="bm_id3154693"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153905" role="heading" level="2" l10n="U"
-oldref="215">SHEET</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150309" role="paragraph" l10n="U"
oldref="216"><ahelp hid="HID_FUNC_TABELLE">Returns the sheet number of a
reference or a string representing a sheet name.</ahelp> If you do not enter
any parameters, the result is the sheet number of the spreadsheet containing
the formula.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3148564" role="heading" level="3" l10n="U"
-oldref="217">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153095" role="code" l10n="U"
oldref="218">SHEET(Reference)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154588" role="paragraph" l10n="U"
oldref="219">
-<emph>Reference</emph> is optional and is the reference to a cell, an area, or
a sheet name string.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3155399" role="heading" level="3" l10n="U"
-oldref="220">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3146988" role="paragraph" l10n="U"
oldref="221">
-<item type="input">=SHEET(Sheet2.A1)</item> returns 2 if Sheet2 is the second
sheet in the spreadsheet document.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3153905" role="heading" level="2"
l10n="U">SHEET</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150309" role="paragraph"
l10n="U"><ahelp hid="HID_FUNC_TABELLE">Returns the sheet number of a reference
or a string representing a sheet name.</ahelp> If you do not enter any
parameters, the result is the sheet number of the spreadsheet containing the
formula.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3148564" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153095" role="code"
l10n="U">SHEET(Reference)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154588" role="paragraph"
l10n="U"><emph>Reference</emph> is optional and is the reference to a cell, an
area, or a sheet name string.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3155399" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3146988" role="paragraph" l10n="U"><item
type="input">=SHEET(Sheet2.A1)</item> returns 2 if Sheet2 is the second sheet
in the spreadsheet document.</paragraph>
</section>
<section id="Section11">
<bookmark xml-lang="en-US" branch="index" id="bm_id3148829">
@@ -351,138 +271,92 @@ oldref="220">Example</paragraph>
<bookmark_value>SHEETS function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TABELLEN" id="bm_id3150524"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3148829" role="heading" level="2" l10n="U"
-oldref="222">SHEETS</paragraph>
-<paragraph xml-lang="en-US" id="par_id3148820" role="paragraph" l10n="U"
oldref="223"><ahelp hid="HID_FUNC_TABELLEN">Determines the number of sheets in
a reference.</ahelp> If you do not enter any parameters, it returns the number
of sheets in the current document.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3154220" role="heading" level="3" l10n="U"
-oldref="224">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150777" role="code" l10n="U"
oldref="225">SHEETS(Reference)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153060" role="paragraph" l10n="U"
oldref="226">
-<emph>Reference</emph> is the reference to a sheet or an area. This parameter
is optional.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3149766" role="heading" level="3" l10n="U"
-oldref="227">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150507" role="paragraph" l10n="U"
oldref="228">
-<item type="input">=SHEETS(Sheet1.A1:Sheet3.G12)</item> returns 3 if Sheet1,
Sheet2, and Sheet3 exist in the sequence indicated.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3148829" role="heading" level="2"
l10n="U">SHEETS</paragraph>
+<paragraph xml-lang="en-US" id="par_id3148820" role="paragraph"
l10n="U"><ahelp hid="HID_FUNC_TABELLEN">Determines the number of sheets in a
reference.</ahelp> If you do not enter any parameters, it returns the number of
sheets in the current document.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3154220" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150777" role="code"
l10n="U">SHEETS(Reference)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153060" role="paragraph"
l10n="U"><emph>Reference</emph> is the reference to a sheet or an area. This
parameter is optional.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3149766" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150507" role="paragraph" l10n="U"><item
type="input">=SHEETS(Sheet1.A1:Sheet3.G12)</item> returns 3 if Sheet1, Sheet2,
and Sheet3 exist in the sequence indicated.</paragraph>
</section>
<section id="Section12">
<bookmark xml-lang="en-US" branch="index" id="bm_id3158407">
<bookmark_value>MATCH function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VERGLEICH"
id="bm_id3154210" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3158407" role="heading" level="2" l10n="U"
-oldref="101">MATCH</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154896" role="paragraph" l10n="U"
oldref="102"><ahelp hid="HID_FUNC_VERGLEICH">Returns the relative position of
an item in an array that matches a specified value.</ahelp> The function
returns the position of the value found in the lookup_array as a
number.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3153834" role="heading" level="3" l10n="U"
-oldref="103">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3159152" role="code" l10n="U"
oldref="104">MATCH(SearchCriterion; LookupArray; Type)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149336" role="paragraph" l10n="U"
oldref="105">
-<emph>SearchCriterion</emph> is the value which is to be searched for in the
single-row or single-column array.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3159167" role="paragraph" l10n="U"
oldref="106">
-<emph>LookupArray</emph> is the reference searched. A lookup array can be a
single row or column, or part of a single row or column.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3147239" role="paragraph" l10n="U"
oldref="107">
-<emph>Type</emph> may take the values 1, 0, or -1. If Type = 1 or if this
optional parameter is missing, it is assumed that the first column of the
search array is sorted in ascending order. If Type = -1 it is assumed that the
column in sorted in descending order. This corresponds to the same function in
Microsoft Excel.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154265" role="paragraph" l10n="CHG"
oldref="231">If Type = 0, only exact matches are found. If the search criterion
is found more than once, the function returns the index of the first matching
value. Only if Type = 0 can you search for regular expressions.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3147528" role="paragraph" l10n="CHG"
oldref="232">If Type = 1 or the third parameter is missing, the index of the
last value that is smaller or equal to the search criterion is returned. This
applies even when the search array is not sorted. For Type = -1, the first
value that is larger or equal is returned.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3158407" role="heading" level="2"
l10n="U">MATCH</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154896" role="paragraph"
l10n="U"><ahelp hid="HID_FUNC_VERGLEICH">Returns the relative position of an
item in an array that matches a specified value.</ahelp> The function returns
the position of the value found in the lookup_array as a number.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3153834" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3159152" role="code"
l10n="U">MATCH(SearchCriterion; LookupArray; Type)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149336" role="paragraph"
l10n="U"><emph>SearchCriterion</emph> is the value which is to be searched for
in the single-row or single-column array.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3159167" role="paragraph"
l10n="U"><emph>LookupArray</emph> is the reference searched. A lookup array can
be a single row or column, or part of a single row or column.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3147239" role="paragraph"
l10n="U"><emph>Type</emph> may take the values 1, 0, or -1. If Type = 1 or if
this optional parameter is missing, it is assumed that the first column of the
search array is sorted in ascending order. If Type = -1 it is assumed that the
column in sorted in descending order. This corresponds to the same function in
Microsoft Excel.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154265" role="paragraph" l10n="CHG">If
Type = 0, only exact matches are found. If the search criterion is found more
than once, the function returns the index of the first matching value. Only if
Type = 0 can you search for regular expressions.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3147528" role="paragraph" l10n="CHG">If
Type = 1 or the third parameter is missing, the index of the last value that is
smaller or equal to the search criterion is returned. This applies even when
the search array is not sorted. For Type = -1, the first value that is larger
or equal is returned.</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
-<paragraph xml-lang="en-US" id="hd_id3155119" role="heading" level="3" l10n="U"
-oldref="108">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155343" role="paragraph" l10n="U"
oldref="109">
-<item type="input">=MATCH(200;D1:D100)</item> searches the area D1:D100, which
is sorted by column D, for the value 200. As soon as this value is reached, the
number of the row in which it was found is returned. If a higher value is found
during the search in the column, the number of the previous row is
returned.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3155119" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155343" role="paragraph" l10n="U"><item
type="input">=MATCH(200;D1:D100)</item> searches the area D1:D100, which is
sorted by column D, for the value 200. As soon as this value is reached, the
number of the row in which it was found is returned. If a higher value is found
during the search in the column, the number of the previous row is
returned.</paragraph>
</section>
<section id="Section13">
<bookmark xml-lang="en-US" branch="index" id="bm_id3158430">
<bookmark_value>OFFSET function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VERSCHIEBUNG"
id="bm_id3148926" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3158430" role="heading" level="2" l10n="U"
-oldref="111">OFFSET</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149167" role="paragraph" l10n="U"
oldref="112"><ahelp hid="HID_FUNC_VERSCHIEBUNG">Returns the value of a cell
offset by a certain number of rows and columns from a given reference
point.</ahelp></paragraph>
-<paragraph xml-lang="en-US" id="hd_id3146952" role="heading" level="3" l10n="U"
-oldref="113">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3159194" role="code" l10n="U"
oldref="114">OFFSET(Reference; Rows; Columns; Height; Width)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3152360" role="paragraph" l10n="CHG"
oldref="115">
-<emph>Reference</emph> is the reference from which the function searches for
the new reference.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3156032" role="paragraph" l10n="CHG"
oldref="116">
-<emph>Rows</emph> is the number of rows by which the reference was corrected
up (negative value) or down.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3166458" role="paragraph" l10n="CHG"
oldref="117">
-<emph>Columns</emph> (optional) is the number of columns by which the
reference was corrected to the left (negative value) or to the
right.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150708" role="paragraph" l10n="CHG"
oldref="118">
-<emph>Height</emph> (optional) is the vertical height for an area that starts
at the new reference position.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3147278" role="paragraph" l10n="CHG"
oldref="119">
-<emph>Width</emph> (optional) is the horizontal width for an area that starts
at the new reference position.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3158430" role="heading" level="2"
l10n="U">OFFSET</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149167" role="paragraph"
l10n="U"><ahelp hid="HID_FUNC_VERSCHIEBUNG">Returns the value of a cell offset
by a certain number of rows and columns from a given reference
point.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3146952" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3159194" role="code"
l10n="U">OFFSET(Reference; Rows; Columns; Height; Width)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3152360" role="paragraph"
l10n="CHG"><emph>Reference</emph> is the reference from which the function
searches for the new reference.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3156032" role="paragraph"
l10n="CHG"><emph>Rows</emph> is the number of rows by which the reference was
corrected up (negative value) or down.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3166458" role="paragraph"
l10n="CHG"><emph>Columns</emph> (optional) is the number of columns by which
the reference was corrected to the left (negative value) or to the
right.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150708" role="paragraph"
l10n="CHG"><emph>Height</emph> (optional) is the vertical height for an area
that starts at the new reference position.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3147278" role="paragraph"
l10n="CHG"><emph>Width</emph> (optional) is the horizontal width for an area
that starts at the new reference position.</paragraph>
<paragraph xml-lang="en-US" id="par_id8662373" role="paragraph"
l10n="CHG">Arguments <emph>Rows</emph> and <emph>Columns</emph> must not lead
to zero or negative start row or column.</paragraph>
<paragraph xml-lang="en-US" id="par_id9051484" role="paragraph"
l10n="NEW">Arguments <emph>Height</emph> and <emph>Width</emph> must not lead
to zero or negative count of rows or columns.</paragraph>
-<paragraph xml-lang="en-US" id="par_idN1104B" role="paragraph" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#optional"/>
-</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3155586" role="heading" level="3" l10n="U"
-oldref="120">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149744" role="paragraph" l10n="CHG"
oldref="121">
-<item type="input">=OFFSET(A1;2;2)</item> returns the value in cell C3 (A1
moved by two rows and two columns down). If C3 contains the value <item
type="input">100</item> this function returns the value 100.</paragraph>
-<paragraph xml-lang="en-US" id="par_id7439802" role="paragraph" l10n="NEW">
-<item type="input">=OFFSET(B2:C3;1;1)</item> returns a reference to B2:C3
moved down by 1 row and one column to the right (C3:D4).</paragraph>
-<paragraph xml-lang="en-US" id="par_id3009430" role="paragraph" l10n="NEW">
-<item type="input">=OFFSET(B2:C3;-1;-1)</item> returns a reference to B2:C3
moved up by 1 row and one column to the left (A1:B2).</paragraph>
-<paragraph xml-lang="en-US" id="par_id2629169" role="paragraph" l10n="NEW">
-<item type="input">=OFFSET(B2:C3;0;0;3;4)</item> returns a reference to B2:C3
resized to 3 rows and 4 columns (B2:E4).</paragraph>
-<paragraph xml-lang="en-US" id="par_id6668599" role="paragraph" l10n="NEW">
-<item type="input">=OFFSET(B2:C3;1;0;3;4)</item> returns a reference to B2:C3
moved down by one row resized to 3 rows and 4 columns (B2:E4).</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153739" role="paragraph" l10n="U"
oldref="122">
-<item type="input">=SUM(OFFSET(A1;2;2;5;6))</item> 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>
+<paragraph xml-lang="en-US" id="par_idN1104B" role="paragraph"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3155586" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149744" role="paragraph"
l10n="CHG"><item type="input">=OFFSET(A1;2;2)</item> returns the value in cell
C3 (A1 moved by two rows and two columns down). If C3 contains the value <item
type="input">100</item> this function returns the value 100.</paragraph>
+<paragraph xml-lang="en-US" id="par_id7439802" role="paragraph"
l10n="NEW"><item type="input">=OFFSET(B2:C3;1;1)</item> returns a reference to
B2:C3 moved down by 1 row and one column to the right (C3:D4).</paragraph>
+<paragraph xml-lang="en-US" id="par_id3009430" role="paragraph"
l10n="NEW"><item type="input">=OFFSET(B2:C3;-1;-1)</item> returns a reference
to B2:C3 moved up by 1 row and one column to the left (A1:B2).</paragraph>
+<paragraph xml-lang="en-US" id="par_id2629169" role="paragraph"
l10n="NEW"><item type="input">=OFFSET(B2:C3;0;0;3;4)</item> returns a reference
to B2:C3 resized to 3 rows and 4 columns (B2:E4).</paragraph>
+<paragraph xml-lang="en-US" id="par_id6668599" role="paragraph"
l10n="NEW"><item type="input">=OFFSET(B2:C3;1;0;3;4)</item> returns a reference
to B2:C3 moved down by one row resized to 3 rows and 4 columns
(B2:E4).</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153739" role="paragraph" l10n="U"><item
type="input">=SUM(OFFSET(A1;2;2;5;6))</item> 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>
</section>
<section id="Section14">
<bookmark xml-lang="en-US" branch="index" id="bm_id3159273">
<bookmark_value>LOOKUP function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VERWEIS" id="bm_id3152877"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3159273" role="heading" level="2" l10n="U"
-oldref="123">LOOKUP</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153389" role="paragraph" l10n="CHG"
oldref="124"><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" name="VLOOKUP">VLOOKUP</link> and
<link href="text/scalc/01/04060109.xhp" name="HLOOKUP">HLOOKUP</link>, search
and result vector may be at diff [...]
+<paragraph xml-lang="en-US" id="hd_id3159273" role="heading" level="2"
l10n="U">LOOKUP</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153389" role="paragraph"
l10n="CHG"><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" name="VLOOKUP">VLOOKUP</link> and <link
href="text/scalc/01/04060109.xhp" name="HLOOKUP">HLOOKUP</link>, search and
result vector may be at different positio [...]
<paragraph xml-lang="en-US" id="par_id4484084" role="note" l10n="NEW">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.</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
-<paragraph xml-lang="en-US" id="hd_id3152947" role="heading" level="3" l10n="U"
-oldref="125">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154104" role="code" l10n="U"
oldref="126">LOOKUP(SearchCriterion; SearchVector; ResultVector)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150646" role="paragraph" l10n="U"
oldref="127">
-<emph>SearchCriterion</emph> is the value to be searched for; entered either
directly or as a reference.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154854" role="paragraph" l10n="U"
oldref="128">
-<emph>SearchVector</emph> is the single-row or single-column area to be
searched.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149925" role="paragraph" l10n="U"
oldref="129">
-<emph>ResultVector</emph> is another single-row or single-column range from
which the result of the function is taken. The result is the cell of the result
vector with the same index as the instance found in the search
vector.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3152947" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154104" role="code"
l10n="U">LOOKUP(SearchCriterion; SearchVector; ResultVector)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150646" role="paragraph"
l10n="U"><emph>SearchCriterion</emph> is the value to be searched for; entered
either directly or as a reference.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154854" role="paragraph"
l10n="U"><emph>SearchVector</emph> is the single-row or single-column area to
be searched.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149925" role="paragraph"
l10n="U"><emph>ResultVector</emph> is another single-row or single-column range
from which the result of the function is taken. The result is the cell of the
result vector with the same index as the instance found in the search
vector.</paragraph>
<embed href="text/scalc/05/empty_cells.xhp#empty_cells"/>
-<paragraph xml-lang="en-US" id="hd_id3148624" role="heading" level="3" l10n="U"
-oldref="130">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149809" role="paragraph" l10n="U"
oldref="131">
-<item type="input">=LOOKUP(A1;D1:D100;F1:F100)</item> searches the
corresponding cell in range D1:D100 for the number you entered in A1. For the
instance found, the index is determined, for example, the 12th cell in this
range. Then, the contents of the 12th cell are returned as the value of the
function (in the result vector).</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3148624" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149809" role="paragraph" l10n="U"><item
type="input">=LOOKUP(A1;D1:D100;F1:F100)</item> searches the corresponding cell
in range D1:D100 for the number you entered in A1. For the instance found, the
index is determined, for example, the 12th cell in this range. Then, the
contents of the 12th cell are returned as the value of the function (in the
result vector).</paragraph>
</section>
<section id="Section15">
<bookmark xml-lang="en-US" branch="index" id="bm_id3149425">
<bookmark_value>STYLE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VORLAGE" id="bm_id3154342"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149425" role="heading" level="2" l10n="U"
-oldref="133">STYLE</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150826" role="paragraph" l10n="U"
oldref="134"><ahelp hid="HID_FUNC_VORLAGE">Applies a style to the cell
containing the formula.</ahelp> After a set amount of time, another style can
be applied. This function always returns the value 0, allowing you to add it to
another function without changing the value. Together with the CURRENT function
you can apply a color to a cell regardless of the value. For example:
=...+STYLE(IF(CURRENT()>3;"red";"gree [...]
-<paragraph xml-lang="en-US" id="hd_id3145373" role="heading" level="3" l10n="U"
-oldref="135">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149302" role="code" l10n="U"
oldref="136">STYLE("Style"; Time; "Style2")</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150596" role="paragraph" l10n="U"
oldref="137">
-<emph>Style</emph> is the name of a cell style assigned to the cell. Style
names must be entered in quotation marks.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3156149" role="paragraph" l10n="U"
oldref="138">
-<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 xml-lang="en-US" id="par_id3149520" role="paragraph" 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
"Default" is assumed.</paragraph>
-<paragraph xml-lang="en-US" id="par_idN111CA" role="paragraph" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#optional"/>
-</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3159254" role="heading" level="3" l10n="U"
-oldref="140">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3151374" role="paragraph" l10n="U"
oldref="141">
-<item type="input">=STYLE("Invisible";60;"Default")</item> 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>
+<paragraph xml-lang="en-US" id="hd_id3149425" role="heading" level="2"
l10n="U">STYLE</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150826" role="paragraph"
l10n="U"><ahelp hid="HID_FUNC_VORLAGE">Applies a style to the cell containing
the formula.</ahelp> After a set amount of time, another style can be applied.
This function always returns the value 0, allowing you to add it to another
function without changing the value. Together with the CURRENT function you can
apply a color to a cell regardless of the value. For example:
=...+STYLE(IF(CURRENT()>3;"red";"green")) applies [...]
+<paragraph xml-lang="en-US" id="hd_id3145373" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149302" role="code"
l10n="U">STYLE("Style"; Time; "Style2")</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150596" role="paragraph"
l10n="U"><emph>Style</emph> is the name of a cell style assigned to the cell.
Style names must be entered in quotation marks.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3156149" role="paragraph"
l10n="U"><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 xml-lang="en-US" id="par_id3149520" role="paragraph"
l10n="U"><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 "Default" is assumed.</paragraph>
+<paragraph xml-lang="en-US" id="par_idN111CA" role="paragraph"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3159254" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3151374" role="paragraph" l10n="U"><item
type="input">=STYLE("Invisible";60;"Default")</item> 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>
<paragraph xml-lang="en-US" id="par_id8056886" role="paragraph"
l10n="NEW">Since STYLE() has a numeric return value of zero, this return value
gets appended to a string. This can be avoided using T() as in the following
example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3668935" role="paragraph" l10n="NEW">
-<item type="input">="Text"&T(STYLE("myStyle"))</item>
-</paragraph>
+<paragraph xml-lang="en-US" id="par_id3668935" role="paragraph"
l10n="NEW"><item type="input">="Text"&T(STYLE("myStyle"))</item></paragraph>
<paragraph xml-lang="en-US" id="par_id3042085" role="paragraph" l10n="NEW">See
also CURRENT() for another example.</paragraph>
</section>
<section id="Section16">
@@ -490,34 +364,26 @@ oldref="140">Example</paragraph>
<bookmark_value>CHOOSE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WAHL" id="bm_id3153947"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3150430" role="heading" level="2" l10n="U"
-oldref="142">CHOOSE</paragraph>
-<paragraph xml-lang="en-US" id="par_id3143270" role="paragraph" l10n="U"
oldref="143"><ahelp hid="HID_FUNC_WAHL">Uses an index to return a value from a
list of up to 30 values.</ahelp></paragraph>
-<paragraph xml-lang="en-US" id="hd_id3153533" role="heading" level="3" l10n="U"
-oldref="144">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155425" role="code" l10n="U"
oldref="145">CHOOSE(Index; Value1; ...; Value30)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3144755" role="paragraph" l10n="U"
oldref="146">
-<emph>Index</emph> is a reference or number between 1 and 30 indicating which
value is to be taken from the list.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149939" role="paragraph" l10n="U"
oldref="147">
-<emph>Value1...Value30</emph> is the list of values entered as a reference to
a cell or as individual values.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3151253" role="heading" level="3" l10n="U"
-oldref="148">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150625" role="paragraph" l10n="U"
oldref="149">
-<item type="input">=CHOOSE(A1;B1;B2;B3;"Today";"Yesterday";"Tomorrow")</item>,
for example, returns the contents of cell B2 for A1 = 2; for A1 = 4, the
function returns the text "Today".</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3150430" role="heading" level="2"
l10n="U">CHOOSE</paragraph>
+<paragraph xml-lang="en-US" id="par_id3143270" role="paragraph"
l10n="U"><ahelp hid="HID_FUNC_WAHL">Uses an index to return a value from a list
of up to 30 values.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3153533" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155425" role="code"
l10n="U">CHOOSE(Index; Value1; ...; Value30)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3144755" role="paragraph"
l10n="U"><emph>Index</emph> is a reference or number between 1 and 30
indicating which value is to be taken from the list.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149939" role="paragraph"
l10n="U"><emph>Value1...Value30</emph> is the list of values entered as a
reference to a cell or as individual values.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3151253" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150625" role="paragraph" l10n="U"><item
type="input">=CHOOSE(A1;B1;B2;B3;"Today";"Yesterday";"Tomorrow")</item>, for
example, returns the contents of cell B2 for A1 = 2; for A1 = 4, the function
returns the text "Today".</paragraph>
</section>
<section id="Section17">
<bookmark xml-lang="en-US" branch="index" id="bm_id3151001">
<bookmark_value>HLOOKUP function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WVERWEIS" id="bm_id3149481"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3151001" role="heading" level="2" l10n="U"
-oldref="151">HLOOKUP</paragraph>
-<paragraph xml-lang="en-US" id="par_id3148688" role="paragraph" l10n="U"
oldref="152"><ahelp hid="HID_FUNC_WVERWEIS">Searches for a value and reference
to the cells below the selected area.</ahelp> This function verifies if the
first row of an array contains a certain value. The function returns then the
value in a row of the array, named in the <emph>Index</emph>, in the same
column.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3151001" role="heading" level="2"
l10n="U">HLOOKUP</paragraph>
+<paragraph xml-lang="en-US" id="par_id3148688" role="paragraph"
l10n="U"><ahelp hid="HID_FUNC_WVERWEIS">Searches for a value and reference to
the cells below the selected area.</ahelp> This function verifies if the first
row of an array contains a certain value. The function returns then the value
in a row of the array, named in the <emph>Index</emph>, in the same
column.</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
-<paragraph xml-lang="en-US" id="hd_id3154661" role="heading" level="3" l10n="U"
-oldref="153">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3146070" role="code" l10n="U"
oldref="154">HLOOKUP(SearchCriteria; Array; Index; Sorted)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3148672" role="paragraph" l10n="U"
oldref="155">See also:<link href="text/scalc/01/04060109.xhp"
name="VLOOKUP">VLOOKUP</link> (columns and rows are exchanged)</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3154661" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3146070" role="code"
l10n="U">HLOOKUP(SearchCriteria; Array; Index; Sorted)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3148672" role="paragraph" l10n="U">See
also:<link href="text/scalc/01/04060109.xhp" name="VLOOKUP">VLOOKUP</link>
(columns and rows are exchanged)</paragraph>
<embed href="text/scalc/05/empty_cells.xhp#empty_cells"/>
</section>
<section id="Section18">
@@ -525,51 +391,34 @@ oldref="153">Syntax</paragraph>
<bookmark_value>ROW function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEILE" id="bm_id3147333"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147321" role="heading" level="2" l10n="U"
-oldref="157">ROW</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154564" role="paragraph" l10n="U"
oldref="203"><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#somatrixformel" name="as an [...]
-<paragraph xml-lang="en-US" id="hd_id3158439" role="heading" level="3" l10n="U"
-oldref="159">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154916" role="code" l10n="U"
oldref="160">ROW(Reference)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3156336" role="paragraph" l10n="U"
oldref="161">
-<emph>Reference</emph> is a cell, an area, or the name of an area.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3151109" role="paragraph" l10n="U"
oldref="204">If you do not indicate a reference, the row number of the cell in
which the formula is entered will be found. <item
type="productname">%PRODUCTNAME</item> Calc automatically sets the reference to
the current cell.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3155609" role="heading" level="3" l10n="U"
-oldref="162">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154830" role="paragraph" l10n="U"
oldref="205">
-<item type="input">=ROW(B3)</item> returns 3 because the reference refers to
the third row in the table.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3147094" role="paragraph" l10n="U"
oldref="206">
-<item type="input">{=ROW(D5:D8)}</item> returns the single-column array (5, 6,
7, 8) because the reference specified contains rows 5 through 8.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153701" role="paragraph" l10n="U"
oldref="207">
-<item type="input">=ROW(D5:D8)</item> returns 5 because the ROW function is
not used as array formula and only the number of the first row of the reference
is returned.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150996" role="paragraph" l10n="U"
oldref="208">
-<item type="input">{=ROW(A1:E1)}</item> and <item
type="input">=ROW(A1:E1)</item> both return 1 because the reference only
contains row 1 as the first row in the table. (Because single-row areas only
have one row number it does not make any difference whether or not the formula
is used as an array formula.)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153671" role="paragraph" l10n="U"
oldref="209">
-<item type="input">=ROW()</item> returns 3 if the formula was entered in row
3.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3153790" role="paragraph" l10n="U"
oldref="210">
-<item type="input">{=ROW(Rabbit)}</item> returns the single-column array (1,
2, 3) if "Rabbit" is the named area (C1:D3).</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3147321" role="heading" level="2"
l10n="U">ROW</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154564" role="paragraph"
l10n="U"><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#somatrixformel" name="as an array formul [...]
+<paragraph xml-lang="en-US" id="hd_id3158439" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154916" role="code"
l10n="U">ROW(Reference)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3156336" role="paragraph"
l10n="U"><emph>Reference</emph> is a cell, an area, or the name of an
area.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3151109" role="paragraph" l10n="U">If
you do not indicate a reference, the row number of the cell in which the
formula is entered will be found. <item type="productname">%PRODUCTNAME</item>
Calc automatically sets the reference to the current cell.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3155609" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154830" role="paragraph" l10n="U"><item
type="input">=ROW(B3)</item> returns 3 because the reference refers to the
third row in the table.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3147094" role="paragraph" l10n="U"><item
type="input">{=ROW(D5:D8)}</item> returns the single-column array (5, 6, 7, 8)
because the reference specified contains rows 5 through 8.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153701" role="paragraph" l10n="U"><item
type="input">=ROW(D5:D8)</item> returns 5 because the ROW function is not used
as array formula and only the number of the first row of the reference is
returned.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150996" role="paragraph" l10n="U"><item
type="input">{=ROW(A1:E1)}</item> and <item type="input">=ROW(A1:E1)</item>
both return 1 because the reference only contains row 1 as the first row in the
table. (Because single-row areas only have one row number it does not make any
difference whether or not the formula is used as an array formula.)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153671" role="paragraph" l10n="U"><item
type="input">=ROW()</item> returns 3 if the formula was entered in row
3.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3153790" role="paragraph" l10n="U"><item
type="input">{=ROW(Rabbit)}</item> returns the single-column array (1, 2, 3) if
"Rabbit" is the named area (C1:D3).</paragraph>
</section>
<section id="Section19">
<bookmark xml-lang="en-US" branch="index" id="bm_id3145772">
<bookmark_value>ROWS function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEILEN" id="bm_id3150667"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145772" role="heading" level="2" l10n="U"
-oldref="166">ROWS</paragraph>
-<paragraph xml-lang="en-US" id="par_id3148971" role="paragraph" l10n="U"
oldref="167"><ahelp hid="HID_FUNC_ZEILEN">Returns the number of rows in a
reference or array.</ahelp></paragraph>
-<paragraph xml-lang="en-US" id="hd_id3156051" role="heading" level="3" l10n="U"
-oldref="168">Syntax</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154357" role="code" l10n="U"
oldref="169">ROWS(Array)</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155942" role="paragraph" l10n="U"
oldref="170">
-<emph>Array</emph> is the reference or named area whose total number of rows
is to be determined.</paragraph>
-<paragraph xml-lang="en-US" id="hd_id3155869" role="heading" level="3" l10n="U"
-oldref="171">Example</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154725" role="paragraph" l10n="U"
oldref="212">
-<item type="input">=Rows(B5)</item> returns 1 because a cell only contains one
row.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150102" role="paragraph" l10n="U"
oldref="172">
-<item type="input">=ROWS(A10:B12)</item> returns 3.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3155143" role="paragraph" l10n="U"
oldref="213">
-<item type="input">=ROWS(Rabbit)</item> returns 3 if "Rabbit" is the named
area (C1:D3).</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3145772" role="heading" level="2"
l10n="U">ROWS</paragraph>
+<paragraph xml-lang="en-US" id="par_id3148971" role="paragraph"
l10n="U"><ahelp hid="HID_FUNC_ZEILEN">Returns the number of rows in a reference
or array.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3156051" role="heading" level="3"
l10n="U">Syntax</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154357" role="code"
l10n="U">ROWS(Array)</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155942" role="paragraph"
l10n="U"><emph>Array</emph> is the reference or named area whose total number
of rows is to be determined.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3155869" role="heading" level="3"
l10n="U">Example</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154725" role="paragraph" l10n="U"><item
type="input">=Rows(B5)</item> returns 1 because a cell only contains one
row.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150102" role="paragraph" l10n="U"><item
type="input">=ROWS(A10:B12)</item> returns 3.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3155143" role="paragraph" l10n="U"><item
type="input">=ROWS(Rabbit)</item> returns 3 if "Rabbit" is the named area
(C1:D3).</paragraph>
</section>
<section id="Section20">
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HYPERLINK"
id="bm_id8036439" localize="false"/>
diff --git a/main/helpcontent2/source/text/shared/01/ref_pdf_export.xhp
b/main/helpcontent2/source/text/shared/01/ref_pdf_export.xhp
index a9ea3cb17a..f740604798 100644
--- a/main/helpcontent2/source/text/shared/01/ref_pdf_export.xhp
+++ b/main/helpcontent2/source/text/shared/01/ref_pdf_export.xhp
@@ -38,34 +38,32 @@
<bookmark xml-lang="en-US" branch="hid/.uno:ExportToPDF" id="bm_id2491692"
localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:ExportToPDF" id="bm_id3146856"
localize="false"/>
<!-- removed HID FILTER_EDIT_RID_PDF_EXPORT_DLG_ED_PAGES -->
-<paragraph xml-lang="en-US" id="hd_id3149532" role="heading" level="1" l10n="U"
-oldref="52"><variable id="export_as_pdf"><variable id="ref_pdf_export"><link
href="text/shared/01/ref_pdf_export.xhp" name="Export as PDF">Export as
PDF</link>
+<paragraph xml-lang="en-US" id="hd_id3149532" role="heading" level="1"
l10n="U"><variable id="export_as_pdf"><variable id="ref_pdf_export"><link
href="text/shared/01/ref_pdf_export.xhp" name="Export as PDF">Export as
PDF</link>
</variable>
</variable></paragraph>
-<paragraph xml-lang="en-US" id="par_id3154044" role="paragraph" l10n="CHG"
oldref="1"><variable id="export"><ahelp
hid="FILTER_EDIT_RID_PDF_EXPORT_DLG_ED_PAGES">Saves the current file to
Portable Document Format (PDF) version 1.4.</ahelp> A PDF file can be viewed
and printed on any platform with the original formatting intact, provided that
supporting software is installed.
+<paragraph xml-lang="en-US" id="par_id3154044" role="paragraph"
l10n="CHG"><variable id="export"><ahelp
hid="FILTER_EDIT_RID_PDF_EXPORT_DLG_ED_PAGES">Saves the current file to
Portable Document Format (PDF) version 1.4.</ahelp> A PDF file can be viewed
and printed on any platform with the original formatting intact, provided that
supporting software is installed.
</variable></paragraph>
</section>
<section id="howtoget">
<embed href="text/shared/00/00000401.xhp#exportpdf"/>
</section>
<paragraph xml-lang="en-US" id="hd_id746482" role="heading" level="2"
l10n="NEW">General<comment>UFI: all on one page because they were intended to
shrink to AHID tags with OOo3 anyway. Sadly cws help9s stalled
...</comment></paragraph>
-<paragraph xml-lang="en-US" id="hd_id3148520" role="heading" level="2"
l10n="CHG"
-oldref="2">Range</paragraph>
-<paragraph xml-lang="en-US" id="par_id3154230" role="paragraph" l10n="CHG"
oldref="3">Sets the export options for the pages included in the PDF
file.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3148520" role="heading" level="2"
l10n="CHG">Range</paragraph>
+<paragraph xml-lang="en-US" id="par_id3154230" role="paragraph"
l10n="CHG">Sets the export options for the pages included in the PDF
file.</paragraph>
<!-- removed HID filter_RadioButton_RID_PDF_EXPORT_DLG_RB_ALL -->
<bookmark xml-lang="en-US"
branch="hid/filter:RadioButton:RID_PDF_TAB_GENER:RB_ALL" id="bm_id1033967"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3166445" role="heading" level="2"
l10n="U" oldref="4">All</paragraph>
-<paragraph xml-lang="en-US" id="par_id3149893" role="paragraph" l10n="U"
oldref="5"><ahelp hid="FILTER_RADIOBUTTON_RID_PDF_EXPORT_DLG_RB_ALL">Exports
all defined print ranges. If no print range is defined, exports the entire
document.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3166445" role="heading" level="2"
l10n="U">All</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149893" role="paragraph"
l10n="U"><ahelp hid="FILTER_RADIOBUTTON_RID_PDF_EXPORT_DLG_RB_ALL">Exports all
defined print ranges. If no print range is defined, exports the entire
document.</ahelp></paragraph>
<!-- removed HID filter_RadioButton_RID_PDF_EXPORT_DLG_RB_RANGE -->
<bookmark xml-lang="en-US"
branch="hid/filter:RadioButton:RID_PDF_TAB_GENER:RB_RANGE" id="bm_id2618793"
localize="false"/>
<bookmark xml-lang="en-US" branch="hid/filter:Edit:RID_PDF_TAB_GENER:ED_PAGES"
id="bm_id2676778" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154673" role="heading" level="2"
l10n="CHG" oldref="6">Pages</paragraph>
-<paragraph xml-lang="en-US" id="par_id3147571" role="paragraph" l10n="U"
oldref="7"><ahelp hid="FILTER_EDIT_RID_PDF_EXPORT_DLG_ED_PAGES">Exports the
pages you type in the box.</ahelp></paragraph>
-<paragraph xml-lang="en-US" id="par_id3145136" role="paragraph" l10n="U"
oldref="53">To export a range of pages, use the format 3-6. To export single
pages, use the format 7;9;11. If you want, you can export a combination of page
ranges and single pages, by using a format like 3-6;8;10;12.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3154673" role="heading" level="2"
l10n="CHG">Pages</paragraph>
+<paragraph xml-lang="en-US" id="par_id3147571" role="paragraph"
l10n="U"><ahelp hid="FILTER_EDIT_RID_PDF_EXPORT_DLG_ED_PAGES">Exports the pages
you type in the box.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="par_id3145136" role="paragraph" l10n="U">To
export a range of pages, use the format 3-6. To export single pages, use the
format 7;9;11. If you want, you can export a combination of page ranges and
single pages, by using a format like 3-6;8;10;12.</paragraph>
<!-- removed HID filter_RadioButton_RID_PDF_EXPORT_DLG_RB_SELECTION -->
<bookmark xml-lang="en-US"
branch="hid/filter:RadioButton:RID_PDF_TAB_GENER:RB_SELECTION"
id="bm_id8889126" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147043" role="heading" level="2"
l10n="U" oldref="8">Selection</paragraph>
-<paragraph xml-lang="en-US" id="par_id3150774" role="paragraph" l10n="U"
oldref="9"><ahelp
hid="FILTER_RADIOBUTTON_RID_PDF_EXPORT_DLG_RB_SELECTION">Exports the current
selection.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3147043" role="heading" level="2"
l10n="U">Selection</paragraph>
+<paragraph xml-lang="en-US" id="par_id3150774" role="paragraph"
l10n="U"><ahelp
hid="FILTER_RADIOBUTTON_RID_PDF_EXPORT_DLG_RB_SELECTION">Exports the current
selection.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_idN10706" role="heading" level="2"
l10n="NEW">Images</paragraph>
<paragraph xml-lang="en-US" id="par_idN1070A" role="paragraph" l10n="NEW">Sets
the PDF export options for images inside your document.</paragraph>
<paragraph xml-lang="en-US" id="par_idN1071B" role="note" l10n="NEW">EPS
images with embedded previews are exported only as previews. EPS images without
embedded previews are exported as empty placeholders.</paragraph>
@@ -271,8 +269,7 @@ oldref="2">Range</paragraph>
<bookmark xml-lang="en-US"
branch="hid/filter:CheckBox:RID_PDF_TAB_SECURITY:CB_ENAB_ACCESS"
id="bm_id3429059" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id9312417" role="heading" level="2"
l10n="NEW">Enable text access for accessibility tools</paragraph>
<paragraph xml-lang="en-US" id="par_id9089022" role="paragraph"
l10n="NEW"><ahelp hid=".">Select to enable text access for accessibility
tools.</ahelp></paragraph>
-<paragraph xml-lang="en-US" id="hd_id3150507" role="heading" level="2" l10n="U"
-oldref="50">Export</paragraph>
-<paragraph xml-lang="en-US" id="par_id3146975" role="paragraph" l10n="U"
oldref="51"><ahelp hid=".">Exports the current file in PDF
format.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="hd_id3150507" role="heading" level="2"
l10n="U">Export</paragraph>
+<paragraph xml-lang="en-US" id="par_id3146975" role="paragraph"
l10n="U"><ahelp hid=".">Exports the current file in PDF
format.</ahelp></paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/shared/02/01170100.xhp
b/main/helpcontent2/source/text/shared/02/01170100.xhp
index 02d16ce78b..0dfe00d968 100644
--- a/main/helpcontent2/source/text/shared/02/01170100.xhp
+++ b/main/helpcontent2/source/text/shared/02/01170100.xhp
@@ -37,76 +37,76 @@
<bookmark xml-lang="en-US" branch="hid/.uno:ControlProperties"
id="bm_id9308186" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:ControlProperties"
id="bm_id3150616" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_FM_PROPDLG_TABCTR"
id="bm_id9469283" localize="false"/>
-<paragraph role="heading" id="hd_id3147102" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/shared/02/01170100.xhp" name="Control
Properties">Control Properties</link></paragraph>
-<paragraph role="paragraph" id="par_id3145345" xml-lang="en-US" l10n="U"
oldref="2"><variable id="kontroll"><ahelp hid=".uno:ControlProperties">Opens a
dialog for editing the properties of a selected control.</ahelp>
+<paragraph role="heading" id="hd_id3147102" xml-lang="en-US" level="1"
l10n="U"><link href="text/shared/02/01170100.xhp" name="Control
Properties">Control Properties</link></paragraph>
+<paragraph role="paragraph" id="par_id3145345" xml-lang="en-US"
l10n="U"><variable id="kontroll"><ahelp hid=".uno:ControlProperties">Opens a
dialog for editing the properties of a selected control.</ahelp>
</variable></paragraph>
</section>
<section id="howtoget">
<embed href="text/shared/00/00040501.xhp#controleigenschaften"/>
</section>
-<paragraph role="note" id="par_id3157910" xml-lang="en-US" l10n="U"
oldref="17"><variable id="hinweis">You can only call the
<emph>Properties</emph> dialog when in the Design mode with a control selected.
+<paragraph role="note" id="par_id3157910" xml-lang="en-US" l10n="U"><variable
id="hinweis">You can only call the <emph>Properties</emph> dialog when in the
Design mode with a control selected.
</variable></paragraph>
<section id="spezialfelder">
-<paragraph role="paragraph" id="par_id3153760" xml-lang="en-US" l10n="U"
oldref="3">If you enter data in the <emph>Properties</emph> dialog, note that
multiline input is possible for certain drop-down combo boxes. This concerns
all fields in which an SQL statement can be entered, as well as the properties
of text boxes or label fields. You can open these fields and enter text in the
opened list. The following shortcut keys are valid:</paragraph>
+<paragraph role="paragraph" id="par_id3153760" xml-lang="en-US" l10n="U">If
you enter data in the <emph>Properties</emph> dialog, note that multiline input
is possible for certain drop-down combo boxes. This concerns all fields in
which an SQL statement can be entered, as well as the properties of text boxes
or label fields. You can open these fields and enter text in the opened list.
The following shortcut keys are valid:</paragraph>
<table id="tbl_id3145315">
<tablerow>
<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id3148686" xml-lang="en-US" l10n="U"
oldref="18">Keys</paragraph>
+<paragraph role="tablehead" id="par_id3148686" xml-lang="en-US"
l10n="U">Keys</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
-<paragraph role="tablehead" id="par_id3155390" xml-lang="en-US" l10n="U"
oldref="19">Effects</paragraph>
+<paragraph role="tablehead" id="par_id3155390" xml-lang="en-US"
l10n="U">Effects</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3150504" xml-lang="en-US" l10n="U"
oldref="4"><switchinline select="sys"><caseinline
select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Down
Arrow</paragraph>
+<paragraph role="tablecontent" id="par_id3150504" xml-lang="en-US"
l10n="U"><switchinline select="sys"><caseinline
select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Down
Arrow</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3150944" xml-lang="en-US" l10n="U"
oldref="5">Opens the combo box</paragraph>
+<paragraph role="tablecontent" id="par_id3150944" xml-lang="en-US"
l10n="U">Opens the combo box</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3153627" xml-lang="en-US" l10n="U"
oldref="6"><switchinline select="sys"><caseinline
select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Up
Arrow</paragraph>
+<paragraph role="tablecontent" id="par_id3153627" xml-lang="en-US"
l10n="U"><switchinline select="sys"><caseinline
select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Up
Arrow</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3153063" xml-lang="en-US" l10n="U"
oldref="7">Closes the combo box</paragraph>
+<paragraph role="tablecontent" id="par_id3153063" xml-lang="en-US"
l10n="U">Closes the combo box</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3159413" xml-lang="en-US" l10n="U"
oldref="8">Shift+Enter</paragraph>
+<paragraph role="tablecontent" id="par_id3159413" xml-lang="en-US"
l10n="U">Shift+Enter</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3152811" xml-lang="en-US" l10n="U"
oldref="9">Inserts a new line.</paragraph>
+<paragraph role="tablecontent" id="par_id3152811" xml-lang="en-US"
l10n="U">Inserts a new line.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3153379" xml-lang="en-US" l10n="U"
oldref="10">Up Arrow</paragraph>
+<paragraph role="tablecontent" id="par_id3153379" xml-lang="en-US" l10n="U">Up
Arrow</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3153192" xml-lang="en-US" l10n="U"
oldref="11">Places the cursor into the previous line.</paragraph>
+<paragraph role="tablecontent" id="par_id3153192" xml-lang="en-US"
l10n="U">Places the cursor into the previous line.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3152933" xml-lang="en-US" l10n="U"
oldref="12">Down Arrow</paragraph>
+<paragraph role="tablecontent" id="par_id3152933" xml-lang="en-US"
l10n="U">Down Arrow</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3151041" xml-lang="en-US" l10n="U"
oldref="13">Places the cursor into the next line.</paragraph>
+<paragraph role="tablecontent" id="par_id3151041" xml-lang="en-US"
l10n="U">Places the cursor into the next line.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3153178" xml-lang="en-US" l10n="U"
oldref="14">Enter</paragraph>
+<paragraph role="tablecontent" id="par_id3153178" xml-lang="en-US"
l10n="U">Enter</paragraph>
</tablecell>
<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_id3147228" xml-lang="en-US" l10n="U"
oldref="15">Completes the input in the field and places the cursor into the
next field.</paragraph>
+<paragraph role="tablecontent" id="par_id3147228" xml-lang="en-US"
l10n="U">Completes the input in the field and places the cursor into the next
field.</paragraph>
</tablecell>
</tablerow>
</table>
-<paragraph role="paragraph" id="par_id3156422" xml-lang="en-US" l10n="U"
oldref="16">As with list boxes or combo boxes, you can open or close the list
with a mouse click at the arrow on the right end of the field. However, the
input here can be entered either in the opened list or in the top text field.
An exception is the properties that expect a list representation, for example,
the property <emph>List Entries</emph>, which can be set for the control fields
<emph>List Box</emph> and <e [...]
+<paragraph role="paragraph" id="par_id3156422" xml-lang="en-US" l10n="U">As
with list boxes or combo boxes, you can open or close the list with a mouse
click at the arrow on the right end of the field. However, the input here can
be entered either in the opened list or in the top text field. An exception is
the properties that expect a list representation, for example, the property
<emph>List Entries</emph>, which can be set for the control fields <emph>List
Box</emph> and <emph>Combo Bo [...]
</section>
<embed href="text/shared/02/01170101.xhp#allgemein"/>
<embed href="text/shared/02/01170102.xhp#daten"/>
diff --git a/main/helpcontent2/source/text/shared/autopi/01110600.xhp
b/main/helpcontent2/source/text/shared/autopi/01110600.xhp
index e34ea66aea..69cb04732d 100644
--- a/main/helpcontent2/source/text/shared/autopi/01110600.xhp
+++ b/main/helpcontent2/source/text/shared/autopi/01110600.xhp
@@ -31,38 +31,38 @@
<body>
<section id="seite6">
<bookmark xml-lang="en-US" branch="hid/SD_HID_SD_HTMLEXPORT_PAGE6"
id="bm_id7226177" localize="false"/><comment>inserted this dialog id, see
i72163</comment>
-<paragraph role="heading" id="hd_id3154926" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/shared/autopi/01110600.xhp" name="HTML
Export - Page 6">HTML Export - Page 6</link></paragraph>
-<paragraph role="paragraph" id="par_id3155934" xml-lang="en-US" l10n="U"
oldref="2">Defines the colors for the publication.</paragraph>
+<paragraph role="heading" id="hd_id3154926" xml-lang="en-US" level="1"
l10n="U"><link href="text/shared/autopi/01110600.xhp" name="HTML Export - Page
6">HTML Export - Page 6</link></paragraph>
+<paragraph role="paragraph" id="par_id3155934" xml-lang="en-US"
l10n="U">Defines the colors for the publication.</paragraph>
</section>
-<paragraph role="paragraph" id="par_id3150247" xml-lang="en-US" l10n="U"
oldref="28">Text formatting is obtained from the drawing or presentation. This
page is skipped if you unmark the <emph>Create title page</emph> check box or
if you select automatic or WebCast export.</paragraph>
+<paragraph role="paragraph" id="par_id3150247" xml-lang="en-US" l10n="U">Text
formatting is obtained from the drawing or presentation. This page is skipped
if you unmark the <emph>Create title page</emph> check box or if you select
automatic or WebCast export.</paragraph>
<section id="howtoget">
<embed href="text/shared/00/00000401.xhp#htmlspeichern6"/>
</section>
-<paragraph role="heading" id="hd_id3152924" xml-lang="en-US" level="2"
l10n="U" oldref="21">Select color scheme</paragraph>
-<paragraph role="paragraph" id="par_id3153049" xml-lang="en-US" l10n="U"
oldref="22">Determines the color scheme and the colors for text and
background.</paragraph>
+<paragraph role="heading" id="hd_id3152924" xml-lang="en-US" level="2"
l10n="U">Select color scheme</paragraph>
+<paragraph role="paragraph" id="par_id3153049" xml-lang="en-US"
l10n="U">Determines the color scheme and the colors for text and
background.</paragraph>
<bookmark xml-lang="en-US"
branch="hid/sd:RadioButton:DLG_PUBLISHING:PAGE6_DOCCOLORS" id="bm_id3145090"
localize="false"/>
-<paragraph role="heading" id="hd_id3147291" xml-lang="en-US" level="3"
l10n="U" oldref="23">Apply color scheme from document</paragraph>
-<paragraph role="paragraph" id="par_id3153748" xml-lang="en-US" l10n="U"
oldref="24"><ahelp
hid="SD:RADIOBUTTON:DLG_PUBLISHING:PAGE6_DOCCOLORS">Determines the colors from
the styles used in the current document.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3147291" xml-lang="en-US" level="3"
l10n="U">Apply color scheme from document</paragraph>
+<paragraph role="paragraph" id="par_id3153748" xml-lang="en-US"
l10n="U"><ahelp hid="SD:RADIOBUTTON:DLG_PUBLISHING:PAGE6_DOCCOLORS">Determines
the colors from the styles used in the current document.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/sd:RadioButton:DLG_PUBLISHING:PAGE6_DEFAULT" id="bm_id3146958"
localize="false"/>
-<paragraph role="heading" id="hd_id3149095" xml-lang="en-US" level="3"
l10n="U" oldref="25">Use browser colors</paragraph>
-<paragraph role="paragraph" id="par_id3155338" xml-lang="en-US" l10n="U"
oldref="26"><ahelp hid="SD:RADIOBUTTON:DLG_PUBLISHING:PAGE6_DEFAULT">Uses the
default colors of the viewer's Web Browser.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3149095" xml-lang="en-US" level="3"
l10n="U">Use browser colors</paragraph>
+<paragraph role="paragraph" id="par_id3155338" xml-lang="en-US"
l10n="U"><ahelp hid="SD:RADIOBUTTON:DLG_PUBLISHING:PAGE6_DEFAULT">Uses the
default colors of the viewer's Web Browser.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/sd:RadioButton:DLG_PUBLISHING:PAGE6_USER" id="bm_id3152997"
localize="false"/>
-<paragraph role="heading" id="hd_id3149388" xml-lang="en-US" level="3"
l10n="U" oldref="27">Use custom color scheme</paragraph>
-<paragraph role="paragraph" id="par_id3149399" xml-lang="en-US" l10n="U"
oldref="6"><ahelp hid="SD:RADIOBUTTON:DLG_PUBLISHING:PAGE6_USER">Allows you to
define your own colors for some presentation objects.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3149388" xml-lang="en-US" level="3"
l10n="U">Use custom color scheme</paragraph>
+<paragraph role="paragraph" id="par_id3149399" xml-lang="en-US"
l10n="U"><ahelp hid="SD:RADIOBUTTON:DLG_PUBLISHING:PAGE6_USER">Allows you to
define your own colors for some presentation objects.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/sd:PushButton:DLG_PUBLISHING:PAGE6_TEXT" id="bm_id3145382"
localize="false"/>
-<paragraph role="heading" id="hd_id3166410" xml-lang="en-US" level="3"
l10n="U" oldref="8">Text</paragraph>
-<paragraph role="paragraph" id="par_id3149762" xml-lang="en-US" l10n="U"
oldref="9"><ahelp hid="SD:PUSHBUTTON:DLG_PUBLISHING:PAGE6_TEXT">Opens the <link
href="text/shared/optionen/01010501.xhp" name="Color"><emph>Color</emph></link>
dialog, where you can select the text color of the
presentation.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3166410" xml-lang="en-US" level="3"
l10n="U">Text</paragraph>
+<paragraph role="paragraph" id="par_id3149762" xml-lang="en-US"
l10n="U"><ahelp hid="SD:PUSHBUTTON:DLG_PUBLISHING:PAGE6_TEXT">Opens the <link
href="text/shared/optionen/01010501.xhp" name="Color"><emph>Color</emph></link>
dialog, where you can select the text color of the
presentation.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/sd:PushButton:DLG_PUBLISHING:PAGE6_LINK" id="bm_id3155389"
localize="false"/>
-<paragraph role="heading" id="hd_id3156192" xml-lang="en-US" level="3"
l10n="U" oldref="10">Hyperlink</paragraph>
-<paragraph role="paragraph" id="par_id3143270" xml-lang="en-US" l10n="U"
oldref="11"><ahelp hid="SD:PUSHBUTTON:DLG_PUBLISHING:PAGE6_LINK">Opens the
<link href="text/shared/optionen/01010501.xhp"
name="Color"><emph>Color</emph></link> dialog, where you can select the
hyperlink color of the presentation.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3156192" xml-lang="en-US" level="3"
l10n="U">Hyperlink</paragraph>
+<paragraph role="paragraph" id="par_id3143270" xml-lang="en-US"
l10n="U"><ahelp hid="SD:PUSHBUTTON:DLG_PUBLISHING:PAGE6_LINK">Opens the <link
href="text/shared/optionen/01010501.xhp" name="Color"><emph>Color</emph></link>
dialog, where you can select the hyperlink color of the
presentation.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/sd:PushButton:DLG_PUBLISHING:PAGE6_ALINK" id="bm_id3153825"
localize="false"/>
-<paragraph role="heading" id="hd_id3149234" xml-lang="en-US" level="3"
l10n="U" oldref="14">Active Link</paragraph>
-<paragraph role="paragraph" id="par_id3156152" xml-lang="en-US" l10n="U"
oldref="15"><ahelp hid="SD:PUSHBUTTON:DLG_PUBLISHING:PAGE6_ALINK">Opens the
<link href="text/shared/optionen/01010501.xhp"
name="Color"><emph>Color</emph></link> dialog, where you can select the active
link color of the presentation.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3149234" xml-lang="en-US" level="3"
l10n="U">Active Link</paragraph>
+<paragraph role="paragraph" id="par_id3156152" xml-lang="en-US"
l10n="U"><ahelp hid="SD:PUSHBUTTON:DLG_PUBLISHING:PAGE6_ALINK">Opens the <link
href="text/shared/optionen/01010501.xhp" name="Color"><emph>Color</emph></link>
dialog, where you can select the active link color of the
presentation.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/sd:PushButton:DLG_PUBLISHING:PAGE6_VLINK" id="bm_id3153822"
localize="false"/>
-<paragraph role="heading" id="hd_id3148474" xml-lang="en-US" level="3"
l10n="U" oldref="12">Visited Link</paragraph>
-<paragraph role="paragraph" id="par_id3150670" xml-lang="en-US" l10n="U"
oldref="13"><ahelp hid="SD:PUSHBUTTON:DLG_PUBLISHING:PAGE6_VLINK">Opens the
<link href="text/shared/optionen/01010501.xhp"
name="Color"><emph>Color</emph></link> dialog, where you can select the visited
link color of the presentation.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3148474" xml-lang="en-US" level="3"
l10n="U">Visited Link</paragraph>
+<paragraph role="paragraph" id="par_id3150670" xml-lang="en-US"
l10n="U"><ahelp hid="SD:PUSHBUTTON:DLG_PUBLISHING:PAGE6_VLINK">Opens the <link
href="text/shared/optionen/01010501.xhp" name="Color"><emph>Color</emph></link>
dialog, where you can select the visited link color of the
presentation.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/sd:PushButton:DLG_PUBLISHING:PAGE6_BACK" id="bm_id3152360"
localize="false"/>
-<paragraph role="heading" id="hd_id3156024" xml-lang="en-US" level="3"
l10n="U" oldref="7">Background</paragraph>
-<paragraph role="paragraph" id="par_id3159413" xml-lang="en-US" l10n="U"
oldref="20"><ahelp hid="SD:PUSHBUTTON:DLG_PUBLISHING:PAGE6_BACK">Opens the
<link href="text/shared/optionen/01010501.xhp"
name="Color"><emph>Color</emph></link> dialog, where you can select the
background color of the presentation.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3156024" xml-lang="en-US" level="3"
l10n="U">Background</paragraph>
+<paragraph role="paragraph" id="par_id3159413" xml-lang="en-US"
l10n="U"><ahelp hid="SD:PUSHBUTTON:DLG_PUBLISHING:PAGE6_BACK">Opens the <link
href="text/shared/optionen/01010501.xhp" name="Color"><emph>Color</emph></link>
dialog, where you can select the background color of the
presentation.</ahelp></paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/simpress/guide/table_insert.xhp
b/main/helpcontent2/source/text/simpress/guide/table_insert.xhp
index aed2718d4e..29f7dc5a4a 100644
--- a/main/helpcontent2/source/text/simpress/guide/table_insert.xhp
+++ b/main/helpcontent2/source/text/simpress/guide/table_insert.xhp
@@ -34,7 +34,7 @@
<bookmark_value>presentations;inserting spreadsheets</bookmark_value>
<bookmark_value>including spreadsheets</bookmark_value>
</bookmark>
-<paragraph role="heading" id="hd_id3154022" xml-lang="en-US" level="1"
l10n="U" oldref="1"><variable id="table_insert"><link
href="text/simpress/guide/table_insert.xhp" name="Including Spreadsheets in
Slides">Including Spreadsheets in Slides</link>
+<paragraph role="heading" id="hd_id3154022" xml-lang="en-US" level="1"
l10n="U"><variable id="table_insert"><link
href="text/simpress/guide/table_insert.xhp" name="Including Spreadsheets in
Slides">Including Spreadsheets in Slides</link>
</variable></paragraph>
<paragraph role="paragraph" id="par_id4231086" xml-lang="en-US" l10n="NEW">You
can apply different methods to insert spreadsheet cells into your Impress
slides or Draw pages:</paragraph>
<list type="ordered">
@@ -109,40 +109,40 @@
<paragraph role="paragraph" id="par_id0916200803551880" xml-lang="en-US"
l10n="NEW">To select one cell, point to that cell, hold down the mouse button,
and drag the mouse to the next cell and back, then release the mouse
button.</paragraph>
</listitem>
</list>
-<paragraph role="heading" id="hd_id3151075" xml-lang="en-US" level="2"
l10n="CHG" oldref="2">Inserting a new spreadsheet as an OLE object</paragraph>
-<paragraph role="paragraph" id="par_id3150715" xml-lang="en-US" l10n="U"
oldref="7">You can add a blank $[officename] Calc spreadsheet to a slide as an
OLE object.</paragraph>
+<paragraph role="heading" id="hd_id3151075" xml-lang="en-US" level="2"
l10n="CHG">Inserting a new spreadsheet as an OLE object</paragraph>
+<paragraph role="paragraph" id="par_id3150715" xml-lang="en-US" l10n="U">You
can add a blank $[officename] Calc spreadsheet to a slide as an OLE
object.</paragraph>
<list type="ordered">
<listitem>
-<paragraph role="listitem" id="par_id3150749" xml-lang="en-US" l10n="U"
oldref="3">Go to the slide where you want to insert the spreadsheet.</paragraph>
+<paragraph role="listitem" id="par_id3150749" xml-lang="en-US" l10n="U">Go to
the slide where you want to insert the spreadsheet.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3146313" xml-lang="en-US" l10n="U"
oldref="18">Choose <emph>Insert - OLE- Object</emph>. Click <emph>Create
new</emph> and select the %PRODUCTNAME Spreadsheet. Click OK. Click in the
spreadsheet to enter your data.</paragraph>
+<paragraph role="listitem" id="par_id3146313" xml-lang="en-US" l10n="U">Choose
<emph>Insert - OLE- Object</emph>. Click <emph>Create new</emph> and select the
%PRODUCTNAME Spreadsheet. Click OK. Click in the spreadsheet to enter your
data.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id2466505" xml-lang="en-US"
l10n="NEW">Click outside the spreadsheet to view the slide.</paragraph>
</listitem>
</list>
-<paragraph role="paragraph" id="par_id3148870" xml-lang="en-US" l10n="U"
oldref="9">To resize the spreadsheet without resizing the cells, double-click
the spreadsheet, and then drag a corner handle. To resize the cells of the
spreadsheet, click the spreadsheet, and then drag a corner handle.</paragraph>
-<paragraph role="heading" id="hd_id3150215" xml-lang="en-US" level="2"
l10n="CHG" oldref="11">Inserting a spreadsheet from a file</paragraph>
-<paragraph role="paragraph" id="par_id3154765" xml-lang="en-US" l10n="U"
oldref="19">When you insert an existing spreadsheet into your slide, changes
that are made to the original spreadsheet file are not updated on your slide.
You can, however, make changes to the spreadsheet in your slide.</paragraph>
+<paragraph role="paragraph" id="par_id3148870" xml-lang="en-US" l10n="U">To
resize the spreadsheet without resizing the cells, double-click the
spreadsheet, and then drag a corner handle. To resize the cells of the
spreadsheet, click the spreadsheet, and then drag a corner handle.</paragraph>
+<paragraph role="heading" id="hd_id3150215" xml-lang="en-US" level="2"
l10n="CHG">Inserting a spreadsheet from a file</paragraph>
+<paragraph role="paragraph" id="par_id3154765" xml-lang="en-US" l10n="U">When
you insert an existing spreadsheet into your slide, changes that are made to
the original spreadsheet file are not updated on your slide. You can, however,
make changes to the spreadsheet in your slide.</paragraph>
<list type="ordered">
<listitem>
-<paragraph role="listitem" id="par_id3145112" xml-lang="en-US" l10n="U"
oldref="12">Go to the slide where you want to insert the
spreadsheet.</paragraph>
+<paragraph role="listitem" id="par_id3145112" xml-lang="en-US" l10n="U">Go to
the slide where you want to insert the spreadsheet.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3153075" xml-lang="en-US" l10n="U"
oldref="13">Choose <emph>Insert - Object - OLE Object</emph>.</paragraph>
+<paragraph role="listitem" id="par_id3153075" xml-lang="en-US" l10n="U">Choose
<emph>Insert - Object - OLE Object</emph>.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3150391" xml-lang="en-US" l10n="CHG"
oldref="14">Select <emph>Create from file</emph>, and click
<emph>Search</emph>.</paragraph>
+<paragraph role="listitem" id="par_id3150391" xml-lang="en-US"
l10n="CHG">Select <emph>Create from file</emph>, and click
<emph>Search</emph>.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3150537" xml-lang="en-US" l10n="U"
oldref="20">Locate the file you want to insert, and then click
<emph>OK</emph>.</paragraph>
+<paragraph role="listitem" id="par_id3150537" xml-lang="en-US" l10n="U">Locate
the file you want to insert, and then click <emph>OK</emph>.</paragraph>
<paragraph role="listitem" id="par_id1616565" xml-lang="en-US"
l10n="NEW">Enable the <emph>Link to file</emph> checkbox to insert the file as
a live link.</paragraph>
</listitem>
</list>
-<paragraph role="note" id="par_id3155256" xml-lang="en-US" l10n="U"
oldref="21">The entire spreadsheet is inserted into your slide. If you want to
change the sheet that is displayed, double-click the spreadsheet, and then
select a different sheet.</paragraph>
+<paragraph role="note" id="par_id3155256" xml-lang="en-US" l10n="U">The entire
spreadsheet is inserted into your slide. If you want to change the sheet that
is displayed, double-click the spreadsheet, and then select a different
sheet.</paragraph>
<embed href="text/shared/00/00000004.xhp#related"/>
-<paragraph role="paragraph" id="par_id3154505" xml-lang="en-US" l10n="CHG"
oldref="15"><link href="text/simpress/01/05130000.xhp" name="Format - Slide
Layout">Format - Slide Layout</link></paragraph>
-<paragraph role="paragraph" id="par_id3150335" xml-lang="en-US" l10n="U"
oldref="16"><link href="text/shared/01/04150100.xhp" name="Insert - Object -
OLE Object">Insert - Object - OLE Object</link></paragraph>
+<paragraph role="paragraph" id="par_id3154505" xml-lang="en-US"
l10n="CHG"><link href="text/simpress/01/05130000.xhp" name="Format - Slide
Layout">Format - Slide Layout</link></paragraph>
+<paragraph role="paragraph" id="par_id3150335" xml-lang="en-US" l10n="U"><link
href="text/shared/01/04150100.xhp" name="Insert - Object - OLE Object">Insert -
Object - OLE Object</link></paragraph>
</body>
</helpdocument>
