This is an automated email from the ASF dual-hosted git repository.
mseidel pushed a commit to branch AOO42X
in repository https://gitbox.apache.org/repos/asf/openoffice.git
The following commit(s) were added to refs/heads/AOO42X by this push:
new c824eed776 Remove 'oldref' entries (work in progress)
c824eed776 is described below
commit c824eed7763f20a63d6f0d3cf68800363a886b15
Author: mseidel <msei...@apache.org>
AuthorDate: Fri Mar 14 18:54:19 2025 +0100
Remove 'oldref' entries (work in progress)
(cherry picked from commit 0d3b37bc2a4a8d709655eb97f63431f665fc53fb)
---
.../source/text/sbasic/shared/03050500.xhp | 72 +-
.../source/text/sbasic/shared/03090301.xhp | 72 +-
.../helpcontent2/source/text/scalc/01/04060107.xhp | 836 ++++++++-------------
.../source/text/shared/01/01160000.xhp | 12 +-
.../source/text/shared/autopi/01130200.xhp | 42 +-
5 files changed, 402 insertions(+), 632 deletions(-)
diff --git a/main/helpcontent2/source/text/sbasic/shared/03050500.xhp
b/main/helpcontent2/source/text/sbasic/shared/03050500.xhp
index 1b18912648..a1b5f72210 100644
--- a/main/helpcontent2/source/text/sbasic/shared/03050500.xhp
+++ b/main/helpcontent2/source/text/sbasic/shared/03050500.xhp
@@ -34,42 +34,42 @@
<bookmark_value>Resume Next parameter</bookmark_value>
<bookmark_value>On Error GoTo ... Resume statement</bookmark_value>
</bookmark>
-<paragraph role="heading" id="hd_id3146795" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/sbasic/shared/03050500.xhp" name="On Error
GoTo ... Resume Statement [Runtime]">On Error GoTo ... Resume Statement
[Runtime]</link></paragraph>
-<paragraph role="paragraph" id="par_id3150358" xml-lang="en-US" l10n="U"
oldref="2">Enables an error-handling routine after an error occurs, or resumes
program execution.</paragraph>
+<paragraph role="heading" id="hd_id3146795" xml-lang="en-US" level="1"
l10n="U"><link href="text/sbasic/shared/03050500.xhp" name="On Error GoTo ...
Resume Statement [Runtime]">On Error GoTo ... Resume Statement
[Runtime]</link></paragraph>
+<paragraph role="paragraph" id="par_id3150358" xml-lang="en-US"
l10n="U">Enables an error-handling routine after an error occurs, or resumes
program execution.</paragraph>
</section>
-<paragraph role="heading" id="hd_id3151212" xml-lang="en-US" level="2"
l10n="U" oldref="3">Syntax:</paragraph>
-<paragraph role="paragraph" id="par_id3145173" xml-lang="en-US" l10n="U"
oldref="4">On {[Local] Error GoTo Labelname | GoTo 0 | Resume Next}</paragraph>
-<paragraph role="heading" id="hd_id3154125" xml-lang="en-US" level="2"
l10n="U" oldref="5">Parameters:</paragraph>
-<paragraph role="paragraph" id="par_id3150869" xml-lang="en-US" l10n="U"
oldref="7"><emph>GoTo Labelname:</emph> If an error occurs, enables the
error-handling routine that starts at the line "Labelname".</paragraph>
-<paragraph role="paragraph" id="par_id3150439" xml-lang="en-US" l10n="U"
oldref="8"><emph>Resume Next:</emph> If an error occurs, program execution
continues with the statement that follows the statement in which the error
occurred.</paragraph>
-<paragraph role="paragraph" id="par_id3149482" xml-lang="en-US" l10n="U"
oldref="9"><emph>GoTo 0:</emph> Disables the error handler in the current
procedure.</paragraph>
-<paragraph role="paragraph" id="par_id3149483" xml-lang="en-US" l10n="U"
oldref="9"><emph>Local:</emph> "On error" is global in scope, and remains
active until canceled by another "On error" statement. "On Local error" is
local to the routine which invokes it. Local error handling overrides any
previous global setting. When the invoking routine exits, the local error
handling is canceled automatically, and any previous global setting is
restored.</paragraph>
-<paragraph role="paragraph" id="par_id3148619" xml-lang="en-US" l10n="CGH"
oldref="10">The On Error GoTo statement is used to react to errors that occur
in a macro.<comment>ufi: see i112231: The statement must be inserted at the
start of a procedure (in a local error-handling routine) or at the start of a
module.</comment></paragraph>
-<paragraph role="heading" id="hd_id3146985" xml-lang="en-US" level="2"
l10n="U" oldref="11">Example:</paragraph>
-<paragraph role="paragraph" id="par_id3152460" xml-lang="en-US" l10n="U"
oldref="42">Sub ExampleReset</paragraph>
-<paragraph role="paragraph" id="par_id3163712" xml-lang="en-US" l10n="U"
oldref="43">On Error Goto ErrorHandler</paragraph>
-<paragraph role="paragraph" id="par_id3146119" xml-lang="en-US" l10n="U"
oldref="44">Dim iNumber As Integer</paragraph>
-<paragraph role="paragraph" id="par_id3145749" xml-lang="en-US" l10n="U"
oldref="45">Dim iCount As Integer</paragraph>
-<paragraph role="paragraph" id="par_id3153091" xml-lang="en-US" l10n="U"
oldref="46">Dim sLine As String</paragraph>
-<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US" l10n="U"
oldref="47">Dim aFile As String</paragraph>
-<paragraph role="paragraph" id="par_id3147348" xml-lang="en-US" l10n="U"
oldref="48">aFile = "c:\data.txt"</paragraph>
-<paragraph role="paragraph" id="par_id3154944" xml-lang="en-US" l10n="U"
oldref="50">iNumber = Freefile</paragraph>
-<paragraph role="paragraph" id="par_id3153158" xml-lang="en-US" l10n="U"
oldref="51">Open aFile For Output As #iNumber</paragraph>
-<paragraph role="paragraph" id="par_id3153876" xml-lang="en-US" l10n="U"
oldref="52">Print #iNumber, "This is a line of text"</paragraph>
-<paragraph role="paragraph" id="par_id3149581" xml-lang="en-US" l10n="U"
oldref="53">Close #iNumber</paragraph>
-<paragraph role="paragraph" id="par_id3155602" xml-lang="en-US" l10n="U"
oldref="55">iNumber = Freefile</paragraph>
-<paragraph role="paragraph" id="par_id3153415" xml-lang="en-US" l10n="U"
oldref="56">Open aFile For Input As iNumber</paragraph>
-<paragraph role="paragraph" id="par_id3146970" xml-lang="en-US" l10n="U"
oldref="57">For iCount = 1 to 5</paragraph>
-<paragraph role="paragraph" id="par_id3153707" xml-lang="en-US" l10n="U"
oldref="58">Line Input #iNumber, sLine</paragraph>
-<paragraph role="paragraph" id="par_id3156276" xml-lang="en-US" l10n="U"
oldref="59">If sLine <>"" then</paragraph>
-<paragraph role="paragraph" id="par_id3148993" xml-lang="en-US" l10n="U"
oldref="60">rem</paragraph>
-<paragraph role="paragraph" id="par_id3153764" xml-lang="en-US" l10n="U"
oldref="61">end if</paragraph>
-<paragraph role="paragraph" id="par_id3154754" xml-lang="en-US" l10n="U"
oldref="62">Next iCount</paragraph>
-<paragraph role="paragraph" id="par_id3159264" xml-lang="en-US" l10n="U"
oldref="63">Close #iNumber</paragraph>
-<paragraph role="paragraph" id="par_id3150042" xml-lang="en-US" l10n="U"
oldref="64">Exit Sub</paragraph>
-<paragraph role="paragraph" id="par_id3151251" xml-lang="en-US" l10n="U"
oldref="65">ErrorHandler:</paragraph>
-<paragraph role="paragraph" id="par_id3149106" xml-lang="en-US" l10n="U"
oldref="66">Reset</paragraph>
-<paragraph role="paragraph" id="par_id3146916" xml-lang="en-US" l10n="U"
oldref="67">MsgBox "All files will be closed",0,"Error"</paragraph>
-<paragraph role="paragraph" id="par_id3149568" xml-lang="en-US" l10n="U"
oldref="68">End Sub</paragraph>
+<paragraph role="heading" id="hd_id3151212" xml-lang="en-US" level="2"
l10n="U">Syntax:</paragraph>
+<paragraph role="paragraph" id="par_id3145173" xml-lang="en-US" l10n="U">On
{[Local] Error GoTo Labelname | GoTo 0 | Resume Next}</paragraph>
+<paragraph role="heading" id="hd_id3154125" xml-lang="en-US" level="2"
l10n="U">Parameters:</paragraph>
+<paragraph role="paragraph" id="par_id3150869" xml-lang="en-US"
l10n="U"><emph>GoTo Labelname:</emph> If an error occurs, enables the
error-handling routine that starts at the line "Labelname".</paragraph>
+<paragraph role="paragraph" id="par_id3150439" xml-lang="en-US"
l10n="U"><emph>Resume Next:</emph> If an error occurs, program execution
continues with the statement that follows the statement in which the error
occurred.</paragraph>
+<paragraph role="paragraph" id="par_id3149482" xml-lang="en-US"
l10n="U"><emph>GoTo 0:</emph> Disables the error handler in the current
procedure.</paragraph>
+<paragraph role="paragraph" id="par_id3149483" xml-lang="en-US"
l10n="U"><emph>Local:</emph> "On error" is global in scope, and remains active
until canceled by another "On error" statement. "On Local error" is local to
the routine which invokes it. Local error handling overrides any previous
global setting. When the invoking routine exits, the local error handling is
canceled automatically, and any previous global setting is restored.</paragraph>
+<paragraph role="paragraph" id="par_id3148619" xml-lang="en-US" l10n="CGH">The
On Error GoTo statement is used to react to errors that occur in a
macro.<comment>ufi: see i112231: The statement must be inserted at the start of
a procedure (in a local error-handling routine) or at the start of a
module.</comment></paragraph>
+<paragraph role="heading" id="hd_id3146985" xml-lang="en-US" level="2"
l10n="U">Example:</paragraph>
+<paragraph role="paragraph" id="par_id3152460" xml-lang="en-US" l10n="U">Sub
ExampleReset</paragraph>
+<paragraph role="paragraph" id="par_id3163712" xml-lang="en-US" l10n="U">On
Error Goto ErrorHandler</paragraph>
+<paragraph role="paragraph" id="par_id3146119" xml-lang="en-US" l10n="U">Dim
iNumber As Integer</paragraph>
+<paragraph role="paragraph" id="par_id3145749" xml-lang="en-US" l10n="U">Dim
iCount As Integer</paragraph>
+<paragraph role="paragraph" id="par_id3153091" xml-lang="en-US" l10n="U">Dim
sLine As String</paragraph>
+<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US" l10n="U">Dim
aFile As String</paragraph>
+<paragraph role="paragraph" id="par_id3147348" xml-lang="en-US" l10n="U">aFile
= "c:\data.txt"</paragraph>
+<paragraph role="paragraph" id="par_id3154944" xml-lang="en-US"
l10n="U">iNumber = Freefile</paragraph>
+<paragraph role="paragraph" id="par_id3153158" xml-lang="en-US" l10n="U">Open
aFile For Output As #iNumber</paragraph>
+<paragraph role="paragraph" id="par_id3153876" xml-lang="en-US" l10n="U">Print
#iNumber, "This is a line of text"</paragraph>
+<paragraph role="paragraph" id="par_id3149581" xml-lang="en-US" l10n="U">Close
#iNumber</paragraph>
+<paragraph role="paragraph" id="par_id3155602" xml-lang="en-US"
l10n="U">iNumber = Freefile</paragraph>
+<paragraph role="paragraph" id="par_id3153415" xml-lang="en-US" l10n="U">Open
aFile For Input As iNumber</paragraph>
+<paragraph role="paragraph" id="par_id3146970" xml-lang="en-US" l10n="U">For
iCount = 1 to 5</paragraph>
+<paragraph role="paragraph" id="par_id3153707" xml-lang="en-US" l10n="U">Line
Input #iNumber, sLine</paragraph>
+<paragraph role="paragraph" id="par_id3156276" xml-lang="en-US" l10n="U">If
sLine <>"" then</paragraph>
+<paragraph role="paragraph" id="par_id3148993" xml-lang="en-US"
l10n="U">rem</paragraph>
+<paragraph role="paragraph" id="par_id3153764" xml-lang="en-US" l10n="U">end
if</paragraph>
+<paragraph role="paragraph" id="par_id3154754" xml-lang="en-US" l10n="U">Next
iCount</paragraph>
+<paragraph role="paragraph" id="par_id3159264" xml-lang="en-US" l10n="U">Close
#iNumber</paragraph>
+<paragraph role="paragraph" id="par_id3150042" xml-lang="en-US" l10n="U">Exit
Sub</paragraph>
+<paragraph role="paragraph" id="par_id3151251" xml-lang="en-US"
l10n="U">ErrorHandler:</paragraph>
+<paragraph role="paragraph" id="par_id3149106" xml-lang="en-US"
l10n="U">Reset</paragraph>
+<paragraph role="paragraph" id="par_id3146916" xml-lang="en-US"
l10n="U">MsgBox "All files will be closed",0,"Error"</paragraph>
+<paragraph role="paragraph" id="par_id3149568" xml-lang="en-US" l10n="U">End
Sub</paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/sbasic/shared/03090301.xhp
b/main/helpcontent2/source/text/sbasic/shared/03090301.xhp
index 5d4cb7503a..080408f5b4 100644
--- a/main/helpcontent2/source/text/sbasic/shared/03090301.xhp
+++ b/main/helpcontent2/source/text/sbasic/shared/03090301.xhp
@@ -33,42 +33,42 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3147242">
<bookmark_value>GoSub...Return statement</bookmark_value>
</bookmark>
-<paragraph role="heading" id="hd_id3147242" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/sbasic/shared/03090301.xhp"
name="GoSub...Return Statement [Runtime]">GoSub...Return Statement
[Runtime]</link></paragraph>
-<paragraph role="paragraph" id="par_id3145316" xml-lang="en-US" l10n="U"
oldref="2">Calls a subroutine that is indicated by a label from a subroutine or
a function. The statements following the label are executed until the next
Return statement. Afterwards, the program continues with the statement that
follows the <emph>GoSub</emph> statement.</paragraph>
+<paragraph role="heading" id="hd_id3147242" xml-lang="en-US" level="1"
l10n="U"><link href="text/sbasic/shared/03090301.xhp" name="GoSub...Return
Statement [Runtime]">GoSub...Return Statement [Runtime]</link></paragraph>
+<paragraph role="paragraph" id="par_id3145316" xml-lang="en-US" l10n="U">Calls
a subroutine that is indicated by a label from a subroutine or a function. The
statements following the label are executed until the next Return statement.
Afterwards, the program continues with the statement that follows the
<emph>GoSub</emph> statement.</paragraph>
</section>
-<paragraph role="heading" id="hd_id3145609" xml-lang="en-US" level="2"
l10n="U" oldref="3">Syntax:</paragraph>
-<paragraph role="paragraph" id="par_id3145069" xml-lang="en-US" l10n="U"
oldref="4">see Parameters</paragraph>
-<paragraph role="heading" id="hd_id3147265" xml-lang="en-US" level="2"
l10n="U" oldref="5">Parameters:</paragraph>
-<paragraph role="paragraph" id="par_id3148664" xml-lang="en-US" l10n="U"
oldref="6">Sub/Function</paragraph>
-<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US" l10n="U"
oldref="7">statement block</paragraph>
-<paragraph role="paragraph" id="par_id3154140" xml-lang="en-US" l10n="U"
oldref="8"> Label</paragraph>
-<paragraph role="paragraph" id="par_id3150869" xml-lang="en-US" l10n="U"
oldref="9">statement block</paragraph>
-<paragraph role="paragraph" id="par_id3154909" xml-lang="en-US" l10n="U"
oldref="10">GoSub Label</paragraph>
-<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="U"
oldref="11">Exit Sub/Function</paragraph>
-<paragraph role="paragraph" id="par_id3154685" xml-lang="en-US" l10n="U"
oldref="12">Label:</paragraph>
-<paragraph role="paragraph" id="par_id3145786" xml-lang="en-US" l10n="U"
oldref="13">statement block</paragraph>
-<paragraph role="paragraph" id="par_id3159252" xml-lang="en-US" l10n="U"
oldref="14">Return</paragraph>
-<paragraph role="paragraph" id="par_id3154321" xml-lang="en-US" l10n="U"
oldref="15">End Sub/Function</paragraph>
-<paragraph role="paragraph" id="par_id3147318" xml-lang="en-US" l10n="U"
oldref="16">The <emph>GoSub</emph> statement calls a local subroutine indicated
by a label from within a subroutine or a function. The name of the label must
end with a colon (":").</paragraph>
-<paragraph role="warning" id="par_id3153190" xml-lang="en-US" l10n="U"
oldref="17">If the program encounters a Return statement not preceded by
<emph>GoSub</emph>, $[officename] Basic returns an error message. Use
<emph>Exit Sub</emph> or <emph>Exit Function</emph> to ensure that the program
leaves a Sub or Function before reaching the next Return statement.</paragraph>
-<paragraph role="paragraph" id="par_id3145799" xml-lang="en-US" l10n="U"
oldref="19">The following example demonstrates the use of <emph>GoSub</emph>
and <emph>Return</emph>. By executing a program section twice, the program
calculates the square root of two numbers that are entered by the
user.</paragraph>
-<paragraph role="heading" id="hd_id3156284" xml-lang="en-US" level="2"
l10n="U" oldref="20">Example:</paragraph>
-<paragraph role="paragraph" id="par_id3151073" xml-lang="en-US" l10n="U"
oldref="21">Sub ExampleGoSub</paragraph>
-<paragraph role="paragraph" id="par_id3154097" xml-lang="en-US" l10n="U"
oldref="22">dim iInputa as Single</paragraph>
-<paragraph role="paragraph" id="par_id3150715" xml-lang="en-US" l10n="U"
oldref="23">dim iInputb as Single</paragraph>
-<paragraph role="paragraph" id="par_id3153416" xml-lang="en-US" l10n="U"
oldref="24">dim iInputc as Single</paragraph>
-<paragraph role="paragraph" id="par_id3146970" xml-lang="en-US" l10n="U"
oldref="25">iInputa = Int(InputBox$ ("Enter the first number:
","NumberInput"))</paragraph>
-<paragraph role="paragraph" id="par_id3150329" xml-lang="en-US" l10n="U"
oldref="26">iInputb = Int(InputBox$ ("Enter the second number:
","NumberInput"))</paragraph>
-<paragraph role="paragraph" id="par_id3156277" xml-lang="en-US" l10n="U"
oldref="27">iInputc=iInputa</paragraph>
-<paragraph role="paragraph" id="par_id3150321" xml-lang="en-US" l10n="U"
oldref="28">GoSub SquareRoot</paragraph>
-<paragraph role="paragraph" id="par_id3154756" xml-lang="en-US" l10n="U"
oldref="29">Print "The square root of";iInputa;" is";iInputc</paragraph>
-<paragraph role="paragraph" id="par_id3155764" xml-lang="en-US" l10n="U"
oldref="30">iInputc=iInputb</paragraph>
-<paragraph role="paragraph" id="par_id3152960" xml-lang="en-US" l10n="U"
oldref="31">GoSub SquareRoot</paragraph>
-<paragraph role="paragraph" id="par_id3147340" xml-lang="en-US" l10n="U"
oldref="32">Print "The square root of";iInputb;" is";iInputc</paragraph>
-<paragraph role="paragraph" id="par_id3166450" xml-lang="en-US" l10n="U"
oldref="33">Exit Sub</paragraph>
-<paragraph role="paragraph" id="par_id3155176" xml-lang="en-US" l10n="U"
oldref="34">SquareRoot:</paragraph>
-<paragraph role="paragraph" id="par_id3149257" xml-lang="en-US" l10n="U"
oldref="35">iInputc=sqr(iInputc)</paragraph>
-<paragraph role="paragraph" id="par_id3146316" xml-lang="en-US" l10n="U"
oldref="36">Return</paragraph>
-<paragraph role="paragraph" id="par_id3154703" xml-lang="en-US" l10n="U"
oldref="37">End Sub</paragraph>
+<paragraph role="heading" id="hd_id3145609" xml-lang="en-US" level="2"
l10n="U">Syntax:</paragraph>
+<paragraph role="paragraph" id="par_id3145069" xml-lang="en-US" l10n="U">see
Parameters</paragraph>
+<paragraph role="heading" id="hd_id3147265" xml-lang="en-US" level="2"
l10n="U">Parameters:</paragraph>
+<paragraph role="paragraph" id="par_id3148664" xml-lang="en-US"
l10n="U">Sub/Function</paragraph>
+<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US"
l10n="U">statement block</paragraph>
+<paragraph role="paragraph" id="par_id3154140" xml-lang="en-US"
l10n="U">Label:</paragraph>
+<paragraph role="paragraph" id="par_id3150869" xml-lang="en-US"
l10n="U">statement block</paragraph>
+<paragraph role="paragraph" id="par_id3154909" xml-lang="en-US" l10n="U">GoSub
Label</paragraph>
+<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="U">Exit
Sub/Function</paragraph>
+<paragraph role="paragraph" id="par_id3154685" xml-lang="en-US"
l10n="U">Label:</paragraph>
+<paragraph role="paragraph" id="par_id3145786" xml-lang="en-US"
l10n="U">statement block</paragraph>
+<paragraph role="paragraph" id="par_id3159252" xml-lang="en-US"
l10n="U">Return</paragraph>
+<paragraph role="paragraph" id="par_id3154321" xml-lang="en-US" l10n="U">End
Sub/Function</paragraph>
+<paragraph role="paragraph" id="par_id3147318" xml-lang="en-US" l10n="U">The
<emph>GoSub</emph> statement calls a local subroutine indicated by a label from
within a subroutine or a function. The name of the label must end with a colon
(":").</paragraph>
+<paragraph role="warning" id="par_id3153190" xml-lang="en-US" l10n="U">If the
program encounters a Return statement not preceded by <emph>GoSub</emph>,
$[officename] Basic returns an error message. Use <emph>Exit Sub</emph> or
<emph>Exit Function</emph> to ensure that the program leaves a Sub or Function
before reaching the next Return statement.</paragraph>
+<paragraph role="paragraph" id="par_id3145799" xml-lang="en-US" l10n="U">The
following example demonstrates the use of <emph>GoSub</emph> and
<emph>Return</emph>. By executing a program section twice, the program
calculates the square root of two numbers that are entered by the
user.</paragraph>
+<paragraph role="heading" id="hd_id3156284" xml-lang="en-US" level="2"
l10n="U">Example:</paragraph>
+<paragraph role="paragraph" id="par_id3151073" xml-lang="en-US" l10n="U">Sub
ExampleGoSub</paragraph>
+<paragraph role="paragraph" id="par_id3154097" xml-lang="en-US" l10n="U">dim
iInputa as Single</paragraph>
+<paragraph role="paragraph" id="par_id3150715" xml-lang="en-US" l10n="U">dim
iInputb as Single</paragraph>
+<paragraph role="paragraph" id="par_id3153416" xml-lang="en-US" l10n="U">dim
iInputc as Single</paragraph>
+<paragraph role="paragraph" id="par_id3146970" xml-lang="en-US"
l10n="U">iInputa = Int(InputBox$ ("Enter the first number:
","NumberInput"))</paragraph>
+<paragraph role="paragraph" id="par_id3150329" xml-lang="en-US"
l10n="U">iInputb = Int(InputBox$ ("Enter the second number:
","NumberInput"))</paragraph>
+<paragraph role="paragraph" id="par_id3156277" xml-lang="en-US"
l10n="U">iInputc=iInputa</paragraph>
+<paragraph role="paragraph" id="par_id3150321" xml-lang="en-US" l10n="U">GoSub
SquareRoot</paragraph>
+<paragraph role="paragraph" id="par_id3154756" xml-lang="en-US" l10n="U">Print
"The square root of";iInputa;" is";iInputc</paragraph>
+<paragraph role="paragraph" id="par_id3155764" xml-lang="en-US"
l10n="U">iInputc=iInputb</paragraph>
+<paragraph role="paragraph" id="par_id3152960" xml-lang="en-US" l10n="U">GoSub
SquareRoot</paragraph>
+<paragraph role="paragraph" id="par_id3147340" xml-lang="en-US" l10n="U">Print
"The square root of";iInputb;" is";iInputc</paragraph>
+<paragraph role="paragraph" id="par_id3166450" xml-lang="en-US" l10n="U">Exit
Sub</paragraph>
+<paragraph role="paragraph" id="par_id3155176" xml-lang="en-US"
l10n="U">SquareRoot:</paragraph>
+<paragraph role="paragraph" id="par_id3149257" xml-lang="en-US"
l10n="U">iInputc=sqr(iInputc)</paragraph>
+<paragraph role="paragraph" id="par_id3146316" xml-lang="en-US"
l10n="U">Return</paragraph>
+<paragraph role="paragraph" id="par_id3154703" xml-lang="en-US" l10n="U">End
Sub</paragraph>
</body>
</helpdocument>
diff --git a/main/helpcontent2/source/text/scalc/01/04060107.xhp
b/main/helpcontent2/source/text/scalc/01/04060107.xhp
index e8afed3087..b4d8b40f16 100644
--- a/main/helpcontent2/source/text/scalc/01/04060107.xhp
+++ b/main/helpcontent2/source/text/scalc/01/04060107.xhp
@@ -45,106 +45,88 @@
<bookmark_value>implicit array handling</bookmark_value>
<bookmark_value>forced array handling</bookmark_value>
</bookmark><comment>mw deleted "creating;"</comment>
-<paragraph role="heading" id="hd_id3147273" xml-lang="en-US" level="1"
l10n="U" oldref="1">Array Functions</paragraph>
-<paragraph role="paragraph" id="par_id3154744" xml-lang="en-US" l10n="U"
oldref="2"><variable id="matrixtext">This category contains the array functions.
+<paragraph role="heading" id="hd_id3147273" xml-lang="en-US" level="1"
l10n="U">Array Functions</paragraph>
+<paragraph role="paragraph" id="par_id3154744" xml-lang="en-US"
l10n="U"><variable id="matrixtext">This category contains the array functions.
</variable></paragraph>
-<paragraph role="heading" id="hd_id3146084" xml-lang="en-US" level="2"
l10n="U" oldref="257">What is an Array?</paragraph>
-<paragraph role="paragraph" id="par_id3154298" xml-lang="en-US" l10n="U"
oldref="258"><variable id="wasmatrix">An array is a linked range of cells on a
spreadsheet containing values.
+<paragraph role="heading" id="hd_id3146084" xml-lang="en-US" level="2"
l10n="U">What is an Array?</paragraph>
+<paragraph role="paragraph" id="par_id3154298" xml-lang="en-US"
l10n="U"><variable id="wasmatrix">An array is a linked range of cells on a
spreadsheet containing values.
</variable> A square range of 3 rows and 3 columns is a 3 x 3
array:</paragraph>
<table id="tbl_id3151168">
<tablerow>
<tablecell>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3154692" xml-lang="en-US" l10n="U"
oldref="260">A</paragraph>
+<paragraph role="paragraph" id="par_id3154692" xml-lang="en-US"
l10n="U">A</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3150117" xml-lang="en-US" l10n="U"
oldref="261">B</paragraph>
+<paragraph role="paragraph" id="par_id3150117" xml-lang="en-US"
l10n="U">B</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3155325" xml-lang="en-US" l10n="U"
oldref="262">C</paragraph>
+<paragraph role="paragraph" id="par_id3155325" xml-lang="en-US"
l10n="U">C</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3153104" xml-lang="en-US" l10n="U"
oldref="263">1</paragraph>
+<paragraph role="paragraph" id="par_id3153104" xml-lang="en-US"
l10n="U">1</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3146996" xml-lang="en-US" l10n="U"
oldref="264">
-<item type="input">7</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3146996" xml-lang="en-US" l10n="U"><item
type="input">7</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3150529" xml-lang="en-US" l10n="U"
oldref="265">
-<item type="input">31</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3150529" xml-lang="en-US" l10n="U"><item
type="input">31</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3148831" xml-lang="en-US" l10n="U"
oldref="266">
-<item type="input">33</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3148831" xml-lang="en-US" l10n="U"><item
type="input">33</item></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3148943" xml-lang="en-US" l10n="U"
oldref="267">2</paragraph>
+<paragraph role="paragraph" id="par_id3148943" xml-lang="en-US"
l10n="U">2</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3149771" xml-lang="en-US" l10n="U"
oldref="268">
-<item type="input">95</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3149771" xml-lang="en-US" l10n="U"><item
type="input">95</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3158407" xml-lang="en-US" l10n="U"
oldref="269">
-<item type="input">17</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3158407" xml-lang="en-US" l10n="U"><item
type="input">17</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3148806" xml-lang="en-US" l10n="U"
oldref="270">
-<item type="input">2</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3148806" xml-lang="en-US" l10n="U"><item
type="input">2</item></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3154904" xml-lang="en-US" l10n="U"
oldref="271">3</paragraph>
+<paragraph role="paragraph" id="par_id3154904" xml-lang="en-US"
l10n="U">3</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3150779" xml-lang="en-US" l10n="U"
oldref="272">
-<item type="input">5</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3150779" xml-lang="en-US" l10n="U"><item
type="input">5</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3148449" xml-lang="en-US" l10n="U"
oldref="273">
-<item type="input">10</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3148449" xml-lang="en-US" l10n="U"><item
type="input">10</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3147238" xml-lang="en-US" l10n="U"
oldref="274">
-<item type="input">50</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3147238" xml-lang="en-US" l10n="U"><item
type="input">50</item></paragraph>
</tablecell>
</tablerow>
</table>
-<paragraph role="paragraph" id="par_id3153583" xml-lang="en-US" l10n="U"
oldref="277">The smallest possible array is a 1 x 2 or 2 x 1 array with two
adjacent cells.</paragraph>
-<paragraph role="heading" id="hd_id3148474" xml-lang="en-US" level="2"
l10n="U" oldref="275">What is an array formula?</paragraph>
-<paragraph role="paragraph" id="par_id3155355" xml-lang="en-US" l10n="U"
oldref="276">A formula in which the individual values in a cell range are
evaluated is referred to as an array formula. The difference between an array
formula and other formulas is that the array formula deals with several values
simultaneously instead of just one.</paragraph>
-<paragraph role="paragraph" id="par_id3151052" xml-lang="en-US" l10n="U"
oldref="278">Not only can an array formula process several values, but it can
also return several values. The results of an array formula is also an
array.</paragraph>
-<paragraph role="paragraph" id="par_id3158432" xml-lang="en-US" l10n="U"
oldref="279">To multiply the values in the individual cells by 10 in the above
array, you do not need to apply a formula to each individual cell or value.
Instead you just need to use a single array formula. Select a range of 3 x 3
cells on another part of the spreadsheet, enter the formula <item
type="input">=10*A1:C3</item> and confirm this entry using the key combination
<switchinline select="sys"><caseinline sel [...]
-<paragraph role="paragraph" id="par_id3149156" xml-lang="en-US" l10n="U"
oldref="280">In addition to multiplication, you can also use other operators on
the reference range (an array). With $[officename] Calc, you can add (+),
subtract (-), multiply (*), divide (/), use exponents (^), concatenation
(&) and comparisons (=, <>, <, >, <=, >=). The operators
can be used on each individual value in the cell range and return the result as
an array if the array formula was [...]
-<paragraph role="paragraph" id="par_id3166456" xml-lang="en-US" l10n="CHG"
oldref="326">Comparison operators in an array formula treat empty cells in the
same way as in a normal formula, that is, either as zero or as an empty string.
For example, if cells A1 and A2 are empty the array formulas <item
type="input">{=A1:A2=""}</item> and <item type="input">{=A1:A2=0}</item> will
both return a 1 column 2 row array of cells containing TRUE.</paragraph>
-<paragraph role="heading" id="hd_id3150713" xml-lang="en-US" level="3"
l10n="U" oldref="281">When do you use array formulas?</paragraph>
-<paragraph role="paragraph" id="par_id3149787" xml-lang="en-US" l10n="U"
oldref="282">Use array formulas if you have to repeat calculations using
different values. If you decide to change the calculation method later, you
only have to update the array formula. To add an array formula, select the
entire array range and then <link href="text/scalc/01/04060107.xhp" name="make
the required change to the array formula">make the required change to the array
formula</link>.</paragraph>
-<paragraph role="paragraph" id="par_id3149798" xml-lang="en-US" l10n="U"
oldref="283">Array formulas are also a space saving option when several values
must be calculated, since they are not very memory-intensive. In addition,
arrays are an essential tool for carrying out complex calculations, because you
can have several cell ranges included in your calculations. $[officename] has
different math functions for arrays, such as the MMULT function for multiplying
two arrays or the SUMPRODUC [...]
-<paragraph role="heading" id="hd_id3155588" xml-lang="en-US" level="2"
l10n="U" oldref="284">Using Array Formulas in $[officename] Calc</paragraph>
-<paragraph role="paragraph" id="par_id3152876" xml-lang="en-US" l10n="U"
oldref="285">You can also create a "normal" formula in which the reference
range, such as parameters, indicate an array formula. The result is obtained
from the intersection of the reference range and the rows or columns in which
the formula is found. If there is no intersection or if the range at the
intersection covers several rows or columns, a #VALUE! error message appears.
The following example illustrates this [...]
-<paragraph role="heading" id="hd_id3151271" xml-lang="en-US" level="3"
l10n="U" oldref="313">Creating Array Formulas</paragraph>
+<paragraph role="paragraph" id="par_id3153583" xml-lang="en-US" l10n="U">The
smallest possible array is a 1 x 2 or 2 x 1 array with two adjacent
cells.</paragraph>
+<paragraph role="heading" id="hd_id3148474" xml-lang="en-US" level="2"
l10n="U">What is an array formula?</paragraph>
+<paragraph role="paragraph" id="par_id3155355" xml-lang="en-US" l10n="U">A
formula in which the individual values in a cell range are evaluated is
referred to as an array formula. The difference between an array formula and
other formulas is that the array formula deals with several values
simultaneously instead of just one.</paragraph>
+<paragraph role="paragraph" id="par_id3151052" xml-lang="en-US" l10n="U">Not
only can an array formula process several values, but it can also return
several values. The results of an array formula is also an array.</paragraph>
+<paragraph role="paragraph" id="par_id3158432" xml-lang="en-US" l10n="U">To
multiply the values in the individual cells by 10 in the above array, you do
not need to apply a formula to each individual cell or value. Instead you just
need to use a single array formula. Select a range of 3 x 3 cells on another
part of the spreadsheet, enter the formula <item type="input">=10*A1:C3</item>
and confirm this entry using the key combination <switchinline
select="sys"><caseinline select="MAC">Com [...]
+<paragraph role="paragraph" id="par_id3149156" xml-lang="en-US" l10n="U">In
addition to multiplication, you can also use other operators on the reference
range (an array). With $[officename] Calc, you can add (+), subtract (-),
multiply (*), divide (/), use exponents (^), concatenation (&) and
comparisons (=, <>, <, >, <=, >=). The operators can be used
on each individual value in the cell range and return the result as an array if
the array formula was entered.</pa [...]
+<paragraph role="paragraph" id="par_id3166456" xml-lang="en-US"
l10n="CHG">Comparison operators in an array formula treat empty cells in the
same way as in a normal formula, that is, either as zero or as an empty string.
For example, if cells A1 and A2 are empty the array formulas <item
type="input">{=A1:A2=""}</item> and <item type="input">{=A1:A2=0}</item> will
both return a 1 column 2 row array of cells containing TRUE.</paragraph>
+<paragraph role="heading" id="hd_id3150713" xml-lang="en-US" level="3"
l10n="U">When do you use array formulas?</paragraph>
+<paragraph role="paragraph" id="par_id3149787" xml-lang="en-US" l10n="U">Use
array formulas if you have to repeat calculations using different values. If
you decide to change the calculation method later, you only have to update the
array formula. To add an array formula, select the entire array range and then
<link href="text/scalc/01/04060107.xhp" name="make the required change to the
array formula">make the required change to the array formula</link>.</paragraph>
+<paragraph role="paragraph" id="par_id3149798" xml-lang="en-US" l10n="U">Array
formulas are also a space saving option when several values must be calculated,
since they are not very memory-intensive. In addition, arrays are an essential
tool for carrying out complex calculations, because you can have several cell
ranges included in your calculations. $[officename] has different math
functions for arrays, such as the MMULT function for multiplying two arrays or
the SUMPRODUCT function fo [...]
+<paragraph role="heading" id="hd_id3155588" xml-lang="en-US" level="2"
l10n="U">Using Array Formulas in $[officename] Calc</paragraph>
+<paragraph role="paragraph" id="par_id3152876" xml-lang="en-US" l10n="U">You
can also create a "normal" formula in which the reference range, such as
parameters, indicate an array formula. The result is obtained from the
intersection of the reference range and the rows or columns in which the
formula is found. If there is no intersection or if the range at the
intersection covers several rows or columns, a #VALUE! error message appears.
The following example illustrates this concept:</pa [...]
+<paragraph role="heading" id="hd_id3151271" xml-lang="en-US" level="3"
l10n="U">Creating Array Formulas</paragraph>
<section id="somatrixformel">
-<paragraph role="paragraph" id="par_id3149102" xml-lang="en-US" l10n="U"
oldref="314">If you create an array formula using the <emph>Function
Wizard</emph>, you must mark the <emph>Array</emph> check box each time so that
the results are returned in an array. Otherwise, only the value in the
upper-left cell of the array being calculated is returned.</paragraph>
-<paragraph role="paragraph" id="par_id3153392" xml-lang="en-US" l10n="U"
oldref="4">If you enter the array formula directly into the cell, you must use
the key combination Shift+<switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter
instead of the Enter key. Only then does the formula become an array
formula.</paragraph>
-<paragraph role="note" id="par_id3151120" xml-lang="en-US" l10n="U"
oldref="315">Array formulas appear in braces in $[officename] Calc. You cannot
create array formulas by manually entering the braces.</paragraph>
+<paragraph role="paragraph" id="par_id3149102" xml-lang="en-US" l10n="U">If
you create an array formula using the <emph>Function Wizard</emph>, you must
mark the <emph>Array</emph> check box each time so that the results are
returned in an array. Otherwise, only the value in the upper-left cell of the
array being calculated is returned.</paragraph>
+<paragraph role="paragraph" id="par_id3153392" xml-lang="en-US" l10n="U">If
you enter the array formula directly into the cell, you must use the key
combination Shift+<switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter
instead of the Enter key. Only then does the formula become an array
formula.</paragraph>
+<paragraph role="note" id="par_id3151120" xml-lang="en-US" l10n="U">Array
formulas appear in braces in $[officename] Calc. You cannot create array
formulas by manually entering the braces.</paragraph>
</section>
-<paragraph role="paragraph" id="par_id3154342" xml-lang="en-US" l10n="U"
oldref="5">The cells in a results array are automatically protected against
changes. However, you can edit or copy the array formula by selecting the
entire array cell range.</paragraph>
+<paragraph role="paragraph" id="par_id3154342" xml-lang="en-US" l10n="U">The
cells in a results array are automatically protected against changes. However,
you can edit or copy the array formula by selecting the entire array cell
range.</paragraph>
<paragraph role="heading" id="hd_id8834803" xml-lang="en-US" level="3"
l10n="NEW">Using Inline Array Constants in Formulas</paragraph>
<paragraph role="paragraph" id="par_id985747" xml-lang="en-US" l10n="NEW">Calc
supports inline matrix/array constants in formulas. An inline array is
surrounded by curly braces '{' and '}'. Elements can be each a number
(including negatives), a logical constant (TRUE, FALSE), or a literal string.
Non-constant expressions are not allowed. Arrays can be entered with one or
more rows, and one or more columns. All rows must consist of the same number of
elements, all columns must consist of [...]
<paragraph role="paragraph" id="par_id936613" xml-lang="en-US" l10n="NEW">The
column separator (separating elements in one row) is the ';' semicolon. The row
separator is a '|' pipe symbol. The separators are not language and locale
dependent.</paragraph>
@@ -161,49 +143,49 @@
<paragraph role="paragraph" id="par_id1623889" xml-lang="en-US" l10n="NEW">A
mixed data array.</paragraph>
<paragraph role="code" id="par_id7781914" xml-lang="en-US"
l10n="NEW">=SIN({1;2;3})</paragraph>
<paragraph role="paragraph" id="par_id300912" xml-lang="en-US"
l10n="NEW">Entered as a matrix formula, delivers the result of three SIN
calculations with the arguments 1, 2, and 3.</paragraph>
-<paragraph role="heading" id="hd_id3148660" xml-lang="en-US" level="3"
l10n="U" oldref="316">Editing Array Formulas</paragraph>
+<paragraph role="heading" id="hd_id3148660" xml-lang="en-US" level="3"
l10n="U">Editing Array Formulas</paragraph>
<list type="ordered">
<listitem>
-<paragraph role="listitem" id="par_id3149241" xml-lang="en-US" l10n="U"
oldref="317">Select the cell range or array containing the array formula. To
select the whole array, position the cell cursor inside the array range, then
press <switchinline select="sys"><caseinline select="MAC">Command
</caseinline><defaultinline>Ctrl </defaultinline></switchinline>+ /, where / is
the Division key on the numeric keypad.</paragraph>
+<paragraph role="listitem" id="par_id3149241" xml-lang="en-US" l10n="U">Select
the cell range or array containing the array formula. To select the whole
array, position the cell cursor inside the array range, then press
<switchinline select="sys"><caseinline select="MAC">Command
</caseinline><defaultinline>Ctrl </defaultinline></switchinline>+ /, where / is
the Division key on the numeric keypad.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3143274" xml-lang="en-US" l10n="U"
oldref="318">Either press F2 or position the cursor in the input line. Both of
these actions let you edit the formula.</paragraph>
+<paragraph role="listitem" id="par_id3143274" xml-lang="en-US" l10n="U">Either
press F2 or position the cursor in the input line. Both of these actions let
you edit the formula.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3154798" xml-lang="en-US" l10n="U"
oldref="319">After you have made changes, press <switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter.</paragraph>
+<paragraph role="listitem" id="par_id3154798" xml-lang="en-US" l10n="U">After
you have made changes, press <switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter.</paragraph>
</listitem>
</list>
-<paragraph role="tip" id="par_id3150628" xml-lang="en-US" l10n="U"
oldref="334">You can format the separate parts of an array. For example, you
can change the font color. Select a cell range and then change the attribute
you want.</paragraph>
-<paragraph role="heading" id="hd_id3145608" xml-lang="en-US" level="3"
l10n="U" oldref="320">Copying Array Formulas</paragraph>
+<paragraph role="tip" id="par_id3150628" xml-lang="en-US" l10n="U">You can
format the separate parts of an array. For example, you can change the font
color. Select a cell range and then change the attribute you want.</paragraph>
+<paragraph role="heading" id="hd_id3145608" xml-lang="en-US" level="3"
l10n="U">Copying Array Formulas</paragraph>
<list type="ordered">
<listitem>
-<paragraph role="listitem" id="par_id3149585" xml-lang="en-US" l10n="U"
oldref="321">Select the cell range or array containing the array
formula.</paragraph>
+<paragraph role="listitem" id="par_id3149585" xml-lang="en-US" l10n="U">Select
the cell range or array containing the array formula.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3154619" xml-lang="en-US" l10n="U"
oldref="322">Either press F2 or position the cursor in the input
line.</paragraph>
+<paragraph role="listitem" id="par_id3154619" xml-lang="en-US" l10n="U">Either
press F2 or position the cursor in the input line.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3150994" xml-lang="en-US" l10n="U"
oldref="323">Copy the formula into the input line by pressing <switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C.</paragraph>
+<paragraph role="listitem" id="par_id3150994" xml-lang="en-US" l10n="U">Copy
the formula into the input line by pressing <switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3146787" xml-lang="en-US" l10n="U"
oldref="324">Select a range of cells where you want to insert the array formula
and either press F2 or position the cursor in the input line.</paragraph>
+<paragraph role="listitem" id="par_id3146787" xml-lang="en-US" l10n="U">Select
a range of cells where you want to insert the array formula and either press F2
or position the cursor in the input line.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3154419" xml-lang="en-US" l10n="U"
oldref="325">Paste the formula by pressing <switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V
in the selected space and confirm it by pressing <switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter.
The selected range now contains the array formula.</paragraph>
+<paragraph role="listitem" id="par_id3154419" xml-lang="en-US" l10n="U">Paste
the formula by pressing <switchinline select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V
in the selected space and confirm it by pressing <switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter.
The selected range now contains the array formula.</paragraph>
</listitem>
</list>
-<paragraph role="heading" id="hd_id3154834" xml-lang="en-US" level="3"
l10n="U" oldref="328">Adjusting an Array Range</paragraph>
-<paragraph role="paragraph" id="par_id3148679" xml-lang="en-US" l10n="U"
oldref="329">If you want to edit the output array, do the following:</paragraph>
+<paragraph role="heading" id="hd_id3154834" xml-lang="en-US" level="3"
l10n="U">Adjusting an Array Range</paragraph>
+<paragraph role="paragraph" id="par_id3148679" xml-lang="en-US" l10n="U">If
you want to edit the output array, do the following:</paragraph>
<list type="ordered">
<listitem>
-<paragraph role="listitem" id="par_id3151102" xml-lang="en-US" l10n="U"
oldref="330">Select the cell range or array containing the array
formula.</paragraph>
+<paragraph role="listitem" id="par_id3151102" xml-lang="en-US" l10n="U">Select
the cell range or array containing the array formula.</paragraph>
</listitem>
<listitem>
-<paragraph role="listitem" id="par_id3147096" xml-lang="en-US" l10n="U"
oldref="331">Below the selection, to the right, you will see a small icon with
which you can zoom in or out on the range using your mouse.</paragraph>
+<paragraph role="listitem" id="par_id3147096" xml-lang="en-US" l10n="U">Below
the selection, to the right, you will see a small icon with which you can zoom
in or out on the range using your mouse.</paragraph>
</listitem>
</list>
-<paragraph role="note" id="par_id3150974" xml-lang="en-US" l10n="U"
oldref="332">When you adjust the array range, the array formula will not
automatically be adjusted. You are only changing the range in which the result
will appear.</paragraph>
-<paragraph role="paragraph" id="par_id3146080" xml-lang="en-US" l10n="U"
oldref="333">By holding down the <switchinline select="sys"><caseinline
select="MAC">Command </caseinline><defaultinline>Ctrl
</defaultinline></switchinline>key, you can create a copy of the array formula
in the given range.</paragraph>
+<paragraph role="note" id="par_id3150974" xml-lang="en-US" l10n="U">When you
adjust the array range, the array formula will not automatically be adjusted.
You are only changing the range in which the result will appear.</paragraph>
+<paragraph role="paragraph" id="par_id3146080" xml-lang="en-US" l10n="U">By
holding down the <switchinline select="sys"><caseinline select="MAC">Command
</caseinline><defaultinline>Ctrl </defaultinline></switchinline>key, you can
create a copy of the array formula in the given range.</paragraph>
<paragraph role="heading" id="par_idN10D47" xml-lang="en-US" level="3"
l10n="NEW">Conditional Array Calculations</paragraph>
<paragraph role="paragraph" id="par_idN10D4B" xml-lang="en-US" l10n="NEW">A
conditional array calculation is an array or matrix formula that includes an
IF() or CHOOSE() function. The condition argument in the formula is an area
reference or a matrix result.</paragraph>
<paragraph role="paragraph" id="par_idN10D4E" xml-lang="en-US" l10n="NEW">In
the following example, the >0 test of the {=IF(A1:A3>0;"yes";"no")}
formula is applied to each cell in the range A1:A3 and the result is copied to
the corresponding cell.</paragraph>
@@ -351,162 +333,137 @@
<bookmark_value>MUNIT function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EINHEITSMATRIX"
id="bm_id3151317" localize="false"/>
-<paragraph role="heading" id="hd_id3158446" xml-lang="en-US" level="2"
l10n="U" oldref="12">MUNIT</paragraph>
-<paragraph role="paragraph" id="par_id3154121" xml-lang="en-US" l10n="U"
oldref="13"><ahelp hid="HID_FUNC_EINHEITSMATRIX">Returns the unitary square
array of a certain size.</ahelp> The unitary array is a square array where the
main diagonal elements equal 1 and all other array elements are equal to
0.</paragraph>
-<paragraph role="heading" id="hd_id3155123" xml-lang="en-US" level="3"
l10n="U" oldref="14">Syntax</paragraph>
-<paragraph role="code" id="par_id3156271" xml-lang="en-US" l10n="U"
oldref="15">MUNIT(Dimensions)</paragraph>
-<paragraph role="paragraph" id="par_id3159390" xml-lang="en-US" l10n="U"
oldref="16">
-<emph>Dimensions</emph> refers to the size of the array unit.</paragraph>
+<paragraph role="heading" id="hd_id3158446" xml-lang="en-US" level="2"
l10n="U">MUNIT</paragraph>
+<paragraph role="paragraph" id="par_id3154121" xml-lang="en-US"
l10n="U"><ahelp hid="HID_FUNC_EINHEITSMATRIX">Returns the unitary square array
of a certain size.</ahelp> The unitary array is a square array where the main
diagonal elements equal 1 and all other array elements are equal to
0.</paragraph>
+<paragraph role="heading" id="hd_id3155123" xml-lang="en-US" level="3"
l10n="U">Syntax</paragraph>
+<paragraph role="code" id="par_id3156271" xml-lang="en-US"
l10n="U">MUNIT(Dimensions)</paragraph>
+<paragraph role="paragraph" id="par_id3159390" xml-lang="en-US"
l10n="U"><emph>Dimensions</emph> refers to the size of the array
unit.</paragraph>
<paragraph role="note" id="par_idN10C9B" xml-lang="en-US" l10n="NEW">You can
find a general introduction to Array functions at the top of this
page.</paragraph>
-<paragraph role="heading" id="hd_id3156162" xml-lang="en-US" level="3"
l10n="U" oldref="17">Example</paragraph>
-<paragraph role="paragraph" id="par_id3150949" xml-lang="en-US" l10n="U"
oldref="18">Select a square range within the spreadsheet, for example, from A1
to E5.</paragraph>
-<paragraph role="paragraph" id="par_id3151260" xml-lang="en-US" l10n="U"
oldref="19">Without deselecting the range, select the MUNIT function. Mark the
<emph>Array</emph> check box. Enter the desired dimensions for the array unit,
in this case <item type="input">5</item>, and click <emph>OK</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3150403" xml-lang="en-US" l10n="U"
oldref="20">You can also enter the <item type="input">=Munit(5)</item> formula
in the last cell of the selected range (E5), and press <switchinline
select="sys"><caseinline
select="MAC">Shift+Command+Enter</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>.</paragraph>
-<paragraph role="paragraph" id="par_id3156143" xml-lang="en-US" l10n="U"
oldref="21">You now see a unit array with a range of A1:E5.</paragraph>
-<paragraph role="paragraph" id="par_idN10FA7" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
-</paragraph>
+<paragraph role="heading" id="hd_id3156162" xml-lang="en-US" level="3"
l10n="U">Example</paragraph>
+<paragraph role="paragraph" id="par_id3150949" xml-lang="en-US"
l10n="U">Select a square range within the spreadsheet, for example, from A1 to
E5.</paragraph>
+<paragraph role="paragraph" id="par_id3151260" xml-lang="en-US"
l10n="U">Without deselecting the range, select the MUNIT function. Mark the
<emph>Array</emph> check box. Enter the desired dimensions for the array unit,
in this case <item type="input">5</item>, and click <emph>OK</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3150403" xml-lang="en-US" l10n="U">You
can also enter the <item type="input">=Munit(5)</item> formula in the last cell
of the selected range (E5), and press <switchinline select="sys"><caseinline
select="MAC">Shift+Command+Enter</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>.</paragraph>
+<paragraph role="paragraph" id="par_id3156143" xml-lang="en-US" l10n="U">You
now see a unit array with a range of A1:E5.</paragraph>
+<paragraph role="paragraph" id="par_idN10FA7" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph>
</section>
<section id="Section13">
<bookmark xml-lang="en-US" branch="index" id="bm_id3159084">
<bookmark_value>FREQUENCY function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HAEUFIGKEIT"
id="bm_id3153883" localize="false"/>
-<paragraph role="heading" id="hd_id3159084" xml-lang="en-US" level="2"
l10n="U" oldref="22">FREQUENCY</paragraph>
-<paragraph role="paragraph" id="par_id3145777" xml-lang="en-US" l10n="CHG"
oldref="23"><ahelp hid="HID_FUNC_HAEUFIGKEIT">Indicates the frequency
distribution in a one-column-array.</ahelp> The function counts the number of
values in the Data array that are within the values given by the Classes
array.</paragraph>
-<paragraph role="heading" id="hd_id3153347" xml-lang="en-US" level="3"
l10n="U" oldref="24">Syntax</paragraph>
-<paragraph role="code" id="par_id3155498" xml-lang="en-US" l10n="U"
oldref="25">FREQUENCY(Data; Classes)</paragraph>
-<paragraph role="paragraph" id="par_id3154352" xml-lang="en-US" l10n="CHG"
oldref="26">
-<emph>Data</emph> represents the reference to the values to be
counted.</paragraph>
-<paragraph role="paragraph" id="par_id3148402" xml-lang="en-US" l10n="CHG"
oldref="27">
-<emph>Classes</emph> represents the array of the limit values.</paragraph>
+<paragraph role="heading" id="hd_id3159084" xml-lang="en-US" level="2"
l10n="U">FREQUENCY</paragraph>
+<paragraph role="paragraph" id="par_id3145777" xml-lang="en-US"
l10n="CHG"><ahelp hid="HID_FUNC_HAEUFIGKEIT">Indicates the frequency
distribution in a one-column-array.</ahelp> The function counts the number of
values in the Data array that are within the values given by the Classes
array.</paragraph>
+<paragraph role="heading" id="hd_id3153347" xml-lang="en-US" level="3"
l10n="U">Syntax</paragraph>
+<paragraph role="code" id="par_id3155498" xml-lang="en-US"
l10n="U">FREQUENCY(Data; Classes)</paragraph>
+<paragraph role="paragraph" id="par_id3154352" xml-lang="en-US"
l10n="CHG"><emph>Data</emph> represents the reference to the values to be
counted.</paragraph>
+<paragraph role="paragraph" id="par_id3148402" xml-lang="en-US"
l10n="CHG"><emph>Classes</emph> represents the array of the limit
values.</paragraph>
<paragraph role="note" id="par_idN10D71" xml-lang="en-US" l10n="NEW">You can
find a general introduction to Array functions at the top of this
page.</paragraph>
-<paragraph role="heading" id="hd_id3148981" xml-lang="en-US" level="3"
l10n="U" oldref="28">Example</paragraph>
-<paragraph role="paragraph" id="par_id3155904" xml-lang="en-US" l10n="CHG"
oldref="219">In the following table, column A lists unsorted measurement
values. Column B contains the upper limit you entered for the classes into
which you want to divide the data in column A. According to the limit entered
in B1, the FREQUENCY function returns the number of measured values less than
or equal to 5. As the limit in B2 is 10, the FREQUENCY function returns the
second result as the number of measur [...]
+<paragraph role="heading" id="hd_id3148981" xml-lang="en-US" level="3"
l10n="U">Example</paragraph>
+<paragraph role="paragraph" id="par_id3155904" xml-lang="en-US" l10n="CHG">In
the following table, column A lists unsorted measurement values. Column B
contains the upper limit you entered for the classes into which you want to
divide the data in column A. According to the limit entered in B1, the
FREQUENCY function returns the number of measured values less than or equal to
5. As the limit in B2 is 10, the FREQUENCY function returns the second result
as the number of measured values tha [...]
<table id="tbl_id3150680">
<tablerow>
<tablecell>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3155869" xml-lang="en-US" l10n="U"
oldref="220">
-<emph>A</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3155869" xml-lang="en-US"
l10n="U"><emph>A</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3149328" xml-lang="en-US" l10n="U"
oldref="221">
-<emph>B</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3149328" xml-lang="en-US"
l10n="U"><emph>B</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3152467" xml-lang="en-US" l10n="U"
oldref="222">
-<emph>C</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3152467" xml-lang="en-US"
l10n="U"><emph>C</emph></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3154528" xml-lang="en-US" l10n="U"
oldref="223">
-<emph>1</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3154528" xml-lang="en-US"
l10n="U"><emph>1</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3149744" xml-lang="en-US" l10n="U"
oldref="224">12</paragraph>
+<paragraph role="paragraph" id="par_id3149744" xml-lang="en-US"
l10n="U">12</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3147309" xml-lang="en-US" l10n="U"
oldref="225">5</paragraph>
+<paragraph role="paragraph" id="par_id3147309" xml-lang="en-US"
l10n="U">5</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3154199" xml-lang="en-US" l10n="U"
oldref="226">1</paragraph>
+<paragraph role="paragraph" id="par_id3154199" xml-lang="en-US"
l10n="U">1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3159218" xml-lang="en-US" l10n="U"
oldref="227">
-<emph>2</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3159218" xml-lang="en-US"
l10n="U"><emph>2</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3153263" xml-lang="en-US" l10n="U"
oldref="228">8</paragraph>
+<paragraph role="paragraph" id="par_id3153263" xml-lang="en-US"
l10n="U">8</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3156201" xml-lang="en-US" l10n="U"
oldref="229">10</paragraph>
+<paragraph role="paragraph" id="par_id3156201" xml-lang="en-US"
l10n="U">10</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3147552" xml-lang="en-US" l10n="U"
oldref="230">3</paragraph>
+<paragraph role="paragraph" id="par_id3147552" xml-lang="en-US"
l10n="U">3</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3149174" xml-lang="en-US" l10n="U"
oldref="231">
-<emph>3</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3149174" xml-lang="en-US"
l10n="U"><emph>3</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3151201" xml-lang="en-US" l10n="U"
oldref="232">24</paragraph>
+<paragraph role="paragraph" id="par_id3151201" xml-lang="en-US"
l10n="U">24</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3150245" xml-lang="en-US" l10n="U"
oldref="233">15</paragraph>
+<paragraph role="paragraph" id="par_id3150245" xml-lang="en-US"
l10n="U">15</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3159194" xml-lang="en-US" l10n="U"
oldref="234">2</paragraph>
+<paragraph role="paragraph" id="par_id3159194" xml-lang="en-US"
l10n="U">2</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3146925" xml-lang="en-US" l10n="U"
oldref="235">
-<emph>4</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3146925" xml-lang="en-US"
l10n="U"><emph>4</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3154128" xml-lang="en-US" l10n="U"
oldref="236">11</paragraph>
+<paragraph role="paragraph" id="par_id3154128" xml-lang="en-US"
l10n="U">11</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3151067" xml-lang="en-US" l10n="U"
oldref="237">20</paragraph>
+<paragraph role="paragraph" id="par_id3151067" xml-lang="en-US"
l10n="U">20</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3156033" xml-lang="en-US" l10n="U"
oldref="238">3</paragraph>
+<paragraph role="paragraph" id="par_id3156033" xml-lang="en-US"
l10n="U">3</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3149298" xml-lang="en-US" l10n="U"
oldref="239">
-<emph>5</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3149298" xml-lang="en-US"
l10n="U"><emph>5</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3151382" xml-lang="en-US" l10n="U"
oldref="240">5</paragraph>
+<paragraph role="paragraph" id="par_id3151382" xml-lang="en-US"
l10n="U">5</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3155141" xml-lang="en-US" l10n="U"
oldref="241">25</paragraph>
+<paragraph role="paragraph" id="par_id3155141" xml-lang="en-US"
l10n="U">25</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3145213" xml-lang="en-US" l10n="U"
oldref="242">1</paragraph>
+<paragraph role="paragraph" id="par_id3145213" xml-lang="en-US"
l10n="U">1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3145268" xml-lang="en-US" l10n="U"
oldref="243">
-<emph>6</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3145268" xml-lang="en-US"
l10n="U"><emph>6</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3163724" xml-lang="en-US" l10n="U"
oldref="244">20</paragraph>
+<paragraph role="paragraph" id="par_id3163724" xml-lang="en-US"
l10n="U">20</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3147132" xml-lang="en-US" l10n="U"
oldref="245">>25</paragraph>
+<paragraph role="paragraph" id="par_id3147132" xml-lang="en-US"
l10n="U">>25</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3148903" xml-lang="en-US" l10n="U"
oldref="246">1</paragraph>
+<paragraph role="paragraph" id="par_id3148903" xml-lang="en-US"
l10n="U">1</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3151007" xml-lang="en-US" l10n="U"
oldref="247">
-<emph>7</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3151007" xml-lang="en-US"
l10n="U"><emph>7</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3153294" xml-lang="en-US" l10n="U"
oldref="248">16</paragraph>
+<paragraph role="paragraph" id="par_id3153294" xml-lang="en-US"
l10n="U">16</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -515,12 +472,10 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3147284" xml-lang="en-US" l10n="U"
oldref="249">
-<emph>8</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3147284" xml-lang="en-US"
l10n="U"><emph>8</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3154914" xml-lang="en-US" l10n="U"
oldref="250">9</paragraph>
+<paragraph role="paragraph" id="par_id3154914" xml-lang="en-US"
l10n="U">9</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -529,12 +484,10 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3154218" xml-lang="en-US" l10n="U"
oldref="251">
-<emph>9</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3154218" xml-lang="en-US"
l10n="U"><emph>9</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3147226" xml-lang="en-US" l10n="U"
oldref="252">7</paragraph>
+<paragraph role="paragraph" id="par_id3147226" xml-lang="en-US"
l10n="U">7</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -543,12 +496,10 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3149045" xml-lang="en-US" l10n="U"
oldref="253">
-<emph>10</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3149045" xml-lang="en-US"
l10n="U"><emph>10</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3155799" xml-lang="en-US" l10n="U"
oldref="254">16</paragraph>
+<paragraph role="paragraph" id="par_id3155799" xml-lang="en-US"
l10n="U">16</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -557,12 +508,10 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3155076" xml-lang="en-US" l10n="U"
oldref="255">
-<emph>11</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3155076" xml-lang="en-US"
l10n="U"><emph>11</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3150217" xml-lang="en-US" l10n="U"
oldref="256">33</paragraph>
+<paragraph role="paragraph" id="par_id3150217" xml-lang="en-US"
l10n="U">33</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -570,10 +519,8 @@
</tablecell>
</tablerow>
</table>
-<paragraph role="paragraph" id="par_id3150312" xml-lang="en-US" l10n="CHG"
oldref="29">Select a single column range in which to enter the frequency
according to the class limits. You must select one field more than the class
ceiling. In this example, select the range C1:C6. Call up the FREQUENCY
function in the <emph>Function Wizard</emph>. Select the <emph>Data</emph>
range in (A1:A11), and then the <emph>Classes</emph> range in which you entered
the class limits (B1:B6). Select the <em [...]
-<paragraph role="paragraph" id="par_idN11269" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
-</paragraph>
+<paragraph role="paragraph" id="par_id3150312" xml-lang="en-US"
l10n="CHG">Select a single column range in which to enter the frequency
according to the class limits. You must select one field more than the class
ceiling. In this example, select the range C1:C6. Call up the FREQUENCY
function in the <emph>Function Wizard</emph>. Select the <emph>Data</emph>
range in (A1:A11), and then the <emph>Classes</emph> range in which you entered
the class limits (B1:B6). Select the <emph>Array</em [...]
+<paragraph role="paragraph" id="par_idN11269" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph>
</section>
<section id="Section12">
<bookmark xml-lang="en-US" branch="index" id="bm_id3151030">
@@ -581,12 +528,11 @@
<bookmark_value>determinants</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MDET" id="bm_id3154057"
localize="false"/>
-<paragraph role="heading" id="hd_id3151030" xml-lang="en-US" level="2"
l10n="U" oldref="31">MDETERM</paragraph>
-<paragraph role="paragraph" id="par_id3154073" xml-lang="en-US" l10n="U"
oldref="32"><ahelp hid="HID_FUNC_MDET">Returns the array determinant of an
array.</ahelp> This function returns a value in the current cell; it is not
necessary to define a range for the results.</paragraph>
-<paragraph role="heading" id="hd_id3156366" xml-lang="en-US" level="3"
l10n="U" oldref="33">Syntax</paragraph>
-<paragraph role="code" id="par_id3156380" xml-lang="en-US" l10n="U"
oldref="34">MDETERM(Array)</paragraph>
-<paragraph role="paragraph" id="par_id3150290" xml-lang="en-US" l10n="U"
oldref="35">
-<emph>Array</emph> represents a square array in which the determinants are
defined.</paragraph>
+<paragraph role="heading" id="hd_id3151030" xml-lang="en-US" level="2"
l10n="U">MDETERM</paragraph>
+<paragraph role="paragraph" id="par_id3154073" xml-lang="en-US"
l10n="U"><ahelp hid="HID_FUNC_MDET">Returns the array determinant of an
array.</ahelp> This function returns a value in the current cell; it is not
necessary to define a range for the results.</paragraph>
+<paragraph role="heading" id="hd_id3156366" xml-lang="en-US" level="3"
l10n="U">Syntax</paragraph>
+<paragraph role="code" id="par_id3156380" xml-lang="en-US"
l10n="U">MDETERM(Array)</paragraph>
+<paragraph role="paragraph" id="par_id3150290" xml-lang="en-US"
l10n="U"><emph>Array</emph> represents a square array in which the determinants
are defined.</paragraph>
<paragraph role="note" id="par_idN11035" xml-lang="en-US" l10n="NEW">You can
find a general introduction to using Array functions on top of this
page.</paragraph>
<paragraph role="paragraph" id="par_idN11333" xml-lang="en-US" l10n="NEW">
<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
@@ -598,135 +544,113 @@
<bookmark_value>inverse arrays</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINV" id="bm_id3151360"
localize="false"/>
-<paragraph role="heading" id="hd_id3151348" xml-lang="en-US" level="2"
l10n="U" oldref="39">MINVERSE</paragraph>
-<paragraph role="paragraph" id="par_id3145569" xml-lang="en-US" l10n="U"
oldref="40"><ahelp hid="HID_FUNC_MINV">Returns the inverse
array.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3156072" xml-lang="en-US" level="3"
l10n="U" oldref="41">Syntax</paragraph>
-<paragraph role="code" id="par_id3156085" xml-lang="en-US" l10n="U"
oldref="42">MINVERSE(Array)</paragraph>
-<paragraph role="paragraph" id="par_id3157849" xml-lang="en-US" l10n="U"
oldref="43">
-<emph>Array</emph> represents a square array that is to be
inverted.</paragraph>
-<paragraph role="paragraph" id="par_idN113EE" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
-</paragraph>
-<paragraph role="heading" id="hd_id3157868" xml-lang="en-US" level="3"
l10n="U" oldref="44">Example</paragraph>
-<paragraph role="paragraph" id="par_id3149638" xml-lang="en-US" l10n="U"
oldref="45">Select a square range and select MINVERSE. Select the output array,
select the <emph>Array</emph> field and click <emph>OK</emph>.</paragraph>
+<paragraph role="heading" id="hd_id3151348" xml-lang="en-US" level="2"
l10n="U">MINVERSE</paragraph>
+<paragraph role="paragraph" id="par_id3145569" xml-lang="en-US"
l10n="U"><ahelp hid="HID_FUNC_MINV">Returns the inverse
array.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3156072" xml-lang="en-US" level="3"
l10n="U">Syntax</paragraph>
+<paragraph role="code" id="par_id3156085" xml-lang="en-US"
l10n="U">MINVERSE(Array)</paragraph>
+<paragraph role="paragraph" id="par_id3157849" xml-lang="en-US"
l10n="U"><emph>Array</emph> represents a square array that is to be
inverted.</paragraph>
+<paragraph role="paragraph" id="par_idN113EE" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph>
+<paragraph role="heading" id="hd_id3157868" xml-lang="en-US" level="3"
l10n="U">Example</paragraph>
+<paragraph role="paragraph" id="par_id3149638" xml-lang="en-US"
l10n="U">Select a square range and select MINVERSE. Select the output array,
select the <emph>Array</emph> field and click <emph>OK</emph>.</paragraph>
</section>
<section id="Section10">
<bookmark xml-lang="en-US" branch="index" id="bm_id3148546">
<bookmark_value>MMULT function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MMULT" id="bm_id3148501"
localize="false"/>
-<paragraph role="heading" id="hd_id3148546" xml-lang="en-US" level="2"
l10n="U" oldref="47">MMULT</paragraph>
-<paragraph role="paragraph" id="par_id3148518" xml-lang="en-US" l10n="U"
oldref="48"><ahelp hid="HID_FUNC_MMULT">Calculates the array product of two
arrays.</ahelp> The number of columns for array 1 must match the number of rows
for array 2. The square array has an equal number of rows and
columns.</paragraph>
-<paragraph role="heading" id="hd_id3146767" xml-lang="en-US" level="3"
l10n="U" oldref="49">Syntax</paragraph>
-<paragraph role="code" id="par_id3150798" xml-lang="en-US" l10n="U"
oldref="50">MMULT(Array; Array)</paragraph>
-<paragraph role="paragraph" id="par_id3150812" xml-lang="en-US" l10n="U"
oldref="51">
-<emph>Array</emph> at first place represents the first array used in the array
product.</paragraph>
-<paragraph role="paragraph" id="par_id3152553" xml-lang="en-US" l10n="U"
oldref="52">
-<emph>Array</emph> at second place represents the second array with the same
number of rows.</paragraph>
+<paragraph role="heading" id="hd_id3148546" xml-lang="en-US" level="2"
l10n="U">MMULT</paragraph>
+<paragraph role="paragraph" id="par_id3148518" xml-lang="en-US"
l10n="U"><ahelp hid="HID_FUNC_MMULT">Calculates the array product of two
arrays.</ahelp> The number of columns for array 1 must match the number of rows
for array 2. The square array has an equal number of rows and
columns.</paragraph>
+<paragraph role="heading" id="hd_id3146767" xml-lang="en-US" level="3"
l10n="U">Syntax</paragraph>
+<paragraph role="code" id="par_id3150798" xml-lang="en-US"
l10n="U">MMULT(Array; Array)</paragraph>
+<paragraph role="paragraph" id="par_id3150812" xml-lang="en-US"
l10n="U"><emph>Array</emph> at first place represents the first array used in
the array product.</paragraph>
+<paragraph role="paragraph" id="par_id3152553" xml-lang="en-US"
l10n="U"><emph>Array</emph> at second place represents the second array with
the same number of rows.</paragraph>
<paragraph role="note" id="par_idN114C3" xml-lang="en-US" l10n="NEW">
<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
</paragraph>
-<paragraph role="heading" id="hd_id3152574" xml-lang="en-US" level="3"
l10n="U" oldref="53">Example</paragraph>
-<paragraph role="paragraph" id="par_id3146826" xml-lang="en-US" l10n="U"
oldref="54">Select a square range. Choose the MMULT function. Select the first
<emph>Array</emph>, then select the second <emph>Array</emph>. Using
<emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click
<emph>OK</emph>. The output array will appear in the first selected
range.</paragraph>
+<paragraph role="heading" id="hd_id3152574" xml-lang="en-US" level="3"
l10n="U">Example</paragraph>
+<paragraph role="paragraph" id="par_id3146826" xml-lang="en-US"
l10n="U">Select a square range. Choose the MMULT function. Select the first
<emph>Array</emph>, then select the second <emph>Array</emph>. Using
<emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click
<emph>OK</emph>. The output array will appear in the first selected
range.</paragraph>
</section>
<section id="Section9">
<bookmark xml-lang="en-US" branch="index" id="bm_id3154970">
<bookmark_value>TRANSPOSE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MTRANS" id="bm_id3154982"
localize="false"/>
-<paragraph role="heading" id="hd_id3154970" xml-lang="en-US" level="2"
l10n="U" oldref="56">TRANSPOSE</paragraph>
-<paragraph role="paragraph" id="par_id3155276" xml-lang="en-US" l10n="U"
oldref="57"><ahelp hid="HID_FUNC_MTRANS">Transposes the rows and columns of an
array.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3155294" xml-lang="en-US" level="3"
l10n="U" oldref="58">Syntax</paragraph>
-<paragraph role="code" id="par_id3153843" xml-lang="en-US" l10n="U"
oldref="59">TRANSPOSE(Array)</paragraph>
-<paragraph role="paragraph" id="par_id3153857" xml-lang="en-US" l10n="U"
oldref="60">
-<emph>Array</emph> represents the array in the spreadsheet that is to be
transposed.</paragraph>
-<paragraph role="paragraph" id="par_idN115A5" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
-</paragraph>
-<paragraph role="heading" id="hd_id3159352" xml-lang="en-US" level="3"
l10n="U" oldref="61">Example</paragraph>
-<paragraph role="paragraph" id="par_id3159366" xml-lang="en-US" l10n="U"
oldref="62">In the spreadsheet, select the range in which the transposed array
can appear. If the original array has n rows and m columns, your selected range
must have at least m rows and n columns. Then enter the formula directly,
select the original array and press <switchinline select="sys"><caseinline
select="MAC">Shift+Command+Enter</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>.
Or [...]
+<paragraph role="heading" id="hd_id3154970" xml-lang="en-US" level="2"
l10n="U">TRANSPOSE</paragraph>
+<paragraph role="paragraph" id="par_id3155276" xml-lang="en-US"
l10n="U"><ahelp hid="HID_FUNC_MTRANS">Transposes the rows and columns of an
array.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3155294" xml-lang="en-US" level="3"
l10n="U">Syntax</paragraph>
+<paragraph role="code" id="par_id3153843" xml-lang="en-US"
l10n="U">TRANSPOSE(Array)</paragraph>
+<paragraph role="paragraph" id="par_id3153857" xml-lang="en-US"
l10n="U"><emph>Array</emph> represents the array in the spreadsheet that is to
be transposed.</paragraph>
+<paragraph role="paragraph" id="par_idN115A5" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph>
+<paragraph role="heading" id="hd_id3159352" xml-lang="en-US" level="3"
l10n="U">Example</paragraph>
+<paragraph role="paragraph" id="par_id3159366" xml-lang="en-US" l10n="U">In
the spreadsheet, select the range in which the transposed array can appear. If
the original array has n rows and m columns, your selected range must have at
least m rows and n columns. Then enter the formula directly, select the
original array and press <switchinline select="sys"><caseinline
select="MAC">Shift+Command+Enter</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>.
Or, if you are [...]
</section>
<section id="Section8">
<bookmark xml-lang="en-US" branch="index" id="bm_id3109846">
<bookmark_value>LINEST function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RGP" id="bm_id3144716"
localize="false"/>
-<paragraph role="heading" id="hd_id3109846" xml-lang="en-US" level="2"
l10n="U" oldref="64">LINEST</paragraph>
-<paragraph role="paragraph" id="par_id3144733" xml-lang="en-US" l10n="CHG"
oldref="65"><ahelp hid="HID_FUNC_RGP">Returns a table of statistics for a
straight line that best fits a data set.</ahelp><comment>changed based on
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_LINEST_function
(issue 76142)</comment></paragraph>
-<paragraph role="heading" id="hd_id3152825" xml-lang="en-US" level="3"
l10n="U" oldref="66">Syntax</paragraph>
-<paragraph role="code" id="par_id3152839" xml-lang="en-US" l10n="U"
oldref="67">LINEST(data_Y; data_X; linearType; stats)</paragraph>
-<paragraph role="paragraph" id="par_id3152853" xml-lang="en-US" l10n="U"
oldref="68">
-<emph>data_Y</emph> is a single row or column range specifying the y
coordinates in a set of data points.</paragraph>
-<paragraph role="paragraph" id="par_id3154428" xml-lang="en-US" l10n="U"
oldref="69">
-<emph>data_X</emph> is a corresponding single row or column range specifying
the x coordinates. If <emph>data_X</emph> is omitted it defaults to <item
type="literal">1, 2, 3, ..., n</item>. If there is more than one set of
variables <emph>data_X</emph> may be a range with corresponding multiple rows
or columns.</paragraph>
+<paragraph role="heading" id="hd_id3109846" xml-lang="en-US" level="2"
l10n="U">LINEST</paragraph>
+<paragraph role="paragraph" id="par_id3144733" xml-lang="en-US"
l10n="CHG"><ahelp hid="HID_FUNC_RGP">Returns a table of statistics for a
straight line that best fits a data set.</ahelp><comment>changed based on
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_LINEST_function
(issue 76142)</comment></paragraph>
+<paragraph role="heading" id="hd_id3152825" xml-lang="en-US" level="3"
l10n="U">Syntax</paragraph>
+<paragraph role="code" id="par_id3152839" xml-lang="en-US"
l10n="U">LINEST(data_Y; data_X; linearType; stats)</paragraph>
+<paragraph role="paragraph" id="par_id3152853" xml-lang="en-US"
l10n="U"><emph>data_Y</emph> is a single row or column range specifying the y
coordinates in a set of data points.</paragraph>
+<paragraph role="paragraph" id="par_id3154428" xml-lang="en-US"
l10n="U"><emph>data_X</emph> is a corresponding single row or column range
specifying the x coordinates. If <emph>data_X</emph> is omitted it defaults to
<item type="literal">1, 2, 3, ..., n</item>. If there is more than one set of
variables <emph>data_X</emph> may be a range with corresponding multiple rows
or columns.</paragraph>
<paragraph role="paragraph" id="par_id0811200804502119" xml-lang="en-US"
l10n="NEW">LINEST finds a straight line <item type="literal">y = a + bx</item>
that best fits the data, using linear regression (the "least squares" method).
With more than one set of variables the straight line is of the form <item
type="literal">y = a + b1x1 + b2x2 ... + bnxn</item>.</paragraph>
-<paragraph role="paragraph" id="par_id3154448" xml-lang="en-US" l10n="U"
oldref="70"> if<emph>linearType</emph> is FALSE the straight line found is
forced to pass through the origin (the constant a is zero; y = bx). If omitted,
<emph>linearType</emph> defaults to TRUE (the line is not forced through the
origin).</paragraph>
-<paragraph role="paragraph" id="par_id3154142" xml-lang="en-US" l10n="U"
oldref="71">if<emph>stats</emph> is omitted or FALSE only the top line of the
statistics table is returned. If TRUE the entire table is returned.</paragraph>
+<paragraph role="paragraph" id="par_id3154448" xml-lang="en-US" l10n="U">
if<emph>linearType</emph> is FALSE the straight line found is forced to pass
through the origin (the constant a is zero; y = bx). If omitted,
<emph>linearType</emph> defaults to TRUE (the line is not forced through the
origin).</paragraph>
+<paragraph role="paragraph" id="par_id3154142" xml-lang="en-US"
l10n="U">if<emph>stats</emph> is omitted or FALSE only the top line of the
statistics table is returned. If TRUE the entire table is returned.</paragraph>
<paragraph role="paragraph" id="par_id0811200804502261" xml-lang="en-US"
l10n="NEW">LINEST returns a table (array) of statistics as below and must be
entered as an array formula (for example by using <switchinline
select="sys"><caseinline
select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Return
rather than just Return).</paragraph>
-<paragraph role="paragraph" id="par_idN11416" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#optional"/>
-</paragraph>
+<paragraph role="paragraph" id="par_idN11416" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph>
<paragraph role="paragraph" id="par_idN116C6" xml-lang="en-US" l10n="NEW">
<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
</paragraph>
-<paragraph role="heading" id="hd_id3154162" xml-lang="en-US" level="3"
l10n="U" oldref="72">Example</paragraph>
-<paragraph role="paragraph" id="par_id3154176" xml-lang="en-US" l10n="U"
oldref="73">This function returns an array and is handled in the same way as
the other array functions. Select a range for the answers and then the
function. Select <emph>data_Y</emph>. If you want, you can enter other
parameters. Select <emph>Array</emph> and click <emph>OK</emph>.</paragraph>
-<paragraph role="paragraph" id="par_id3155468" xml-lang="en-US" l10n="U"
oldref="74">The results returned by the system (if <emph>stats</emph> = 0),
will at least show the slope of the regression line and its intersection with
the Y axis. If <emph>stats</emph> does not equal 0, other results are to be
displayed.</paragraph>
-<paragraph role="heading" id="hd_id3155491" xml-lang="en-US" level="3"
l10n="U" oldref="75">Other LINEST Results:</paragraph>
-<paragraph role="paragraph" id="par_id3159291" xml-lang="en-US" l10n="U"
oldref="76">Examine the following examples:</paragraph>
+<paragraph role="heading" id="hd_id3154162" xml-lang="en-US" level="3"
l10n="U">Example</paragraph>
+<paragraph role="paragraph" id="par_id3154176" xml-lang="en-US" l10n="U">This
function returns an array and is handled in the same way as the other array
functions. Select a range for the answers and then the function. Select
<emph>data_Y</emph>. If you want, you can enter other parameters. Select
<emph>Array</emph> and click <emph>OK</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3155468" xml-lang="en-US" l10n="U">The
results returned by the system (if <emph>stats</emph> = 0), will at least show
the slope of the regression line and its intersection with the Y axis. If
<emph>stats</emph> does not equal 0, other results are to be
displayed.</paragraph>
+<paragraph role="heading" id="hd_id3155491" xml-lang="en-US" level="3"
l10n="U">Other LINEST Results:</paragraph>
+<paragraph role="paragraph" id="par_id3159291" xml-lang="en-US"
l10n="U">Examine the following examples:</paragraph>
<table id="tbl_id3159305">
<tablerow>
<tablecell>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3157922" xml-lang="en-US" l10n="U"
oldref="77">A</paragraph>
+<paragraph role="paragraph" id="par_id3157922" xml-lang="en-US"
l10n="U">A</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3157945" xml-lang="en-US" l10n="U"
oldref="78">B</paragraph>
+<paragraph role="paragraph" id="par_id3157945" xml-lang="en-US"
l10n="U">B</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3152486" xml-lang="en-US" l10n="U"
oldref="79">C</paragraph>
+<paragraph role="paragraph" id="par_id3152486" xml-lang="en-US"
l10n="U">C</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3152509" xml-lang="en-US" l10n="U"
oldref="80">D</paragraph>
+<paragraph role="paragraph" id="par_id3152509" xml-lang="en-US"
l10n="U">D</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3152532" xml-lang="en-US" l10n="U"
oldref="81">E</paragraph>
+<paragraph role="paragraph" id="par_id3152532" xml-lang="en-US"
l10n="U">E</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3153431" xml-lang="en-US" l10n="U"
oldref="82">F</paragraph>
+<paragraph role="paragraph" id="par_id3153431" xml-lang="en-US"
l10n="U">F</paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3153454" xml-lang="en-US" l10n="U"
oldref="83">G</paragraph>
+<paragraph role="paragraph" id="par_id3153454" xml-lang="en-US"
l10n="U">G</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3154995" xml-lang="en-US" l10n="U"
oldref="84">
-<emph>1</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3154995" xml-lang="en-US"
l10n="U"><emph>1</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3155021" xml-lang="en-US" l10n="U"
oldref="85">
-<item type="input">x1</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3155021" xml-lang="en-US" l10n="U"><item
type="input">x1</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3155044" xml-lang="en-US" l10n="U"
oldref="86">
-<item type="input">x2</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3155044" xml-lang="en-US" l10n="U"><item
type="input">x2</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3163734" xml-lang="en-US" l10n="U"
oldref="87">
-<item type="input">y</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3163734" xml-lang="en-US" l10n="U"><item
type="input">y</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3163766" xml-lang="en-US" l10n="U"
oldref="88">
-<item type="input">LIN</item>
-<item type="input">EST value</item>
+<paragraph role="paragraph" id="par_id3163766" xml-lang="en-US" l10n="U"><item
type="input">LIN</item><item type="input">EST value</item>
</paragraph>
</tablecell>
<tablecell>
@@ -736,218 +660,141 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3145686" xml-lang="en-US" l10n="U"
oldref="89">
-<emph>2</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3145686" xml-lang="en-US"
l10n="U"><emph>2</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3145713" xml-lang="en-US" l10n="U"
oldref="90">
-<item type="input">4</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3145713" xml-lang="en-US" l10n="U"><item
type="input">4</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3145736" xml-lang="en-US" l10n="U"
oldref="91">
-<item type="input">7</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3145736" xml-lang="en-US" l10n="U"><item
type="input">7</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3159427" xml-lang="en-US" l10n="U"
oldref="92">
-<item type="input">100</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3159427" xml-lang="en-US" l10n="U"><item
type="input">100</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3159460" xml-lang="en-US" l10n="U"
oldref="93">
-<item type="input">4,17</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3159460" xml-lang="en-US" l10n="U"><item
type="input">4,17</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3159483" xml-lang="en-US" l10n="U"
oldref="94">-<item type="input">3,48</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3159483" xml-lang="en-US"
l10n="U">-<item type="input">3,48</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3152381" xml-lang="en-US" l10n="U"
oldref="95">
-<item type="input">82,33</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3152381" xml-lang="en-US" l10n="U"><item
type="input">82,33</item></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3152408" xml-lang="en-US" l10n="U"
oldref="96">
-<emph>3</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3152408" xml-lang="en-US"
l10n="U"><emph>3</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3152435" xml-lang="en-US" l10n="U"
oldref="97">
-<item type="input">5</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3152435" xml-lang="en-US" l10n="U"><item
type="input">5</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3152458" xml-lang="en-US" l10n="U"
oldref="98">
-<item type="input">9</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3152458" xml-lang="en-US" l10n="U"><item
type="input">9</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3155652" xml-lang="en-US" l10n="U"
oldref="99">
-<item type="input">105</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3155652" xml-lang="en-US" l10n="U"><item
type="input">105</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3155684" xml-lang="en-US" l10n="U"
oldref="100">
-<item type="input">5,46</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3155684" xml-lang="en-US" l10n="U"><item
type="input">5,46</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3155707" xml-lang="en-US" l10n="U"
oldref="101">
-<item type="input">10,96</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3155707" xml-lang="en-US" l10n="U"><item
type="input">10,96</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3155730" xml-lang="en-US" l10n="U"
oldref="102">
-<item type="input">9,35</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3155730" xml-lang="en-US" l10n="U"><item
type="input">9,35</item></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3159506" xml-lang="en-US" l10n="U"
oldref="103">
-<emph>4</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3159506" xml-lang="en-US"
l10n="U"><emph>4</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3159533" xml-lang="en-US" l10n="U"
oldref="104">
-<item type="input">6</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3159533" xml-lang="en-US" l10n="U"><item
type="input">6</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3159556" xml-lang="en-US" l10n="U"
oldref="105">
-<item type="input">11</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3159556" xml-lang="en-US" l10n="U"><item
type="input">11</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3159579" xml-lang="en-US" l10n="U"
oldref="106">
-<item type="input">104</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3159579" xml-lang="en-US" l10n="U"><item
type="input">104</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3159611" xml-lang="en-US" l10n="U"
oldref="107">
-<item type="input">0,87</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3159611" xml-lang="en-US" l10n="U"><item
type="input">0,87</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3152606" xml-lang="en-US" l10n="U"
oldref="108">
-<item type="input">5,06</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3152606" xml-lang="en-US" l10n="U"><item
type="input">5,06</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3152629" xml-lang="en-US" l10n="U"
oldref="109">
-<item type="input">#NA</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3152629" xml-lang="en-US" l10n="U"><item
type="input">#NA</item></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3152655" xml-lang="en-US" l10n="U"
oldref="110">
-<emph>5</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3152655" xml-lang="en-US"
l10n="U"><emph>5</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3152682" xml-lang="en-US" l10n="U"
oldref="111">
-<item type="input">7</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3152682" xml-lang="en-US" l10n="U"><item
type="input">7</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3152705" xml-lang="en-US" l10n="U"
oldref="112">
-<item type="input">12</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3152705" xml-lang="en-US" l10n="U"><item
type="input">12</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3152728" xml-lang="en-US" l10n="U"
oldref="113">
-<item type="input">108</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3152728" xml-lang="en-US" l10n="U"><item
type="input">108</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3144352" xml-lang="en-US" l10n="U"
oldref="114">
-<item type="input">13,21</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3144352" xml-lang="en-US" l10n="U"><item
type="input">13,21</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3144375" xml-lang="en-US" l10n="U"
oldref="115">
-<item type="input">4</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3144375" xml-lang="en-US" l10n="U"><item
type="input">4</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3144398" xml-lang="en-US" l10n="U"
oldref="116">
-<item type="input">#NA</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3144398" xml-lang="en-US" l10n="U"><item
type="input">#NA</item></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3144425" xml-lang="en-US" l10n="U"
oldref="117">
-<emph>6</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3144425" xml-lang="en-US"
l10n="U"><emph>6</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3144452" xml-lang="en-US" l10n="U"
oldref="118">
-<item type="input">8</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3144452" xml-lang="en-US" l10n="U"><item
type="input">8</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3144475" xml-lang="en-US" l10n="U"
oldref="119">
-<item type="input">15</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3144475" xml-lang="en-US" l10n="U"><item
type="input">15</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3144498" xml-lang="en-US" l10n="U"
oldref="120">
-<item type="input">111</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3144498" xml-lang="en-US" l10n="U"><item
type="input">111</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3158233" xml-lang="en-US" l10n="U"
oldref="121">
-<item type="input">675,45</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3158233" xml-lang="en-US" l10n="U"><item
type="input">675,45</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3158256" xml-lang="en-US" l10n="U"
oldref="122">
-<item type="input">102,26</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3158256" xml-lang="en-US" l10n="U"><item
type="input">102,26</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3158279" xml-lang="en-US" l10n="U"
oldref="123">
-<item type="input">#NA</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3158279" xml-lang="en-US" l10n="U"><item
type="input">#NA</item></paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3158306" xml-lang="en-US" l10n="U"
oldref="124">
-<emph>7</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3158306" xml-lang="en-US"
l10n="U"><emph>7</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3158333" xml-lang="en-US" l10n="U"
oldref="125">
-<item type="input">9</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3158333" xml-lang="en-US" l10n="U"><item
type="input">9</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3158356" xml-lang="en-US" l10n="U"
oldref="126">
-<item type="input">17</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3158356" xml-lang="en-US" l10n="U"><item
type="input">17</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3158379" xml-lang="en-US" l10n="U"
oldref="127">
-<item type="input">120</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3158379" xml-lang="en-US" l10n="U"><item
type="input">120</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -960,24 +807,16 @@
</tablerow>
<tablerow>
<tablecell>
-<paragraph role="paragraph" id="par_id3144560" xml-lang="en-US" l10n="U"
oldref="128">
-<emph>8</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3144560" xml-lang="en-US"
l10n="U"><emph>8</emph></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3144586" xml-lang="en-US" l10n="U"
oldref="129">
-<item type="input">10</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3144586" xml-lang="en-US" l10n="U"><item
type="input">10</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3144609" xml-lang="en-US" l10n="U"
oldref="130">
-<item type="input">19</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3144609" xml-lang="en-US" l10n="U"><item
type="input">19</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="paragraph" id="par_id3144632" xml-lang="en-US" l10n="U"
oldref="131">
-<item type="input">133</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3144632" xml-lang="en-US" l10n="U"><item
type="input">133</item></paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -989,69 +828,56 @@
</tablecell>
</tablerow>
</table>
-<paragraph role="paragraph" id="par_id3144687" xml-lang="en-US" l10n="U"
oldref="132">Column A contains several X1 values, column B several X2 values
and column C the Y values. You have already entered these values in your
spreadsheet. You have now set up E2:G6 in the spreadsheet and activated the
<emph>Function Wizard</emph>. For the LINEST function to work, you must have
marked the <emph>Array</emph> check box in the <emph>Function Wizard</emph>.
Next, select the following values in th [...]
-<paragraph role="paragraph" id="par_id3158020" xml-lang="en-US" l10n="U"
oldref="133">
-<emph>data_Y</emph> is C2:C8</paragraph>
-<paragraph role="paragraph" id="par_id3158039" xml-lang="en-US" l10n="U"
oldref="134">
-<emph>data_X</emph> is A2:B8</paragraph>
-<paragraph role="paragraph" id="par_id3158058" xml-lang="en-US" l10n="U"
oldref="135">
-<emph>linearType</emph> and <emph>stats</emph> are both set to 1.</paragraph>
-<paragraph role="paragraph" id="par_id3158084" xml-lang="en-US" l10n="U"
oldref="136">As soon as you click <emph>OK</emph>, $[officename] Calc will fill
the above example with the LINEST values as shown in the example.</paragraph>
-<paragraph role="paragraph" id="par_id3158106" xml-lang="en-US" l10n="U"
oldref="137">The formula in the <emph>Formula</emph> Bar corresponds to each
cell of the LINEST array <item type="input">{=LINEST(C2:C8;A2:B8;1;1)}</item>
-</paragraph>
-<paragraph role="paragraph" id="par_id3158128" xml-lang="en-US" l10n="U"
oldref="138">
-<emph>This represents the calculated LINEST values:</emph>
-</paragraph>
+<paragraph role="paragraph" id="par_id3144687" xml-lang="en-US"
l10n="U">Column A contains several X1 values, column B several X2 values and
column C the Y values. You have already entered these values in your
spreadsheet. You have now set up E2:G6 in the spreadsheet and activated the
<emph>Function Wizard</emph>. For the LINEST function to work, you must have
marked the <emph>Array</emph> check box in the <emph>Function Wizard</emph>.
Next, select the following values in the spreadsheet [...]
+<paragraph role="paragraph" id="par_id3158020" xml-lang="en-US"
l10n="U"><emph>data_Y</emph> is C2:C8</paragraph>
+<paragraph role="paragraph" id="par_id3158039" xml-lang="en-US"
l10n="U"><emph>data_X</emph> is A2:B8</paragraph>
+<paragraph role="paragraph" id="par_id3158058" xml-lang="en-US"
l10n="U"><emph>linearType</emph> and <emph>stats</emph> are both set to
1.</paragraph>
+<paragraph role="paragraph" id="par_id3158084" xml-lang="en-US" l10n="U">As
soon as you click <emph>OK</emph>, $[officename] Calc will fill the above
example with the LINEST values as shown in the example.</paragraph>
+<paragraph role="paragraph" id="par_id3158106" xml-lang="en-US" l10n="U">The
formula in the <emph>Formula</emph> Bar corresponds to each cell of the LINEST
array <item type="input">{=LINEST(C2:C8;A2:B8;1;1)}</item>
+</paragraph>
+<paragraph role="paragraph" id="par_id3158128" xml-lang="en-US"
l10n="U"><emph>This represents the calculated LINEST values:</emph></paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id3158146">
<bookmark_value>slopes, see also regression lines</bookmark_value>
<bookmark_value>regression lines;LINEST function</bookmark_value>
</bookmark><comment>mw made "regression lines" a two level entry</comment>
-<paragraph role="paragraph" id="par_id3158146" xml-lang="en-US" l10n="U"
oldref="139">E2 and F2: Slope m of the regression line y=b+m*x for the x1 and
x2 values. The values are given in reverse order; that is, the slope for x2 in
E2 and the slope for x1 in F2.</paragraph>
-<paragraph role="paragraph" id="par_id3158184" xml-lang="en-US" l10n="U"
oldref="140">G2: Intersection b with the y axis.</paragraph>
+<paragraph role="paragraph" id="par_id3158146" xml-lang="en-US" l10n="U">E2
and F2: Slope m of the regression line y=b+m*x for the x1 and x2 values. The
values are given in reverse order; that is, the slope for x2 in E2 and the
slope for x1 in F2.</paragraph>
+<paragraph role="paragraph" id="par_id3158184" xml-lang="en-US" l10n="U">G2:
Intersection b with the y axis.</paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id3158204">
<bookmark_value>standard errors;array functions</bookmark_value>
</bookmark><comment>MW changed "standard errors"</comment>
-<paragraph role="paragraph" id="par_id3158204" xml-lang="en-US" l10n="U"
oldref="141">E3 and F3: The standard error of the slope value.</paragraph>
-<paragraph role="paragraph" id="par_id3145845" xml-lang="en-US" l10n="U"
oldref="142">G3: The standard error of the intercept</paragraph>
+<paragraph role="paragraph" id="par_id3158204" xml-lang="en-US" l10n="U">E3
and F3: The standard error of the slope value.</paragraph>
+<paragraph role="paragraph" id="par_id3145845" xml-lang="en-US" l10n="U">G3:
The standard error of the intercept</paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id3145859">
<bookmark_value>RSQ calculations</bookmark_value>
</bookmark>
-<paragraph role="paragraph" id="par_id3145859" xml-lang="en-US" l10n="U"
oldref="143">E4: RSQ</paragraph>
-<paragraph role="paragraph" id="par_id3145880" xml-lang="en-US" l10n="U"
oldref="144">F4: The standard error of the regression calculated for the Y
value.</paragraph>
-<paragraph role="paragraph" id="par_id3145894" xml-lang="en-US" l10n="U"
oldref="145">E5: The F value from the variance analysis.</paragraph>
-<paragraph role="paragraph" id="par_id3145915" xml-lang="en-US" l10n="U"
oldref="146">F5: The degrees of freedom from the variance analysis.</paragraph>
-<paragraph role="paragraph" id="par_id3145937" xml-lang="en-US" l10n="U"
oldref="147">E6: The sum of the squared deviation of the estimated Y values
from their linear mean.</paragraph>
-<paragraph role="paragraph" id="par_id3145952" xml-lang="en-US" l10n="U"
oldref="148">F6: The sum of the squared deviation of the estimated Y value from
the given Y values.</paragraph>
-<paragraph role="paragraph" id="par_idN11B04" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
-</paragraph>
+<paragraph role="paragraph" id="par_id3145859" xml-lang="en-US" l10n="U">E4:
RSQ</paragraph>
+<paragraph role="paragraph" id="par_id3145880" xml-lang="en-US" l10n="U">F4:
The standard error of the regression calculated for the Y value.</paragraph>
+<paragraph role="paragraph" id="par_id3145894" xml-lang="en-US" l10n="U">E5:
The F value from the variance analysis.</paragraph>
+<paragraph role="paragraph" id="par_id3145915" xml-lang="en-US" l10n="U">F5:
The degrees of freedom from the variance analysis.</paragraph>
+<paragraph role="paragraph" id="par_id3145937" xml-lang="en-US" l10n="U">E6:
The sum of the squared deviation of the estimated Y values from their linear
mean.</paragraph>
+<paragraph role="paragraph" id="par_id3145952" xml-lang="en-US" l10n="U">F6:
The sum of the squared deviation of the estimated Y value from the given Y
values.</paragraph>
+<paragraph role="paragraph" id="par_idN11B04" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph>
</section>
<section id="Section7">
<bookmark xml-lang="en-US" branch="index" id="bm_id1596728">
<bookmark_value>LOGEST function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RKP" id="bm_id3146020"
localize="false"/>
-<paragraph role="heading" id="hd_id3146009" xml-lang="en-US" level="2"
l10n="U" oldref="150">LOGEST</paragraph>
-<paragraph role="paragraph" id="par_id3146037" xml-lang="en-US" l10n="U"
oldref="151"><ahelp hid="HID_FUNC_RKP">This function calculates the adjustment
of the entered data as an exponential regression curve
(y=b*m^x).</ahelp><comment>UFI: see
http://support.microsoft.com/default.aspx?kbid=828528&product=xl2003
+<paragraph role="heading" id="hd_id3146009" xml-lang="en-US" level="2"
l10n="U">LOGEST</paragraph>
+<paragraph role="paragraph" id="par_id3146037" xml-lang="en-US"
l10n="U"><ahelp hid="HID_FUNC_RKP">This function calculates the adjustment of
the entered data as an exponential regression curve
(y=b*m^x).</ahelp><comment>UFI: see
http://support.microsoft.com/default.aspx?kbid=828528&product=xl2003
for bug #i31051#</comment></paragraph>
-<paragraph role="heading" id="hd_id3146056" xml-lang="en-US" level="3"
l10n="U" oldref="152">Syntax</paragraph>
-<paragraph role="code" id="par_id3163123" xml-lang="en-US" l10n="U"
oldref="153">LOGEST(DataY; DataX; FunctionType; Stats)</paragraph>
-<paragraph role="paragraph" id="par_id3163137" xml-lang="en-US" l10n="U"
oldref="154">
-<emph>DataY</emph> represents the Y Data array.</paragraph>
-<paragraph role="paragraph" id="par_id3163155" xml-lang="en-US" l10n="U"
oldref="155">
-<emph>DataX</emph> (optional) represents the X Data array.</paragraph>
-<paragraph role="paragraph" id="par_id3163174" xml-lang="en-US" l10n="U"
oldref="156">
-<emph>FunctionType</emph> (optional). If Function_Type = 0, functions in the
form y = m^x will be calculated. Otherwise, y = b*m^x functions will be
calculated.</paragraph>
-<paragraph role="paragraph" id="par_id3163196" xml-lang="en-US" l10n="U"
oldref="157">
-<emph>Stats</emph> (optional). If Stats=0, only the regression coefficient is
calculated.</paragraph>
-<paragraph role="paragraph" id="par_idN118F7" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#optional"/>
-</paragraph>
+<paragraph role="heading" id="hd_id3146056" xml-lang="en-US" level="3"
l10n="U">Syntax</paragraph>
+<paragraph role="code" id="par_id3163123" xml-lang="en-US"
l10n="U">LOGEST(DataY; DataX; FunctionType; Stats)</paragraph>
+<paragraph role="paragraph" id="par_id3163137" xml-lang="en-US"
l10n="U"><emph>DataY</emph> represents the Y Data array.</paragraph>
+<paragraph role="paragraph" id="par_id3163155" xml-lang="en-US"
l10n="U"><emph>DataX</emph> (optional) represents the X Data array.</paragraph>
+<paragraph role="paragraph" id="par_id3163174" xml-lang="en-US"
l10n="U"><emph>FunctionType</emph> (optional). If Function_Type = 0, functions
in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be
calculated.</paragraph>
+<paragraph role="paragraph" id="par_id3163196" xml-lang="en-US"
l10n="U"><emph>Stats</emph> (optional). If Stats=0, only the regression
coefficient is calculated.</paragraph>
+<paragraph role="paragraph" id="par_idN118F7" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph>
<paragraph role="paragraph" id="par_idN11BC3" xml-lang="en-US" l10n="NEW">
<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
</paragraph>
-<paragraph role="heading" id="hd_id3163216" xml-lang="en-US" level="3"
l10n="U" oldref="158">Example</paragraph>
-<paragraph role="paragraph" id="par_id3163230" xml-lang="en-US" l10n="CHG"
oldref="159">See LINEST. However, no square sum will be returned.</paragraph>
+<paragraph role="heading" id="hd_id3163216" xml-lang="en-US" level="3"
l10n="U">Example</paragraph>
+<paragraph role="paragraph" id="par_id3163230" xml-lang="en-US" l10n="CHG">See
LINEST. However, no square sum will be returned.</paragraph>
</section>
<section id="Section6">
<bookmark xml-lang="en-US" branch="index" id="bm_id3163286">
@@ -1061,12 +887,11 @@ for bug #i31051#</comment></paragraph>
<bookmark_value>inner products</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMENPRODUKT"
id="bm_id3163297" localize="false"/>
-<paragraph role="heading" id="hd_id3163286" xml-lang="en-US" level="2"
l10n="U" oldref="161">SUMPRODUCT</paragraph>
-<paragraph role="paragraph" id="par_id3163314" xml-lang="en-US" l10n="U"
oldref="162"><ahelp hid="HID_FUNC_SUMMENPRODUKT">Multiplies corresponding
elements in the given arrays, and returns the sum of those
products.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3163334" xml-lang="en-US" level="3"
l10n="U" oldref="163">Syntax</paragraph>
-<paragraph role="code" id="par_id3163347" xml-lang="en-US" l10n="U"
oldref="164">SUMPRODUCT(Array1; Array2...Array30)</paragraph>
-<paragraph role="paragraph" id="par_id3163362" xml-lang="en-US" l10n="CHG"
oldref="165">
-<emph>Array1, Array2...Array30</emph> represent arrays whose corresponding
elements are to be multiplied.</paragraph>
+<paragraph role="heading" id="hd_id3163286" xml-lang="en-US" level="2"
l10n="U">SUMPRODUCT</paragraph>
+<paragraph role="paragraph" id="par_id3163314" xml-lang="en-US"
l10n="U"><ahelp hid="HID_FUNC_SUMMENPRODUKT">Multiplies corresponding elements
in the given arrays, and returns the sum of those products.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3163334" xml-lang="en-US" level="3"
l10n="U">Syntax</paragraph>
+<paragraph role="code" id="par_id3163347" xml-lang="en-US"
l10n="U">SUMPRODUCT(Array1; Array2...Array30)</paragraph>
+<paragraph role="paragraph" id="par_id3163362" xml-lang="en-US"
l10n="CHG"><emph>Array1, Array2...Array30</emph> represent arrays whose
corresponding elements are to be multiplied.</paragraph>
<paragraph role="paragraph" id="par_idN11B19" xml-lang="en-US" l10n="NEW">At
least one array must be part of the argument list. If only one array is given,
all array elements are summed.</paragraph>
<paragraph role="heading" id="par_idN11B1C" xml-lang="en-US" level="3"
l10n="NEW">Example</paragraph>
<table id="tbl_id6215704">
@@ -1091,24 +916,16 @@ for bug #i31051#</comment></paragraph>
<paragraph role="tablecontent" id="par_idN11B48" xml-lang="en-US"
l10n="NEW">1</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_idN11B4E" xml-lang="en-US" l10n="NEW">
-<item type="input">2</item>
-</paragraph>
+<paragraph role="tablecontent" id="par_idN11B4E" xml-lang="en-US"
l10n="NEW"><item type="input">2</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_idN11B54" xml-lang="en-US" l10n="NEW">
-<item type="input">3</item>
-</paragraph>
+<paragraph role="tablecontent" id="par_idN11B54" xml-lang="en-US"
l10n="NEW"><item type="input">3</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_idN11B5A" xml-lang="en-US" l10n="NEW">
-<item type="input">4</item>
-</paragraph>
+<paragraph role="tablecontent" id="par_idN11B5A" xml-lang="en-US"
l10n="NEW"><item type="input">4</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_idN11B60" xml-lang="en-US" l10n="NEW">
-<item type="input">5</item>
-</paragraph>
+<paragraph role="tablecontent" id="par_idN11B60" xml-lang="en-US"
l10n="NEW"><item type="input">5</item></paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -1116,24 +933,16 @@ for bug #i31051#</comment></paragraph>
<paragraph role="tablecontent" id="par_idN11B67" xml-lang="en-US"
l10n="NEW">2</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_idN11B6D" xml-lang="en-US" l10n="NEW">
-<item type="input">6</item>
-</paragraph>
+<paragraph role="tablecontent" id="par_idN11B6D" xml-lang="en-US"
l10n="NEW"><item type="input">6</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_idN11B73" xml-lang="en-US" l10n="NEW">
-<item type="input">7</item>
-</paragraph>
+<paragraph role="tablecontent" id="par_idN11B73" xml-lang="en-US"
l10n="NEW"><item type="input">7</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_idN11B79" xml-lang="en-US" l10n="NEW">
-<item type="input">8</item>
-</paragraph>
+<paragraph role="tablecontent" id="par_idN11B79" xml-lang="en-US"
l10n="NEW"><item type="input">8</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_idN11B7F" xml-lang="en-US" l10n="NEW">
-<item type="input">9</item>
-</paragraph>
+<paragraph role="tablecontent" id="par_idN11B7F" xml-lang="en-US"
l10n="NEW"><item type="input">9</item></paragraph>
</tablecell>
</tablerow>
<tablerow>
@@ -1141,112 +950,81 @@ for bug #i31051#</comment></paragraph>
<paragraph role="tablecontent" id="par_idN11B86" xml-lang="en-US"
l10n="NEW">3</paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_idN11B8C" xml-lang="en-US" l10n="NEW">
-<item type="input">10</item>
-</paragraph>
+<paragraph role="tablecontent" id="par_idN11B8C" xml-lang="en-US"
l10n="NEW"><item type="input">10</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_idN11B92" xml-lang="en-US" l10n="NEW">
-<item type="input">11</item>
-</paragraph>
+<paragraph role="tablecontent" id="par_idN11B92" xml-lang="en-US"
l10n="NEW"><item type="input">11</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_idN11B98" xml-lang="en-US" l10n="NEW">
-<item type="input">12</item>
-</paragraph>
+<paragraph role="tablecontent" id="par_idN11B98" xml-lang="en-US"
l10n="NEW"><item type="input">12</item></paragraph>
</tablecell>
<tablecell>
-<paragraph role="tablecontent" id="par_idN11B9E" xml-lang="en-US" l10n="NEW">
-<item type="input">13</item>
-</paragraph>
+<paragraph role="tablecontent" id="par_idN11B9E" xml-lang="en-US"
l10n="NEW"><item type="input">13</item></paragraph>
</tablecell>
</tablerow>
</table>
-<paragraph role="paragraph" id="par_idN11BA1" xml-lang="en-US" l10n="NEW">
-<item type="input">=SUMPRODUCT(A1:B3;C1:D3)</item> returns 397.</paragraph>
+<paragraph role="paragraph" id="par_idN11BA1" xml-lang="en-US"
l10n="NEW"><item type="input">=SUMPRODUCT(A1:B3;C1:D3)</item> returns
397.</paragraph>
<paragraph role="paragraph" id="par_idN11BA4" xml-lang="en-US"
l10n="NEW">Calculation: A1*C1 + B1*D1 + A2*C2 + B2*D2 + A3*C3 +
B3*D3</paragraph>
<paragraph role="paragraph" id="par_idN11BA7" xml-lang="en-US" l10n="NEW">You
can use SUMPRODUCT to calculate the scalar product of two vectors.</paragraph>
<paragraph role="note" id="par_idN11BBC" xml-lang="en-US"
l10n="NEW">SUMPRODUCT returns a single number, it is not necessary to enter the
function as an array function.</paragraph>
-<paragraph role="paragraph" id="par_idN11C91" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
-</paragraph>
+<paragraph role="paragraph" id="par_idN11C91" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph>
</section>
<section id="Section5">
<bookmark xml-lang="en-US" branch="index" id="bm_id3144842">
<bookmark_value>SUMX2MY2 function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEX2MY2"
id="bm_id3144854" localize="false"/>
-<paragraph role="heading" id="hd_id3144842" xml-lang="en-US" level="2"
l10n="U" oldref="169">SUMX2MY2</paragraph>
-<paragraph role="paragraph" id="par_id3144871" xml-lang="en-US" l10n="U"
oldref="170"><ahelp hid="HID_FUNC_SUMMEX2MY2">Returns the sum of the difference
of squares of corresponding values in two arrays.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3144889" xml-lang="en-US" level="3"
l10n="U" oldref="171">Syntax</paragraph>
-<paragraph role="code" id="par_id3144903" xml-lang="en-US" l10n="U"
oldref="172">SUMX2MY2(ArrayX; ArrayY)</paragraph>
-<paragraph role="paragraph" id="par_id3144916" xml-lang="en-US" l10n="U"
oldref="173">
-<emph>ArrayX</emph> represents the first array whose elements are to be
squared and added.</paragraph>
-<paragraph role="paragraph" id="par_id3144936" xml-lang="en-US" l10n="U"
oldref="174">
-<emph>ArrayY</emph> represents the second array whose elements are to be
squared and subtracted.</paragraph>
-<paragraph role="paragraph" id="par_idN11D6B" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
-</paragraph>
+<paragraph role="heading" id="hd_id3144842" xml-lang="en-US" level="2"
l10n="U">SUMX2MY2</paragraph>
+<paragraph role="paragraph" id="par_id3144871" xml-lang="en-US"
l10n="U"><ahelp hid="HID_FUNC_SUMMEX2MY2">Returns the sum of the difference of
squares of corresponding values in two arrays.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3144889" xml-lang="en-US" level="3"
l10n="U">Syntax</paragraph>
+<paragraph role="code" id="par_id3144903" xml-lang="en-US"
l10n="U">SUMX2MY2(ArrayX; ArrayY)</paragraph>
+<paragraph role="paragraph" id="par_id3144916" xml-lang="en-US"
l10n="U"><emph>ArrayX</emph> represents the first array whose elements are to
be squared and added.</paragraph>
+<paragraph role="paragraph" id="par_id3144936" xml-lang="en-US"
l10n="U"><emph>ArrayY</emph> represents the second array whose elements are to
be squared and subtracted.</paragraph>
+<paragraph role="paragraph" id="par_idN11D6B" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph>
</section>
<section id="Section4">
<bookmark xml-lang="en-US" branch="index" id="bm_id3145026">
<bookmark_value>SUMX2PY2 function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEX2PY2"
id="bm_id3145038" localize="false"/>
-<paragraph role="heading" id="hd_id3145026" xml-lang="en-US" level="2"
l10n="U" oldref="178">SUMX2PY2</paragraph>
-<paragraph role="paragraph" id="par_id3145055" xml-lang="en-US" l10n="U"
oldref="179"><ahelp hid="HID_FUNC_SUMMEX2PY2">Returns the sum of the sum of
squares of corresponding values in two arrays.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3163390" xml-lang="en-US" level="3"
l10n="U" oldref="180">Syntax</paragraph>
-<paragraph role="code" id="par_id3163404" xml-lang="en-US" l10n="U"
oldref="181">SUMX2PY2(ArrayX; ArrayY)</paragraph>
-<paragraph role="paragraph" id="par_id3163417" xml-lang="en-US" l10n="U"
oldref="182">
-<emph>ArrayX</emph> represents the first array whose arguments are to be
squared and added.</paragraph>
-<paragraph role="paragraph" id="par_id3163437" xml-lang="en-US" l10n="U"
oldref="183">
-<emph>ArrayY</emph> represents the second array, whose elements are to be
squared and added.</paragraph>
-<paragraph role="paragraph" id="par_idN11E45" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
-</paragraph>
+<paragraph role="heading" id="hd_id3145026" xml-lang="en-US" level="2"
l10n="U">SUMX2PY2</paragraph>
+<paragraph role="paragraph" id="par_id3145055" xml-lang="en-US"
l10n="U"><ahelp hid="HID_FUNC_SUMMEX2PY2">Returns the sum of the sum of squares
of corresponding values in two arrays.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3163390" xml-lang="en-US" level="3"
l10n="U">Syntax</paragraph>
+<paragraph role="code" id="par_id3163404" xml-lang="en-US"
l10n="U">SUMX2PY2(ArrayX; ArrayY)</paragraph>
+<paragraph role="paragraph" id="par_id3163417" xml-lang="en-US"
l10n="U"><emph>ArrayX</emph> represents the first array whose arguments are to
be squared and added.</paragraph>
+<paragraph role="paragraph" id="par_id3163437" xml-lang="en-US"
l10n="U"><emph>ArrayY</emph> represents the second array, whose elements are to
be squared and added.</paragraph>
+<paragraph role="paragraph" id="par_idN11E45" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph>
</section>
<section id="Section3">
<bookmark xml-lang="en-US" branch="index" id="bm_id3163527">
<bookmark_value>SUMXMY2 function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEXMY2"
id="bm_id3163539" localize="false"/>
-<paragraph role="heading" id="hd_id3163527" xml-lang="en-US" level="2"
l10n="U" oldref="187">SUMXMY2</paragraph>
-<paragraph role="paragraph" id="par_id3163556" xml-lang="en-US" l10n="U"
oldref="188"><ahelp hid="HID_FUNC_SUMMEXMY2">Adds the squares of the variance
between corresponding values in two arrays.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3163574" xml-lang="en-US" level="3"
l10n="U" oldref="189">Syntax</paragraph>
-<paragraph role="code" id="par_id3163588" xml-lang="en-US" l10n="U"
oldref="190">SUMXMY2(ArrayX; ArrayY)</paragraph>
-<paragraph role="paragraph" id="par_id3163601" xml-lang="en-US" l10n="U"
oldref="191">
-<emph>ArrayX</emph> represents the first array whose elements are to be
subtracted and squared.</paragraph>
-<paragraph role="paragraph" id="par_id3163621" xml-lang="en-US" l10n="U"
oldref="192">
-<emph>ArrayY</emph> represents the second array, whose elements are to be
subtracted and squared.</paragraph>
-<paragraph role="paragraph" id="par_idN11F1F" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
-</paragraph>
+<paragraph role="heading" id="hd_id3163527" xml-lang="en-US" level="2"
l10n="U">SUMXMY2</paragraph>
+<paragraph role="paragraph" id="par_id3163556" xml-lang="en-US"
l10n="U"><ahelp hid="HID_FUNC_SUMMEXMY2">Adds the squares of the variance
between corresponding values in two arrays.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3163574" xml-lang="en-US" level="3"
l10n="U">Syntax</paragraph>
+<paragraph role="code" id="par_id3163588" xml-lang="en-US"
l10n="U">SUMXMY2(ArrayX; ArrayY)</paragraph>
+<paragraph role="paragraph" id="par_id3163601" xml-lang="en-US"
l10n="U"><emph>ArrayX</emph> represents the first array whose elements are to
be subtracted and squared.</paragraph>
+<paragraph role="paragraph" id="par_id3163621" xml-lang="en-US"
l10n="U"><emph>ArrayY</emph> represents the second array, whose elements are to
be subtracted and squared.</paragraph>
+<paragraph role="paragraph" id="par_idN11F1F" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph>
</section>
<section id="Section2">
<bookmark xml-lang="en-US" branch="index" id="bm_id3166062">
<bookmark_value>TREND function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TREND" id="bm_id3166074"
localize="false"/>
-<paragraph role="heading" id="hd_id3166062" xml-lang="en-US" level="2"
l10n="U" oldref="196">TREND</paragraph>
-<paragraph role="paragraph" id="par_id3166091" xml-lang="en-US" l10n="U"
oldref="197"><ahelp hid="HID_FUNC_TREND">Returns values along a linear
trend.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3166109" xml-lang="en-US" level="3"
l10n="U" oldref="198">Syntax</paragraph>
-<paragraph role="code" id="par_id3166122" xml-lang="en-US" l10n="U"
oldref="199">TREND(DataY; DataX; NewDataX; LinearType)</paragraph>
-<paragraph role="paragraph" id="par_id3166137" xml-lang="en-US" l10n="U"
oldref="200">
-<emph>DataY</emph> represents the Y Data array.</paragraph>
-<paragraph role="paragraph" id="par_id3166156" xml-lang="en-US" l10n="U"
oldref="201">
-<emph>DataX</emph> (optional) represents the X Data array.</paragraph>
-<paragraph role="paragraph" id="par_id3166176" xml-lang="en-US" l10n="U"
oldref="202">
-<emph>NewDataX</emph> (optional) represents the array of the X data, which are
used for recalculating values.</paragraph>
-<paragraph role="paragraph" id="par_id3166196" xml-lang="en-US" l10n="U"
oldref="203">
-<emph>LinearType</emph>(Optional). If LinearType = 0, then lines will be
calculated through the zero point. Otherwise, offset lines will also be
calculated. The default is LinearType <> 0.</paragraph>
-<paragraph role="paragraph" id="par_idN11D2F" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#optional"/>
-</paragraph>
-<paragraph role="paragraph" id="par_idN12019" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
-</paragraph>
-<paragraph role="heading" id="hd_id3166231" xml-lang="en-US" level="3"
l10n="U" oldref="204">Example</paragraph>
-<paragraph role="paragraph" id="par_id3166245" xml-lang="en-US" l10n="U"
oldref="205">Select a spreadsheet range in which the trend data will appear.
Select the function. Enter the output data or select it with the mouse. Mark
the <emph>Array</emph> field. click <emph>OK</emph>. The trend data calculated
from the output data is displayed.</paragraph>
+<paragraph role="heading" id="hd_id3166062" xml-lang="en-US" level="2"
l10n="U">TREND</paragraph>
+<paragraph role="paragraph" id="par_id3166091" xml-lang="en-US"
l10n="U"><ahelp hid="HID_FUNC_TREND">Returns values along a linear
trend.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3166109" xml-lang="en-US" level="3"
l10n="U">Syntax</paragraph>
+<paragraph role="code" id="par_id3166122" xml-lang="en-US"
l10n="U">TREND(DataY; DataX; NewDataX; LinearType)</paragraph>
+<paragraph role="paragraph" id="par_id3166137" xml-lang="en-US"
l10n="U"><emph>DataY</emph> represents the Y Data array.</paragraph>
+<paragraph role="paragraph" id="par_id3166156" xml-lang="en-US"
l10n="U"><emph>DataX</emph> (optional) represents the X Data array.</paragraph>
+<paragraph role="paragraph" id="par_id3166176" xml-lang="en-US"
l10n="U"><emph>NewDataX</emph> (optional) represents the array of the X data,
which are used for recalculating values.</paragraph>
+<paragraph role="paragraph" id="par_id3166196" xml-lang="en-US"
l10n="U"><emph>LinearType</emph>(Optional). If LinearType = 0, then lines will
be calculated through the zero point. Otherwise, offset lines will also be
calculated. The default is LinearType <> 0.</paragraph>
+<paragraph role="paragraph" id="par_idN11D2F" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph>
+<paragraph role="paragraph" id="par_idN12019" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph>
+<paragraph role="heading" id="hd_id3166231" xml-lang="en-US" level="3"
l10n="U">Example</paragraph>
+<paragraph role="paragraph" id="par_id3166245" xml-lang="en-US"
l10n="U">Select a spreadsheet range in which the trend data will appear. Select
the function. Enter the output data or select it with the mouse. Mark the
<emph>Array</emph> field. click <emph>OK</emph>. The trend data calculated from
the output data is displayed.</paragraph>
</section>
<section id="Section1">
<bookmark xml-lang="en-US" branch="index" id="bm_id3166317">
@@ -1254,26 +1032,18 @@ for bug #i31051#</comment></paragraph>
<bookmark_value>exponential trends in arrays</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VARIATION"
id="bm_id3166329" localize="false"/>
-<paragraph role="heading" id="hd_id3166317" xml-lang="en-US" level="2"
l10n="U" oldref="207">GROWTH</paragraph>
-<paragraph role="paragraph" id="par_id3166346" xml-lang="en-US" l10n="U"
oldref="208"><ahelp hid="HID_FUNC_VARIATION">Calculates the points of an
exponential trend in an array.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3166364" xml-lang="en-US" level="3"
l10n="U" oldref="209">Syntax</paragraph>
-<paragraph role="code" id="par_id3166377" xml-lang="en-US" l10n="CHG"
oldref="210">GROWTH(DataY; DataX; NewDataX; FunctionType)</paragraph>
-<paragraph role="paragraph" id="par_id3166392" xml-lang="en-US" l10n="U"
oldref="211">
-<emph>DataY</emph> represents the Y Data array.</paragraph>
-<paragraph role="paragraph" id="par_id3166411" xml-lang="en-US" l10n="U"
oldref="212">
-<emph>DataX</emph> (optional) represents the X Data array.</paragraph>
-<paragraph role="paragraph" id="par_id3173797" xml-lang="en-US" l10n="U"
oldref="213">
-<emph>NewDataX</emph> (optional) represents the X data array, in which the
values are recalculated.</paragraph>
-<paragraph role="paragraph" id="par_id3173817" xml-lang="en-US" l10n="U"
oldref="214">
-<emph>FunctionType</emph>(optional). If FunctionType = 0, functions in the
form y = m^x will be calculated. Otherwise, y = b*m^x functions will be
calculated.</paragraph>
-<paragraph role="paragraph" id="par_idN11DFD" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#optional"/>
-</paragraph>
-<paragraph role="paragraph" id="par_idN12113" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#moreontop"/>
-</paragraph>
-<paragraph role="heading" id="hd_id3173839" xml-lang="en-US" level="3"
l10n="U" oldref="215">Example</paragraph>
-<paragraph role="paragraph" id="par_id3173852" xml-lang="en-US" l10n="U"
oldref="216">This function returns an array and is handled in the same way as
the other array functions. Select a range where you want the answers to appear
and select the function. Select DataY. Enter any other parameters, mark
<emph>Array</emph> and click <emph>OK</emph>.</paragraph>
+<paragraph role="heading" id="hd_id3166317" xml-lang="en-US" level="2"
l10n="U">GROWTH</paragraph>
+<paragraph role="paragraph" id="par_id3166346" xml-lang="en-US"
l10n="U"><ahelp hid="HID_FUNC_VARIATION">Calculates the points of an
exponential trend in an array.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3166364" xml-lang="en-US" level="3"
l10n="U">Syntax</paragraph>
+<paragraph role="code" id="par_id3166377" xml-lang="en-US"
l10n="CHG">GROWTH(DataY; DataX; NewDataX; FunctionType)</paragraph>
+<paragraph role="paragraph" id="par_id3166392" xml-lang="en-US"
l10n="U"><emph>DataY</emph> represents the Y Data array.</paragraph>
+<paragraph role="paragraph" id="par_id3166411" xml-lang="en-US"
l10n="U"><emph>DataX</emph> (optional) represents the X Data array.</paragraph>
+<paragraph role="paragraph" id="par_id3173797" xml-lang="en-US"
l10n="U"><emph>NewDataX</emph> (optional) represents the X data array, in which
the values are recalculated.</paragraph>
+<paragraph role="paragraph" id="par_id3173817" xml-lang="en-US"
l10n="U"><emph>FunctionType</emph>(optional). If FunctionType = 0, functions in
the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be
calculated.</paragraph>
+<paragraph role="paragraph" id="par_idN11DFD" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph>
+<paragraph role="paragraph" id="par_idN12113" xml-lang="en-US"
l10n="NEW"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph>
+<paragraph role="heading" id="hd_id3173839" xml-lang="en-US" level="3"
l10n="U">Example</paragraph>
+<paragraph role="paragraph" id="par_id3173852" xml-lang="en-US" l10n="U">This
function returns an array and is handled in the same way as the other array
functions. Select a range where you want the answers to appear and select the
function. Select DataY. Enter any other parameters, mark <emph>Array</emph> and
click <emph>OK</emph>.</paragraph>
</section>
</sort>
<section id="relatedtopics">
diff --git a/main/helpcontent2/source/text/shared/01/01160000.xhp
b/main/helpcontent2/source/text/shared/01/01160000.xhp
index dbefd10b2c..b7a0699e8e 100644
--- a/main/helpcontent2/source/text/shared/01/01160000.xhp
+++ b/main/helpcontent2/source/text/shared/01/01160000.xhp
@@ -31,13 +31,13 @@
<body>
<section id="senden">
<bookmark xml-lang="en-US" branch="hid/.uno:SendToMenu" id="bm_id2095095"
localize="false"/>
-<paragraph role="heading" id="hd_id3152895" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/shared/01/01160000.xhp"
name="Send">Send</link></paragraph>
-<paragraph role="paragraph" id="par_id3151262" xml-lang="en-US" l10n="CHG"
oldref="2"><ahelp hid=".">Sends a copy of the current document to different
applications.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3152895" xml-lang="en-US" level="1"
l10n="U"><link href="text/shared/01/01160000.xhp"
name="Send">Send</link></paragraph>
+<paragraph role="paragraph" id="par_id3151262" xml-lang="en-US"
l10n="CHG"><ahelp hid=".">Sends a copy of the current document to different
applications.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/shared/00/00000401.xhp#senden"/>
</section>
-<paragraph role="heading" id="hd_id3154398" xml-lang="en-US" level="2"
l10n="U" oldref="3"><link href="text/shared/01/01160200.xhp" name="Document as
E-mail">Document as E-mail</link></paragraph>
+<paragraph role="heading" id="hd_id3154398" xml-lang="en-US" level="2"
l10n="U"><link href="text/shared/01/01160200.xhp" name="Document as
E-mail">Document as E-mail</link></paragraph>
<embed href="text/shared/01/01160200.xhp#versendentext"/><comment>New menu
commands, see #i46895 and #i63793</comment><comment>UFI: New commands all have
the same Help IDs, but different names</comment>
<bookmark xml-lang="en-US" branch="hid/.uno:SendMailDocAsOOo" id="bm_id827967"
localize="false"/>
<paragraph role="paragraph" id="par_id4546342" xml-lang="en-US"
l10n="NEW"><ahelp hid="." visibility="hidden">Opens a new window in your
default e-mail program with the current document as an attachment. The
OpenDocument file format is used.</ahelp></paragraph>
@@ -67,13 +67,13 @@
<embed href="text/shared/01/ref_pdf_send_as.xhp#ref_pdf_send_as_text"/>
<switch select="appl">
<case select="WRITER"><comment>UFI: removed 2 help ids</comment>
-<paragraph role="heading" id="hd_id3155391" xml-lang="en-US" level="2"
l10n="U" oldref="5"><link href="text/shared/01/01160300.xhp" name="Create
Master Document">Create Master Document</link></paragraph>
+<paragraph role="heading" id="hd_id3155391" xml-lang="en-US" level="2"
l10n="U"><link href="text/shared/01/01160300.xhp" name="Create Master
Document">Create Master Document</link></paragraph>
<embed href="text/shared/01/01160300.xhp#globtext"/>
-<paragraph role="heading" id="hd_id3153345" xml-lang="en-US" level="2"
l10n="U" oldref="6"><link href="text/swriter/01/01160500.xhp" name="Create HTML
Document">Create HTML Document</link></paragraph>
+<paragraph role="heading" id="hd_id3153345" xml-lang="en-US" level="2"
l10n="U"><link href="text/swriter/01/01160500.xhp" name="Create HTML
Document">Create HTML Document</link></paragraph>
<embed href="text/swriter/01/01160500.xhp#htmltext"/>
<embed href="text/swriter/01/01160100.xhp#sendenstarimpress"/>
<embed href="text/swriter/01/01160200.xhp#sendenclipboard"/>
-<paragraph role="heading" id="hd_id3149811" xml-lang="en-US" level="2"
l10n="U" oldref="4"><link href="text/swriter/01/01160300.xhp" name="Create
AutoAbstract">Create AutoAbstract</link></paragraph>
+<paragraph role="heading" id="hd_id3149811" xml-lang="en-US" level="2"
l10n="U"><link href="text/swriter/01/01160300.xhp" name="Create
AutoAbstract">Create AutoAbstract</link></paragraph>
<embed href="text/swriter/01/01160300.xhp#autoabstracttext"/>
<embed href="text/swriter/01/01160400.xhp#sendenpraeser"/>
</case>
diff --git a/main/helpcontent2/source/text/shared/autopi/01130200.xhp
b/main/helpcontent2/source/text/shared/autopi/01130200.xhp
index e3b02708fc..583142f9fb 100644
--- a/main/helpcontent2/source/text/shared/autopi/01130200.xhp
+++ b/main/helpcontent2/source/text/shared/autopi/01130200.xhp
@@ -30,43 +30,43 @@
</meta>
<body>
<section id="seite2">
-<paragraph role="heading" id="hd_id3149748" xml-lang="en-US" level="1"
l10n="U" oldref="1"><link href="text/shared/autopi/01130200.xhp" name="Document
converter continuation pages">Document converter continuation
pages</link></paragraph>
-<paragraph role="paragraph" id="par_id3147143" xml-lang="en-US" l10n="U"
oldref="2">Specifies, for each template type and document type, the directory
to be read from and the directory to be written to.</paragraph>
+<paragraph role="heading" id="hd_id3149748" xml-lang="en-US" level="1"
l10n="U"><link href="text/shared/autopi/01130200.xhp" name="Document converter
continuation pages">Document converter continuation pages</link></paragraph>
+<paragraph role="paragraph" id="par_id3147143" xml-lang="en-US"
l10n="U">Specifies, for each template type and document type, the directory to
be read from and the directory to be written to.</paragraph>
</section>
<section id="howtoget">
<embed href="text/shared/00/00000401.xhp#autopilotmsimport2"/>
</section>
-<paragraph role="heading" id="hd_id3156027" xml-lang="en-US" level="2"
l10n="U" oldref="4">Templates</paragraph>
-<paragraph role="paragraph" id="par_id3153681" xml-lang="en-US" l10n="U"
oldref="14">Determines whether templates are to be converted, and how they are
converted.</paragraph>
+<paragraph role="heading" id="hd_id3156027" xml-lang="en-US" level="2"
l10n="U">Templates</paragraph>
+<paragraph role="paragraph" id="par_id3153681" xml-lang="en-US"
l10n="U">Determines whether templates are to be converted, and how they are
converted.</paragraph>
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGIMPORT_2_CBTEMPLATE"
id="bm_id3145211" localize="false"/>
-<paragraph role="heading" id="hd_id3146957" xml-lang="en-US" level="3"
l10n="U" oldref="15">Text templates</paragraph>
-<paragraph role="paragraph" id="par_id3153345" xml-lang="en-US" l10n="U"
oldref="16">Note that the "Text templates" label can change, depending on the
selections from the previous page. For example, if Microsoft Word documents
have been selected, the label reads "Word templates".</paragraph>
-<paragraph role="paragraph" id="par_id3149182" xml-lang="en-US" l10n="U"
oldref="17"><ahelp hid="HID_DLGIMPORT_2_CBTEMPLATE">Specifies that templates
are to be converted.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3146957" xml-lang="en-US" level="3"
l10n="U">Text templates</paragraph>
+<paragraph role="paragraph" id="par_id3153345" xml-lang="en-US" l10n="U">Note
that the "Text templates" label can change, depending on the selections from
the previous page. For example, if Microsoft Word documents have been selected,
the label reads "Word templates".</paragraph>
+<paragraph role="paragraph" id="par_id3149182" xml-lang="en-US"
l10n="U"><ahelp hid="HID_DLGIMPORT_2_CBTEMPLATE">Specifies that templates are
to be converted.</ahelp></paragraph>
<section id="double">
<bookmark xml-lang="en-US"
branch="hid/WIZARDS_HID_DLGIMPORT_2_CBTEMPLATERECURSE" id="bm_id3154749"
localize="false"/>
<bookmark xml-lang="en-US"
branch="hid/WIZARDS_HID_DLGIMPORT_2_CBDOCUMENTRECURSE" id="bm_id3149399"
localize="false"/>
-<paragraph role="heading" id="hd_id3153683" xml-lang="en-US" level="3"
l10n="U" oldref="18">Including subdirectories</paragraph>
-<paragraph role="paragraph" id="par_id3149811" xml-lang="en-US" l10n="U"
oldref="19"><ahelp hid="HID_DLGIMPORT_2_CBDOCUMENTRECURSE">Indicates that the
subdirectories of the selected directory are also searched for matching
files.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3153683" xml-lang="en-US" level="3"
l10n="U">Including subdirectories</paragraph>
+<paragraph role="paragraph" id="par_id3149811" xml-lang="en-US"
l10n="U"><ahelp hid="HID_DLGIMPORT_2_CBDOCUMENTRECURSE">Indicates that the
subdirectories of the selected directory are also searched for matching
files.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGIMPORT_2_LBTEMPLATEPATH"
id="bm_id3150771" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGIMPORT_2_LBDOCUMENTPATH"
id="bm_id3153666" localize="false"/>
-<paragraph role="heading" id="hd_id3159269" xml-lang="en-US" level="3"
l10n="U" oldref="20">Import from</paragraph>
-<paragraph role="paragraph" id="par_id3153821" xml-lang="en-US" l10n="U"
oldref="21"><ahelp hid="HID_DLGIMPORT_2_LBDOCUMENTPATH">Specifies the directory
containing the source files.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3159269" xml-lang="en-US" level="3"
l10n="U">Import from</paragraph>
+<paragraph role="paragraph" id="par_id3153821" xml-lang="en-US"
l10n="U"><ahelp hid="HID_DLGIMPORT_2_LBDOCUMENTPATH">Specifies the directory
containing the source files.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGIMPORT_2_EDTEMPLATEPATH"
id="bm_id3154285" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGIMPORT_2_EDDOCUMENTPATH"
id="bm_id3155421" localize="false"/>
-<paragraph role="heading" id="hd_id3149732" xml-lang="en-US" level="3"
l10n="U" oldref="22">Save to</paragraph>
-<paragraph role="paragraph" id="par_id3155449" xml-lang="en-US" l10n="U"
oldref="23"><ahelp hid="HID_DLGIMPORT_2_EDDOCUMENTPATH">Specifies the directory
to which the destination files are written.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3149732" xml-lang="en-US" level="3"
l10n="U">Save to</paragraph>
+<paragraph role="paragraph" id="par_id3155449" xml-lang="en-US"
l10n="U"><ahelp hid="HID_DLGIMPORT_2_EDDOCUMENTPATH">Specifies the directory to
which the destination files are written.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/WIZARDS_HID_DLGIMPORT_2_CMDTEMPLATEPATHSELECT" id="bm_id3159400"
localize="false"/>
<bookmark xml-lang="en-US"
branch="hid/WIZARDS_HID_DLGIMPORT_2_CMDDOCUMENTPATHSELECT" id="bm_id3149786"
localize="false"/>
-<paragraph role="heading" id="hd_id3153126" xml-lang="en-US" level="3"
l10n="U" oldref="24">...</paragraph>
-<paragraph role="paragraph" id="par_id3155388" xml-lang="en-US" l10n="U"
oldref="25"><ahelp hid="HID_DLGIMPORT_2_CMDDOCUMENTPATHSELECT">Opens a dialog
to select the desired path.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3153126" xml-lang="en-US" level="3"
l10n="U">...</paragraph>
+<paragraph role="paragraph" id="par_id3155388" xml-lang="en-US"
l10n="U"><ahelp hid="HID_DLGIMPORT_2_CMDDOCUMENTPATHSELECT">Opens a dialog to
select the desired path.</ahelp></paragraph>
</section>
-<paragraph role="heading" id="hd_id3149416" xml-lang="en-US" level="2"
l10n="U" oldref="26">Documents</paragraph>
-<paragraph role="paragraph" id="par_id3159176" xml-lang="en-US" l10n="U"
oldref="27">Determines whether and how documents are converted.</paragraph>
+<paragraph role="heading" id="hd_id3149416" xml-lang="en-US" level="2"
l10n="U">Documents</paragraph>
+<paragraph role="paragraph" id="par_id3159176" xml-lang="en-US"
l10n="U">Determines whether and how documents are converted.</paragraph>
<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGIMPORT_2_CBDOCUMENT"
id="bm_id3153146" localize="false"/>
-<paragraph role="heading" id="hd_id3149236" xml-lang="en-US" level="3"
l10n="U" oldref="28">Text documents</paragraph>
-<paragraph role="paragraph" id="par_id3148564" xml-lang="en-US" l10n="U"
oldref="29">Note that the "Text documents" label can change, depending on the
selections from the previous page. For example, if Microsoft Word documents
have been selected, the label reads "Word documents".</paragraph>
-<paragraph role="paragraph" id="par_id3148944" xml-lang="en-US" l10n="U"
oldref="30"><ahelp hid="HID_DLGIMPORT_2_CBDOCUMENT">Indicates that the
documents are to be converted.</ahelp></paragraph>
+<paragraph role="heading" id="hd_id3149236" xml-lang="en-US" level="3"
l10n="U">Text documents</paragraph>
+<paragraph role="paragraph" id="par_id3148564" xml-lang="en-US" l10n="U">Note
that the "Text documents" label can change, depending on the selections from
the previous page. For example, if Microsoft Word documents have been selected,
the label reads "Word documents".</paragraph>
+<paragraph role="paragraph" id="par_id3148944" xml-lang="en-US"
l10n="U"><ahelp hid="HID_DLGIMPORT_2_CBDOCUMENT">Indicates that the documents
are to be converted.</ahelp></paragraph>
<embed href="text/shared/autopi/01130200.xhp#double"/>
-<paragraph role="paragraph" id="par_id3156344" xml-lang="en-US" l10n="U"
oldref="13">Here you can return to the main page of the <link
href="text/shared/autopi/01130000.xhp" name="Document Converter">Document
Converter Wizard</link>.</paragraph>
+<paragraph role="paragraph" id="par_id3156344" xml-lang="en-US" l10n="U">Here
you can return to the main page of the <link
href="text/shared/autopi/01130000.xhp" name="Document Converter">Document
Converter Wizard</link>.</paragraph>
</body>
</helpdocument>
