source/text/scalc/01/04060104.xhp | 4 ++--
source/text/scalc/01/04060105.xhp | 1 +
source/text/scalc/01/04060106.xhp | 13 +++++++------
source/text/scalc/01/04060110.xhp | 8 ++++----
source/text/scalc/01/04060115.xhp | 4 ++--
source/text/scalc/01/04060120.xhp | 5 +++++
source/text/scalc/01/04060181.xhp | 20 ++++++++++----------
source/text/scalc/01/04060182.xhp | 10 ++++++++++
source/text/scalc/01/04060183.xhp | 6 ++++++
source/text/scalc/01/04060184.xhp | 12 ++++++++++++
source/text/scalc/01/04060185.xhp | 15 +++++++++++++++
source/text/scalc/01/func_aggregate.xhp | 2 +-
source/text/scalc/01/func_averageif.xhp | 1 +
source/text/scalc/01/func_averageifs.xhp | 1 +
source/text/scalc/01/func_countifs.xhp | 1 +
source/text/scalc/01/func_datedif.xhp | 1 +
source/text/scalc/01/func_error_type.xhp | 2 +-
source/text/scalc/01/func_forecastetsadd.xhp | 2 +-
source/text/scalc/01/func_forecastetsmult.xhp | 2 +-
source/text/scalc/01/func_forecastetspiadd.xhp | 2 +-
source/text/scalc/01/func_forecastetspimult.xhp | 2 +-
source/text/scalc/01/func_forecastetsseason.xhp | 2 +-
source/text/scalc/01/func_forecastetsstatadd.xhp | 2 +-
source/text/scalc/01/func_forecastetsstatmult.xhp | 2 +-
source/text/scalc/01/func_imcosh.xhp | 1 +
source/text/scalc/01/func_imcot.xhp | 1 +
source/text/scalc/01/func_imcsc.xhp | 1 +
source/text/scalc/01/func_imcsch.xhp | 1 +
source/text/scalc/01/func_imsec.xhp | 1 +
source/text/scalc/01/func_imsech.xhp | 1 +
source/text/scalc/01/func_imsinh.xhp | 1 +
source/text/scalc/01/func_imtan.xhp | 1 +
source/text/scalc/01/func_isoweeknum.xhp | 1 +
source/text/scalc/01/func_maxifs.xhp | 2 +-
source/text/scalc/01/func_minifs.xhp | 2 +-
source/text/scalc/01/func_networkdays.intl.xhp | 1 +
source/text/scalc/01/func_numbervalue.xhp | 1 +
source/text/scalc/01/func_rawsubtract.xhp | 1 +
source/text/scalc/01/func_roundsig.xhp | 1 +
source/text/scalc/01/func_skewp.xhp | 1 +
source/text/scalc/01/func_sumifs.xhp | 2 +-
source/text/scalc/01/func_webservice.xhp | 3 +++
source/text/scalc/01/func_workday.intl.xhp | 2 +-
43 files changed, 108 insertions(+), 37 deletions(-)
New commits:
commit 0a874cee4a5d694b6c055b896d4dc64f7151b001
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Thu Apr 25 17:53:14 2019 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sat Apr 27 13:59:57 2019 +0200
tdf#123803 Add release info in Calc functions
Change-Id: I0476c79fe5407c3e7252ef16da4110a026b29fa8
Note: some Calc functions still lack help pages.
Reviewed-on: https://gerrit.libreoffice.org/71331
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060104.xhp
b/source/text/scalc/01/04060104.xhp
index db7bb6c02..a7d70bd22 100644
--- a/source/text/scalc/01/04060104.xhp
+++ b/source/text/scalc/01/04060104.xhp
@@ -338,7 +338,7 @@
<paragraph id="hd_id31470811" role="heading" level="2"
xml-lang="en-US">IFERROR</paragraph>
<paragraph id="par_id31563161" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_IFERROR">Returns the value if the cell does not contains an error
value, or the alternative value if it does.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id31531551" role="code"
xml-lang="en-US">IFERROR(Value;Alternate_value)</paragraph>
<paragraph id="par_id31540471" role="paragraph"
xml-lang="en-US"><emph>Value</emph> is the value or expression to be returned
if it is not equal or results in an error.</paragraph>
@@ -508,7 +508,7 @@
<paragraph id="hd_id31536851" role="heading" level="2"
xml-lang="en-US">IFNA</paragraph>
<paragraph id="par_id31491051" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_IFNA">Returns the value if the cell does not contains the #N/A
(value not available) error value, or the alternative value if it
does.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id31537481" role="code"
xml-lang="en-US">IFNA(Value;Alternate_value)</paragraph>
<paragraph id="par_id31528841" role="paragraph"
xml-lang="en-US"><emph>Value</emph> is the value or expression to be returned
if it is not equal or results in an #N/A error.</paragraph>
diff --git a/source/text/scalc/01/04060105.xhp
b/source/text/scalc/01/04060105.xhp
index 63c8289ec..97c212d50 100644
--- a/source/text/scalc/01/04060105.xhp
+++ b/source/text/scalc/01/04060105.xhp
@@ -165,6 +165,7 @@
<paragraph xml-lang="en-US" id="hd_id3156257" role="heading"
level="2">XOR</paragraph>
<paragraph xml-lang="en-US" id="par_id3155987"
role="paragraph"><ahelp hid="HID_FUNC_XOR">Returns true if an odd number of
arguments evaluates to TRUE.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id3148772" role="paragraph">The
arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7,
B8<10) that return logical values, or arrays (A1:C3) containing logical
values.</paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3150469"
role="code">XOR(LogicalValue1; LogicalValue2 ...LogicalValue30)</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index c2f40d1c8..68631cebc 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -355,7 +355,7 @@
<paragraph id="hd_id9523234" role="heading" level="2"
xml-lang="en-US">CSC</paragraph>
<paragraph id="par_id4896433" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_COSECANT">Returns the cosecant of the given angle (in radians).
The cosecant of an angle is equivalent to 1 divided by the sine of that
angle</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id4571344" role="code"
xml-lang="en-US">CSC(Number)</paragraph>
<paragraph id="par_id9859164" role="paragraph" xml-lang="en-US">Returns the
(trigonometric) cosecant of <emph>Number</emph>, the angle in
radians.</paragraph>
@@ -376,7 +376,7 @@
<paragraph id="hd_id4325650" role="heading" level="2"
xml-lang="en-US">CSCH</paragraph>
<paragraph id="par_id579916" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_COSECANTHYP">Returns the hyperbolic cosecant of a
number.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3108851" role="code"
xml-lang="en-US">CSCH(Number)</paragraph>
<paragraph id="par_id1394188" role="paragraph" xml-lang="en-US">Returns the
hyperbolic cosecant of <emph>Number</emph>.</paragraph>
@@ -730,7 +730,7 @@
<paragraph id="hd_id2952518" role="heading" level="2"
xml-lang="en-US">CEILING.PRECISE</paragraph>
<paragraph id="par_id2953422" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_CEIL_MS">Rounds a number up to the nearest multiple of
Significance, regardless of sign of Significance</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2953454" role="code"
xml-lang="en-US">CEILING.PRECISE(Number; Significance)</paragraph>
<paragraph id="par_id2953467" role="paragraph"
xml-lang="en-US"><emph>Number</emph> (required) is the number that is to be
rounded up.</paragraph>
@@ -765,6 +765,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_MS"
id="bm_id221516998652517" localize="false"/>
<paragraph role="heading" id="hd_id411516998838823" level="2"
xml-lang="en-US">CEILING.XCL</paragraph>
<paragraph role="paragraph" id="par_id811516998845826"
xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MS">Rounds a number away from zero
to the nearest multiple of Significance.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#5.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id251516998856873"
xml-lang="en-US">CEILING.XCL(Number; Significance)</paragraph>
<paragraph role="paragraph" id="par_id671516998874263"
xml-lang="en-US"><emph>Number</emph> is the number that is to be
rounded.</paragraph>
@@ -1052,7 +1053,7 @@
<paragraph id="hd_id5187204" role="heading" level="2"
xml-lang="en-US">SEC</paragraph>
<paragraph id="par_id9954962" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_SECANT">Returns the secant of the given angle (in radians). The
secant of an angle is equivalent to 1 divided by the cosine of that
angle</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2055913" role="code"
xml-lang="en-US">SEC(Number)</paragraph>
<paragraph id="par_id9568170" role="paragraph" xml-lang="en-US">Returns the
(trigonometric) secant of <emph>Number</emph>, the angle in radians.</paragraph>
@@ -1073,7 +1074,7 @@
<paragraph id="hd_id8661934" role="heading" level="2"
xml-lang="en-US">SECH</paragraph>
<paragraph id="par_id408174" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_SECANTHYP">Returns the hyperbolic secant of a
number.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id4985391" role="code"
xml-lang="en-US">SECH(Number)</paragraph>
<paragraph id="par_id1952124" role="paragraph" xml-lang="en-US">Returns the
hyperbolic secant of <emph>Number</emph>.</paragraph>
@@ -1545,7 +1546,7 @@
<paragraph id="hd_id2957404" role="heading" level="2"
xml-lang="en-US">FLOOR.PRECISE</paragraph>
<paragraph id="par_id2957432" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_FLOOR_MS">Rounds a number down to the nearest multiple of
Significance, regardless of sign of Significance</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2957464" role="code"
xml-lang="en-US">FLOOR.PRECISE(Number; Significance)</paragraph>
<paragraph id="par_id2957478" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded
down.</paragraph>
diff --git a/source/text/scalc/01/04060110.xhp
b/source/text/scalc/01/04060110.xhp
index c582ffc30..31722b8cf 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -351,7 +351,7 @@
<paragraph id="hd_id2947083" role="heading" level="2"
xml-lang="en-US">LEFTB</paragraph>
<paragraph id="par_id2953622" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_LEFTB">Returns the first characters of a DBCS
text.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2946786" role="code" xml-lang="en-US">LEFTB("Text";
Number_bytes)</paragraph>
<paragraph id="par_id2947274" role="paragraph"
xml-lang="en-US"><emph>Text</emph> is the text where the initial partial words
are to be determined.</paragraph>
@@ -393,7 +393,7 @@
<paragraph id="hd_id2956110" role="heading" level="2"
xml-lang="en-US">LENB</paragraph>
<paragraph id="par_id2950147" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_LENB">For double-byte character set (DBCS) languages, returns the
number of bytes used to represent the characters in a text
string.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2954063" role="code"
xml-lang="en-US">LENB("Text")</paragraph>
<paragraph id="par_id2946894" role="paragraph"
xml-lang="en-US"><emph>Text</emph> is the text whose length is to be
determined.</paragraph>
@@ -453,7 +453,7 @@
<paragraph id="hd_id2954589" role="heading" level="2"
xml-lang="en-US">MIDB</paragraph>
<paragraph id="par_id2954938" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_MIDB">Returns a text string of a DBCS text. The parameters
specify the starting position and the number of characters.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2950526" role="code" xml-lang="en-US">MIDB("Text"; Start;
Number_bytes)</paragraph>
<paragraph id="par_id2948820" role="paragraph"
xml-lang="en-US"><emph>Text</emph> is the text containing the characters to
extract.</paragraph>
@@ -566,7 +566,7 @@
<paragraph id="hd_id2949805" role="heading" level="2"
xml-lang="en-US">RIGHTB</paragraph>
<paragraph id="par_id2945375" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_RIGHTB">Returns the last character or characters of a text with
double bytes characters sets (DBCS).</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2954344" role="code" xml-lang="en-US">RIGHTB("Text";
Number_bytes)</paragraph>
<paragraph id="par_id2949426" role="paragraph"
xml-lang="en-US"><emph>Text</emph> is the text of which the right part is to be
determined.</paragraph>
diff --git a/source/text/scalc/01/04060115.xhp
b/source/text/scalc/01/04060115.xhp
index 9506f99b5..ba44e34a2 100644
--- a/source/text/scalc/01/04060115.xhp
+++ b/source/text/scalc/01/04060115.xhp
@@ -279,7 +279,7 @@
<paragraph id="hd_id2983446" role="heading" level="2"
xml-lang="en-US">ERF.PRECISE</paragraph>
<paragraph id="par_id2950381" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_ERF_MS">Returns values of the Gaussian error integral between 0
and the given limit.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2963824" role="code"
xml-lang="en-US">ERF.PRECISE(LowerLimit)</paragraph>
<paragraph id="par_id2949715" role="paragraph"
xml-lang="en-US"><emph>LowerLimit</emph> is the limit of the integral. The
calculation takes place between 0 and this limit.</paragraph>
@@ -315,7 +315,7 @@
<paragraph id="hd_id2945082" role="heading" level="2"
xml-lang="en-US">ERFC.PRECISE</paragraph>
<paragraph id="par_id2949453" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_ERFC_MS">Returns complementary values of the Gaussian error
integral between x and infinity.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2953220" role="code"
xml-lang="en-US">ERFC.PRECISE(LowerLimit)</paragraph>
<paragraph id="par_id2947620" role="paragraph" xml-lang="en-US">
<emph>LowerLimit</emph> is the lower limit of the integral</paragraph>
diff --git a/source/text/scalc/01/04060120.xhp
b/source/text/scalc/01/04060120.xhp
index 7d8f448e8..0a22215b9 100644
--- a/source/text/scalc/01/04060120.xhp
+++ b/source/text/scalc/01/04060120.xhp
@@ -49,6 +49,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BITAND" id="bm_id4145827"
localize="false"/>
<paragraph role="heading" id="hd_id4150026" xml-lang="en-US"
level="2">BITAND</paragraph>
<paragraph role="paragraph" id="par_id4146942" xml-lang="en-US"><ahelp
hid="HID_FUNC_BITAND">Returns a bitwise logical "and" of the
parameters.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id4146878" xml-lang="en-US">BITAND(number1;
number2)</paragraph>
<paragraph role="paragraph" id="par_id4151228" xml-lang="en-US">
@@ -63,6 +64,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BITOR" id="bm_id4148754"
localize="false"/>
<paragraph role="heading" id="hd_id4146139" xml-lang="en-US"
level="2">BITOR</paragraph>
<paragraph role="paragraph" id="par_id4150140" xml-lang="en-US"><ahelp
hid="HID_FUNC_BITOR">Returns a bitwise logical "or" of the
parameters.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id4148733" xml-lang="en-US">BITOR(number1;
number2)</paragraph>
<paragraph role="paragraph" id="par_id4150864" xml-lang="en-US">
@@ -76,6 +78,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BITXOR" id="bm_id4154330"
localize="false"/>
<paragraph role="heading" id="hd_id4150019" xml-lang="en-US"
level="2">BITXOR</paragraph>
<paragraph role="paragraph" id="par_id4145246" xml-lang="en-US"><ahelp
hid="HID_FUNC_BITXOR">Returns a bitwise logical "exclusive or" of the
parameters.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id4157970" xml-lang="en-US">BITXOR(number1;
number2)</paragraph>
<paragraph role="paragraph" id="par_id4145302" xml-lang="en-US">
@@ -90,6 +93,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BITLSHIFT"
id="bm_id4148593" localize="false"/>
<paragraph role="heading" id="hd_id4155370" xml-lang="en-US"
level="2">BITLSHIFT</paragraph>
<paragraph role="paragraph" id="par_id4158411" xml-lang="en-US"><ahelp
hid="HID_FUNC_BITLSHIFT">Shifts a number left by n bits.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id4147536" xml-lang="en-US">BITLSHIFT(number;
shift)</paragraph>
<paragraph role="paragraph" id="par_id4150475" xml-lang="en-US">
@@ -106,6 +110,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BITRSHIFT"
id="bm_id4154312" localize="false"/>
<paragraph role="heading" id="hd_id4083280" xml-lang="en-US"
level="2">BITRSHIFT</paragraph>
<paragraph role="paragraph" id="par_id4152482" xml-lang="en-US"><ahelp
hid="HID_FUNC_BITRSHIFT">Shifts a number right by n bits.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#3.5"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id4145087" xml-lang="en-US">BITRSHIFT(number;
shift)</paragraph>
<paragraph role="paragraph" id="par_id4149277" xml-lang="en-US">
diff --git a/source/text/scalc/01/04060181.xhp
b/source/text/scalc/01/04060181.xhp
index ec6c2ee6a..bc016f6fc 100644
--- a/source/text/scalc/01/04060181.xhp
+++ b/source/text/scalc/01/04060181.xhp
@@ -225,7 +225,7 @@
<paragraph id="hd_id2945620" role="heading" level="2"
xml-lang="en-US">BETA.INV</paragraph>
<paragraph id="par_id2949825" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_BETAINV_MS">Returns the inverse of the cumulative beta
probability density function.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2956300" role="code" xml-lang="en-US">BETA.INV(Number;
Alpha; Beta; Start; End)</paragraph>
<paragraph id="par_id2949266" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the value between <emph>Start</emph>
and <emph>End</emph> at which to evaluate the function.</paragraph>
@@ -274,7 +274,7 @@
<paragraph id="hd_id2956096" role="heading" level="2"
xml-lang="en-US">BETA.DIST</paragraph>
<paragraph id="par_id2950880" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_BETADIST_MS">Returns the beta function.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2947571" role="code" xml-lang="en-US">BETA.DIST(Number;
Alpha; Beta; Cumulative; Start; End)</paragraph>
<paragraph id="par_id2956317" role="paragraph"
xml-lang="en-US"><emph>Number</emph> (required) is the value between
<emph>Start</emph> and <emph>End</emph> at which to evaluate the
function.</paragraph>
@@ -321,7 +321,7 @@
<paragraph id="hd_id2943228" role="heading" level="2"
xml-lang="en-US">BINOM.DIST</paragraph>
<paragraph id="par_id2946897" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_BINOM_DIST_MS">Returns the individual term binomial distribution
probability.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2956009" role="code" xml-lang="en-US">BINOM.DIST(X;
Trials; SP; C)</paragraph>
<paragraph id="par_id2954304" role="paragraph" xml-lang="en-US"><emph>X</emph>
is the number of successes in a set of trials.</paragraph>
@@ -343,7 +343,7 @@
<paragraph id="hd_id2843228" role="heading" level="2"
xml-lang="en-US">BINOM.INV</paragraph>
<paragraph id="par_id2846897" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_BINOM_INV_MS">Returns the smallest value for which the cumulative
binomial distribution is greater than or equal to a criterion
value.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2856009" role="code" xml-lang="en-US">BINOM.INV(Trials;
SP; Alpha)</paragraph>
<paragraph id="par_id2847492" role="paragraph"
xml-lang="en-US"><emph>Trials</emph> The total number of trials.</paragraph>
@@ -378,7 +378,7 @@
<paragraph id="hd_id2919200902421451" role="heading" level="2"
xml-lang="en-US">CHISQ.INV</paragraph>
<paragraph id="par_id2919200902421449" role="paragraph"
xml-lang="en-US"><ahelp hid="HID_FUNC_CHISQINV_MS">Returns the inverse of the
left-tailed probability of the chi-square distribution.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id1150504" role="code"
xml-lang="en-US">CHISQ.INV(Probability; DegreesFreedom)</paragraph>
<paragraph id="par_id2919200902475286" role="paragraph"
xml-lang="en-US"><emph>Probability</emph> is the probability value for which
the inverse of the chi-square distribution is to be calculated.</paragraph>
@@ -421,7 +421,7 @@
<paragraph id="hd_id2948835" role="heading" level="2"
xml-lang="en-US">CHISQ.INV.RT</paragraph>
<paragraph id="par_id2949906" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_CHIINV_MS">Returns the inverse of the one-tailed probability of
the chi-squared distribution.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2950504" role="code"
xml-lang="en-US">CHISQ.INV.RT(Number; DegreesFreedom)</paragraph>
<paragraph id="par_id2954898" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the value of the error
probability.</paragraph>
@@ -546,7 +546,7 @@
<paragraph id="hd_id2954260" role="heading" level="2"
xml-lang="en-US">CHISQ.TEST</paragraph>
<paragraph id="par_id2951052" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_CHITEST_MS">Returns the probability of a deviance from a random
distribution of two test series based on the chi-squared test for
independence.</ahelp> CHISQ.TEST returns the chi-squared distribution of the
data.</paragraph>
<paragraph id="par_id2948925" role="paragraph" xml-lang="en-US">The
probability determined by CHISQ.TEST can also be determined with CHISQ.DIST, in
which case the Chi square of the random sample must then be passed as a
parameter instead of the data row.</paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2949162" role="code" xml-lang="en-US">CHISQ.TEST(DataB;
DataE)</paragraph>
<paragraph id="par_id2958421" role="paragraph"
xml-lang="en-US"><emph>DataB</emph> is the array of the
observations.</paragraph>
@@ -666,7 +666,7 @@
<paragraph id="hd_id2848690" role="heading" level="2"
xml-lang="en-US">CHISQ.DIST</paragraph>
<paragraph id="par_id2856338" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_CHISQDIST_MS">Returns the probability density function or the
cumulative distribution function for the chi-square
distribution.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2858439" role="code" xml-lang="en-US">CHISQ.DIST(Number;
DegreesFreedom; Cumulative)</paragraph>
<paragraph id="par_id2848675" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the chi-square value of the random
sample used to determine the error probability.</paragraph>
@@ -688,7 +688,7 @@
<paragraph id="hd_id2948690" role="heading" level="2"
xml-lang="en-US">CHISQ.DIST.RT</paragraph>
<paragraph id="par_id2956338" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_CHIVERT_MS">Returns the probability value from the indicated Chi
square that a hypothesis is confirmed.</ahelp> CHISQ.DIST.RT compares the Chi
square value to be given for a random sample that is calculated from the sum of
(observed value-expected value)^2/expected value for all values with the
theoretical Chi square distribution and determines from this the probability of
error for the hypothesis to be tested.</paragraph>
<paragraph id="par_id2951316" role="paragraph" xml-lang="en-US">The
probability determined by CHISQ.DIST.RT can also be determined by
CHITEST.</paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2958439" role="code"
xml-lang="en-US">CHISQ.DIST.RT(Number; DegreesFreedom)</paragraph>
<paragraph id="par_id2948675" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the chi-square value of the random
sample used to determine the error probability.</paragraph>
@@ -748,7 +748,7 @@
<paragraph id="hd_id2950603" role="heading" level="2"
xml-lang="en-US">EXPON.DIST</paragraph>
<paragraph id="par_id2949563" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_EXP_DIST_MS">Returns the exponential
distribution.</ahelp></paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id2950987" role="code" xml-lang="en-US">EXPON.DIST(Number;
Lambda; C)</paragraph>
<paragraph id="par_id2954663" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the value of the function.</paragraph>
diff --git a/source/text/scalc/01/04060182.xhp
b/source/text/scalc/01/04060182.xhp
index 7c7c25bb1..8411b7766 100644
--- a/source/text/scalc/01/04060182.xhp
+++ b/source/text/scalc/01/04060182.xhp
@@ -58,6 +58,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_INV_LT"
id="bm_id2946113" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2945388" role="heading"
level="2">F.INV</paragraph>
<paragraph xml-lang="en-US" id="par_id2955089" role="paragraph"><ahelp
hid="HID_FUNC_F_INV_LT">Returns the inverse of the cumulative F
distribution.</ahelp> The F distribution is used for F tests in order to set
the relation between two differing data sets.</paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953068" role="code">F.INV(Number;
DegreesFreedom1; DegreesFreedom2)</paragraph>
<paragraph xml-lang="en-US" id="par_id2946866"
role="paragraph"><emph>Number</emph> is probability value for which the inverse
F distribution is to be calculated.</paragraph>
@@ -75,6 +76,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_INV_RT"
id="bm_id2846113" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2845388" role="heading"
level="2">F.INV.RT</paragraph>
<paragraph xml-lang="en-US" id="par_id2855089" role="paragraph"><ahelp
hid="HID_FUNC_F_INV_RT">Returns the inverse right tail of the F
distribution.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2853068"
role="code">F.INV.RT(Number; DegreesFreedom1; DegreesFreedom2)</paragraph>
<paragraph xml-lang="en-US" id="par_id2846866"
role="paragraph"><emph>Number</emph> is probability value for which the inverse
F distribution is to be calculated.</paragraph>
@@ -135,6 +137,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_TEST_MS"
id="bm_id2959263" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2951390" role="heading"
level="2">F.TEST</paragraph>
<paragraph xml-lang="en-US" id="par_id2950534" role="paragraph"><ahelp
hid="HID_FUNC_F_TEST_MS">Returns the result of an F test.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953024" role="code">F.TEST(Data1;
Data2)</paragraph>
<paragraph xml-lang="en-US" id="par_id2950032"
role="paragraph"><emph>Data1</emph> is the first record array.</paragraph>
@@ -167,6 +170,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_DIST_LT"
id="bm_id2949722" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2950372" role="heading"
level="2">F.DIST</paragraph>
<paragraph xml-lang="en-US" id="par_id2952981" role="paragraph"><ahelp
hid="HID_FUNC_F_DIST_LT">Calculates the values of the left tail of the F
distribution.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2945826" role="code">F.DIST(Number;
DegreesFreedom1; DegreesFreedom2; Cumulative)</paragraph>
<paragraph xml-lang="en-US" id="par_id2950461"
role="paragraph"><emph>Number</emph> is the value for which the F distribution
is to be calculated.</paragraph>
@@ -184,6 +188,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_F_DIST_RT"
id="bm_id289722" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id280372" role="heading"
level="2">F.DIST.RT</paragraph>
<paragraph xml-lang="en-US" id="par_id2852981" role="paragraph"><ahelp
hid="HID_FUNC_F_DIST_RT">Calculates the values of the right tail of the F
distribution.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2845826"
role="code">F.DIST.RT(Number; DegreesFreedom1; DegreesFreedom2)</paragraph>
<paragraph xml-lang="en-US" id="par_id2850461"
role="paragraph"><emph>Number</emph> is the value for which the F distribution
is to be calculated.</paragraph>
@@ -227,6 +232,7 @@
<paragraph xml-lang="en-US" id="hd_id2914841" role="heading"
level="2">GAMMA.INV</paragraph>
<paragraph xml-lang="en-US" id="par_id2913932"
role="paragraph"><ahelp hid="HID_FUNC_GAMMAINV_MS">Returns the inverse of the
Gamma cumulative distribution GAMMADIST.</ahelp> This function allows you to
search for variables with different distribution.</paragraph>
<paragraph id="par_id291422405814" role="paragraph"
xml-lang="en-US">This function is identical to GAMMAINV and was introduced for
interoperability with other office suites.</paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2915828"
role="code">GAMMA.INV(Number; Alpha; Beta)</paragraph>
<paragraph xml-lang="en-US" id="par_id2915138" role="paragraph">
@@ -261,6 +267,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMALN_MS"
id="bm_id2919511" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2914806" role="heading"
level="2">GAMMALN.PRECISE</paragraph>
<paragraph xml-lang="en-US" id="par_id2918572"
role="paragraph"><ahelp hid="HID_FUNC_GAMMALN_MS">Returns the natural logarithm
of the Gamma function: G(x).</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2913112"
role="code">GAMMALN.PRECISE(Number)</paragraph>
<paragraph xml-lang="en-US" id="par_id2914502" role="paragraph">
@@ -299,6 +306,7 @@
<paragraph id="par_id2406201422414690" role="paragraph"
xml-lang="en-US"><ahelp hid="HID_FUNC_GAMMADIST_MS">Returns the values of a
Gamma distribution.</ahelp></paragraph>
<paragraph id="par_id24061422414690" role="paragraph" xml-lang="en-US">The
inverse function is GAMMAINV or GAMMA.INV.</paragraph>
<paragraph id="par_id2406201422405814" role="paragraph" xml-lang="en-US">This
function is identical to GAMMADIST and was introduced for interoperability with
other office suites.</paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id240620142238475" role="code"
xml-lang="en-US">GAMMA.DIST(Number; Alpha; Beta; C)</paragraph>
<paragraph id="par_id2406201422385134" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the value for which the Gamma
distribution is to be calculated.</paragraph>
@@ -380,6 +388,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_Z_TEST_MS"
id="bm_id2947569" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2953216" role="heading"
level="2">Z.TEST</paragraph>
<paragraph xml-lang="en-US" id="par_id2950758" role="paragraph"><ahelp
hid="HID_FUNC_Z_TEST_MS">Calculates the probability of observing a z-statistic
greater than the one computed based on a sample.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953274" role="code">Z.TEST(Data; mu;
Sigma)</paragraph>
<paragraph xml-lang="en-US" id="par_id2956109"
role="paragraph"><emph>Data</emph> is the given sample, drawn from a normally
distributed population.</paragraph>
@@ -433,6 +442,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_HYP_GEOM_DIST_MS"
id="bm_id2953910" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2952801" role="heading"
level="2">HYPGEOM.DIST</paragraph>
<paragraph xml-lang="en-US" id="par_id2959341" role="paragraph"><ahelp
hid="HID_FUNC_HYP_GEOM_DIST_MS">Returns the hypergeometric
distribution.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2955388" role="code">HYPGEOM.DIST(X;
NSample; Successes; NPopulation; Cumulative)</paragraph>
<paragraph xml-lang="en-US" id="par_id2954933"
role="paragraph"><emph>X</emph> is the number of results achieved in the random
sample.</paragraph>
diff --git a/source/text/scalc/01/04060183.xhp
b/source/text/scalc/01/04060183.xhp
index f6ecd7cc3..24e1893dc 100644
--- a/source/text/scalc/01/04060183.xhp
+++ b/source/text/scalc/01/04060183.xhp
@@ -87,6 +87,7 @@
<paragraph role="heading" id="hd_id2953559" xml-lang="en-US"
level="2">CONFIDENCE.T</paragraph>
<paragraph role="paragraph" id="par_id2953814" xml-lang="en-US">
<ahelp hid="HID_FUNC_CONFIDENCE_T">Returns the (1-alpha) confidence
interval for a Student's t distribution.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id2947501" xml-lang="en-US">CONFIDENCE.T(Alpha;
StDev; Size)</paragraph>
<paragraph role="paragraph" id="par_id2949872" xml-lang="en-US">
@@ -106,6 +107,7 @@
<paragraph role="heading" id="hd_id2853559" xml-lang="en-US"
level="2">CONFIDENCE.NORM</paragraph>
<paragraph role="paragraph" id="par_id2853814" xml-lang="en-US">
<ahelp hid="HID_FUNC_CONFIDENCE_N">Returns the (1-alpha) confidence
interval for a normal distribution.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id2847501"
xml-lang="en-US">CONFIDENCE.NORM(Alpha; StDev; Size)</paragraph>
<paragraph role="paragraph" id="par_id2849872" xml-lang="en-US">
@@ -159,6 +161,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COVARIANCE_P"
id="bm_id2952983" localize="false"/>
<paragraph role="heading" id="hd_id2950652" xml-lang="en-US"
level="2">COVARIANCE.P</paragraph>
<paragraph role="paragraph" id="par_id2946875" xml-lang="en-US"><ahelp
hid="HID_FUNC_COVARIANCE_P">Returns the covariance of the product of paired
deviations, for the entire population.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id2950740"
xml-lang="en-US">COVARIANCE.P(Data1; Data2)</paragraph>
<paragraph role="paragraph" id="par_id2945827"
xml-lang="en-US"><emph>Data1</emph> is the first data set.</paragraph>
@@ -173,6 +176,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COVARIANCE_S"
id="bm_id2852983" localize="false"/>
<paragraph role="heading" id="hd_id2850652" xml-lang="en-US"
level="2">COVARIANCE.S</paragraph>
<paragraph role="paragraph" id="par_id2846875" xml-lang="en-US"><ahelp
hid="HID_FUNC_COVARIANCE_S">Returns the covariance of the product of paired
deviations, for a sample of the population.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id2850740"
xml-lang="en-US">COVARIANCE.S(Data1; Data2)</paragraph>
<paragraph role="paragraph" id="par_id2845827"
xml-lang="en-US"><emph>Data1</emph> is the first data set.</paragraph>
@@ -240,6 +244,7 @@
<paragraph role="heading" id="hd_id2901928" xml-lang="en-US"
level="2">LOGNORM.INV</paragraph>
<paragraph role="paragraph" id="par_id2901297" xml-lang="en-US"><ahelp
hid="HID_FUNC_LOGINV_MS">Returns the inverse of the lognormal
distribution.</ahelp></paragraph>
<paragraph id="par_id290122405814" role="paragraph" xml-lang="en-US">This
function is identical to LOGINV and was introduced for interoperability with
other office suites.</paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id2901049" xml-lang="en-US">LOGNORM.INV(Number;
Mean; StDev)</paragraph>
<paragraph role="paragraph" id="par_id2901390" xml-lang="en-US">
@@ -280,6 +285,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOGNORMDIST_MS"
id="bm_id2901366" localize="false"/>
<paragraph role="heading" id="hd_id2908417" xml-lang="en-US"
level="2">LOGNORM.DIST</paragraph>
<paragraph role="paragraph" id="par_id2904953" xml-lang="en-US"><ahelp
hid="HID_FUNC_LOGNORMDIST_MS">Returns the values of a lognormal
distribution.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id2900686"
xml-lang="en-US">LOGNORM.DIST(Number; Mean; StDev; Cumulative)</paragraph>
<paragraph role="paragraph" id="par_id2904871" xml-lang="en-US">
diff --git a/source/text/scalc/01/04060184.xhp
b/source/text/scalc/01/04060184.xhp
index 6b0322331..9f7e210a0 100644
--- a/source/text/scalc/01/04060184.xhp
+++ b/source/text/scalc/01/04060184.xhp
@@ -180,6 +180,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODAL_VALUE_MS"
id="bm_id2949253" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2953933" role="heading"
level="2">MODE.SNGL</paragraph>
<paragraph xml-lang="en-US" id="par_id2953085" role="paragraph"><ahelp
hid="HID_FUNC_MODAL_VALUE_MS">Returns the most frequently occurring, or
repetitive, value in an array or range of data.</ahelp> If there are several
values with the same frequency, it returns the smallest value. An error occurs
when a value doesn't appear twice.</paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2955950" role="code">MODE.SNGL(Number1;
Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id2950337" role="paragraph"><emph>Number1,
Number2, ..., Number30</emph> are numerical values or ranges.</paragraph>
@@ -194,6 +195,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODAL_VALUE_MULTI"
id="bm_id2849253" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2853933" role="heading"
level="2">MODE.MULT</paragraph>
<paragraph xml-lang="en-US" id="par_id2853085" role="paragraph"><ahelp
hid="HID_FUNC_MODAL_VALUE_MULTI">Returns a vertical array of the statistical
modes (the most frequently occurring values) within a list of supplied
numbers.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2855950" role="code">MODE.MULT(Number1;
Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id2850337" role="paragraph"><emph>Number1,
Number2, ..., Number30</emph> are numerical values or ranges.</paragraph>
@@ -224,6 +226,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NEGBINOMDIST_MS"
id="bm_id2959135" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2949879" role="heading"
level="2">NEGBINOM.DIST</paragraph>
<paragraph xml-lang="en-US" id="par_id2955437" role="paragraph"><ahelp
hid="HID_FUNC_NEGBINOMDIST_MS">Returns the negative binomial density or
distribution function.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2950935" role="code">NEGBINOM.DIST(X; R;
SP; Cumulative)</paragraph>
<paragraph xml-lang="en-US" id="par_id2953044" role="paragraph"><emph>X</emph>
represents the value returned for unsuccessful tests.</paragraph>
@@ -257,6 +260,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMINV_MS"
id="bm_id2949396" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2955516" role="heading"
level="2">NORM.INV</paragraph>
<paragraph xml-lang="en-US" id="par_id2954634" role="paragraph"><ahelp
hid="HID_FUNC_NORMINV_MS">Returns the inverse of the normal cumulative
distribution.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2947534" role="code">NORM.INV(Number;
Mean; StDev)</paragraph>
<paragraph xml-lang="en-US" id="par_id2954950"
role="paragraph"><emph>Number</emph> represents the probability value used to
determine the inverse normal distribution.</paragraph>
@@ -292,6 +296,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NORMDIST_MS"
id="bm_id2917484" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2913722" role="heading"
level="2">NORM.DIST</paragraph>
<paragraph xml-lang="en-US" id="par_id2910386" role="paragraph"><ahelp
hid="HID_FUNC_NORMDIST_MS">Returns the density function or the normal
cumulative distribution.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2910613" role="code">NORM.DIST(Number;
Mean; StDev; C)</paragraph>
<paragraph xml-lang="en-US" id="par_id2919820"
role="paragraph"><emph>Number</emph> is the value of the distribution based on
which the normal distribution is to be calculated.</paragraph>
@@ -357,6 +362,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_POISSON_DIST_MS"
id="bm_id2956011" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2953985" role="heading"
level="2">POISSON.DIST</paragraph>
<paragraph xml-lang="en-US" id="par_id2954298" role="paragraph"><ahelp
hid="HID_FUNC_POISSON_DIST_MS">Returns the Poisson
distribution.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2946093"
role="code">POISSON.DIST(Number; Mean; C)</paragraph>
<paragraph xml-lang="en-US" id="par_id2947253"
role="paragraph"><emph>Number</emph> represents the value based on which the
Poisson distribution is calculated.</paragraph>
@@ -387,6 +393,7 @@
<paragraph xml-lang="en-US" id="par_id2854940" role="paragraph"><ahelp
hid="HID_FUNC_PERCENTILE_EXC">Returns the <item type="literal">Alpha</item>'th
percentile of a supplied range of values for a given value of <item
type="literal">Alpha</item>, within the range 0 to 1 (exclusive).</ahelp> A
percentile returns the scale value for a data series which goes from the
smallest (<item type="literal">Alpha=0</item>) to the largest value (<item
type="literal">Alpha=1</item>) of a data series. For <item
type="literal">Alpha</item> = 25%, the percentile means the first quartile;
<item type="literal">Alpha</item> = 50% is the MEDIAN.</paragraph>
<paragraph xml-lang="en-US" id="par_id2754940" role="warning">If <item
type="literal">Alpha</item> is not a multiple of <item
type="literal">1/(n+1)</item>, (where n is the number of values in the supplied
array), the function interpolates between the values in the supplied array, to
calculate the percentile value. However, if <item type="literal">Alpha</item>
is less than <item type="literal">1/(n+1)</item> or <item
type="literal">Alpha</item> is greater than <item
type="literal">n/(n+1)</item>, the function is unable to interpolate, and so
returns an error.</paragraph>
<paragraph xml-lang="en-US" id="par_id2653976" role="note">The difference
between <item type="input">PERCENTILE.INC</item> and <item
type="input">PERCENTILE.EXC</item> is that, in the <item
type="input">PERCENTILE.INC</item> function the value of alpha is within the
range 0 to 1 inclusive, and in the <item type="input">PERCENTILE.EXC</item>
function, the value of alpha is within the range 0 to 1 exclusive.</paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2848813"
role="code">PERCENTILE.EXC(Data; Alpha)</paragraph>
<paragraph xml-lang="en-US" id="par_id2853054"
role="paragraph"><emph>Data</emph> represents the array of data.</paragraph>
@@ -401,6 +408,7 @@
<paragraph xml-lang="en-US" id="hd_id2953100" role="heading"
level="2">PERCENTILE.INC</paragraph>
<paragraph xml-lang="en-US" id="par_id2954940" role="paragraph"><ahelp
hid="HID_FUNC_PERCENTILE_INC">Returns the alpha-percentile of data values in an
array.</ahelp> A percentile returns the scale value for a data series which
goes from the smallest (Alpha=0) to the largest value (alpha=1) of a data
series. For <item type="literal">Alpha</item> = 25%, the percentile means the
first quartile; <item type="literal">Alpha</item> = 50% is the
MEDIAN.</paragraph>
<paragraph xml-lang="en-US" id="par_id2753976" role="note">The difference
between <item type="input">PERCENTILE.INC</item> and <item
type="input">PERCENTILE.EXC</item> is that, in the <item
type="input">PERCENTILE.INC</item> function the value of alpha is within the
range 0 to 1 inclusive, and in the <item type="input">PERCENTILE.EXC</item>
function, the value of alpha is within the range 0 to 1 exclusive.</paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2948813"
role="code">PERCENTILE.INC(Data; Alpha)</paragraph>
<paragraph xml-lang="en-US" id="par_id2953054"
role="paragraph"><emph>Data</emph> represents the array of data.</paragraph>
@@ -429,6 +437,7 @@
<paragraph xml-lang="en-US" id="hd_id2848807" role="heading"
level="2">PERCENTRANK.EXC</paragraph>
<paragraph xml-lang="en-US" id="par_id2853573" role="paragraph"><ahelp
hid="HID_FUNC_PERCENTRANK_EXC"> Returns the relative position, between 0 and 1
(exclusive), of a specified value within a supplied array.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id2553976" role="note">The difference
between <item type="input">PERCENTRANK.INC</item> and <item
type="input">PERCENTRANK.EXC</item> is that <item
type="input">PERCENTRANK.INC</item> calculates a value in the range 0 to 1
inclusive, whereas the <item type="input">PERCENTRANK.EXC</item> function
calculates a value in the range 0 to 1 exclusive.</paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2847238"
role="code">PERCENTRANK.EXC(Data; Value; Significance)</paragraph>
<paragraph xml-lang="en-US" id="par_id2854266"
role="paragraph"><emph>Data</emph> represents the array of data in the
sample.</paragraph>
@@ -443,6 +452,7 @@
<paragraph xml-lang="en-US" id="hd_id2948807" role="heading"
level="2">PERCENTRANK.INC</paragraph>
<paragraph xml-lang="en-US" id="par_id2953573" role="paragraph"><ahelp
hid="HID_FUNC_PERCENTRANK_INC">Returns the relative position, between 0 and 1
(inclusive), of a specified value within a supplied array.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id2453976" role="note">The difference
between <item type="input">PERCENTRANK.INC</item> and <item
type="input">PERCENTRANK.EXC</item> is that <item
type="input">PERCENTRANK.INC</item> calculates a value in the range 0 to 1
inclusive, whereas the <item type="input">PERCENTRANK.EXC</item> function
calculates a value in the range 0 to 1 exclusive.</paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2947238"
role="code">PERCENTRANK.INC(Data; Value; Significance)</paragraph>
<paragraph xml-lang="en-US" id="par_id2954266"
role="paragraph"><emph>Data</emph> represents the array of data in the
sample.</paragraph>
@@ -472,6 +482,7 @@
<paragraph xml-lang="en-US" id="hd_id2866442" role="heading"
level="2">QUARTILE.EXC</paragraph>
<paragraph xml-lang="en-US" id="par_id2846958" role="paragraph"><ahelp
hid="HID_FUNC_QUARTILE_EXC">Returns a requested quartile of a supplied range of
values, based on a percentile range of 0 to 1 exclusive.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id2353976" role="note">The difference
between <item type="input">QUARTILE.INC</item> and <item
type="input">QUARTILE.EXC</item> is that the <item
type="input">QUARTILE.INC</item> function bases its calculation on a percentile
range of 0 to 1 inclusive, whereas the <item type="input">QUARTILE.EXC</item>
function bases its calculation on a percentile range of 0 to 1
exclusive.</paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2853684" role="code">QUARTILE.EXC(Data;
Type)</paragraph>
<paragraph xml-lang="en-US" id="par_id2853387"
role="paragraph"><emph>Data</emph> represents the range of data values for
which you want to calculate the specified quartile.</paragraph>
@@ -487,6 +498,7 @@
<paragraph xml-lang="en-US" id="hd_id2966442" role="heading"
level="2">QUARTILE.INC</paragraph>
<paragraph xml-lang="en-US" id="par_id2946958" role="paragraph"><ahelp
hid="HID_FUNC_QUARTILE_INC">Returns the quartile of a data
set.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id2253976" role="note">The difference
between <item type="input">QUARTILE.INC</item> and <item
type="input">QUARTILE.EXC</item> is that the <item
type="input">QUARTILE.INC</item> function bases its calculation on a percentile
range of 0 to 1 inclusive, whereas the <item type="input">QUARTILE.EXC</item>
function bases its calculation on a percentile range of 0 to 1
exclusive.</paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953684" role="code">QUARTILE.INC(Data;
Type)</paragraph>
<paragraph xml-lang="en-US" id="par_id2953387"
role="paragraph"><emph>Data</emph> represents the array of data in the
sample.</paragraph>
diff --git a/source/text/scalc/01/04060185.xhp
b/source/text/scalc/01/04060185.xhp
index 901aa10bd..9d5c12c76 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -60,6 +60,7 @@
<paragraph xml-lang="en-US" id="hd_id2955071" role="heading"
level="2">RANK.AVG</paragraph>
<paragraph xml-lang="en-US" id="par_id2953976" role="paragraph"><ahelp
hid="HID_FUNC_RANK_AVG">Returns the statistical rank of a given value, within a
supplied array of values.</ahelp> If there are duplicate values in the list,
the average rank is returned.</paragraph>
<paragraph xml-lang="en-US" id="par_id2653976" role="note">The difference
between <item type="input">RANK.AVG</item> and <item
type="input">RANK.EQ</item> occurs when there are duplicates in the list of
values. The <item type="input">RANK.EQ</item> function returns the lower rank,
whereas the <item type="input">RANK.AVG</item> function returns the average
rank.</paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953250" role="code">RANK.AVG(Value;
Data; Type)</paragraph>
<paragraph xml-lang="en-US" id="par_id2954543"
role="paragraph"><emph>Value</emph> is the value, whose rank is to be
determined.</paragraph>
@@ -79,6 +80,7 @@
<paragraph xml-lang="en-US" id="hd_id2855071" role="heading"
level="2">RANK.EQ</paragraph>
<paragraph xml-lang="en-US" id="par_id2853976" role="paragraph"><ahelp
hid="HID_FUNC_RANK_EQ">Returns the statistical rank of a given value, within a
supplied array of values.</ahelp> If there are duplicate values in the list,
these are given the same rank.</paragraph>
<paragraph xml-lang="en-US" id="par_id2753976" role="note">The difference
between <item type="input">RANK.AVG</item> and <item
type="input">RANK.EQ</item> occurs when there are duplicates in the list of
values. The <item type="input">RANK.EQ</item> function returns the lower rank,
whereas the <item type="input">RANK.AVG</item> function returns the average
rank.</paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2853250" role="code">RANK.EQ(Value;
Data; Type)</paragraph>
<paragraph xml-lang="en-US" id="par_id2854543"
role="paragraph"><emph>Value</emph> is the value, whose rank is to be
determined.</paragraph>
@@ -199,6 +201,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ST_DEV_P_MS"
id="bm_id2946139" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2949734" role="heading"
level="2">STDEV.P</paragraph>
<paragraph xml-lang="en-US" id="par_id2949187" role="paragraph"><ahelp
hid="HID_FUNC_ST_DEV_P_MS">Calculates the standard deviation based on the
entire population.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2954392"
role="code">STDEV.P(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id2955261"
role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical
values or ranges representing an entire population.</paragraph>
@@ -213,6 +216,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ST_DEV_S"
id="bm_id2846139" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2849734" role="heading"
level="2">STDEV.S</paragraph>
<paragraph xml-lang="en-US" id="par_id2849187" role="paragraph"><ahelp
hid="HID_FUNC_ST_DEV_S">Calculates the standard deviation based on sample of
the population.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2854392"
role="code">STDEV.S(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id2855261"
role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical
values or ranges representing a sample of the population.</paragraph>
@@ -274,6 +278,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STD_NORMINV_MS"
id="bm_id2948389" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2957986" role="heading"
level="2">NORM.S.INV</paragraph>
<paragraph xml-lang="en-US" id="par_id2951282"
role="paragraph"><ahelp hid="HID_FUNC_STD_NORMINV_MS">Returns the inverse of
the standard normal cumulative distribution.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2954195"
role="code">NORM.S.INV(Number)</paragraph>
<paragraph xml-lang="en-US" id="par_id2948772" role="paragraph">
@@ -305,6 +310,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_STD_NORMDIST_MS"
id="bm_id2945269" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2947538" role="heading"
level="2">NORM.S.DIST</paragraph>
<paragraph xml-lang="en-US" id="par_id2950474"
role="paragraph"><ahelp hid="HID_FUNC_STD_NORMDIST_MS">Returns the standard
normal cumulative distribution function. The distribution has a mean of zero
and a standard deviation of one.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2958411"
role="code">NORM.S.DIST(Number; Cumulative)</paragraph>
<paragraph xml-lang="en-US" id="par_id2954950" role="paragraph">
@@ -393,6 +399,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV_MS"
id="bm_id2953155" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2949579" role="heading"
level="2">T.INV</paragraph>
<paragraph xml-lang="en-US" id="par_id2943232" role="paragraph"><ahelp
hid="HID_FUNC_TINV_MS">Returns the one tailed inverse of the
t-distribution.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2949289" role="code">T.INV(Number;
DegreesFreedom)</paragraph>
<paragraph xml-lang="en-US" id="par_id2954070"
role="paragraph"><emph>Number</emph> is the probability associated with the
one-tailed t-distribution.</paragraph>
@@ -408,6 +415,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TINV_2T"
id="bm_id2853155" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2849579" role="heading"
level="2">T.INV.2T</paragraph>
<paragraph xml-lang="en-US" id="par_id2843232" role="paragraph"><ahelp
hid="HID_FUNC_TINV_2T">Calculates the inverse of the two-tailed Student's T
Distribution </ahelp>, which is a continuous probability distribution that is
frequently used for testing hypotheses on small sample data sets.</paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2849289"
role="code">T.INV.2T(Number; DegreesFreedom)</paragraph>
<paragraph xml-lang="en-US" id="par_id2854070"
role="paragraph"><emph>Number</emph> is the probability associated with the
two-tailed t-distribution.</paragraph>
@@ -443,6 +451,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TTEST_MS"
id="bm_id2953981" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2954129" role="heading"
level="2">T.TEST</paragraph>
<paragraph xml-lang="en-US" id="par_id2959184" role="paragraph"><ahelp
hid="HID_FUNC_TTEST_MS">Returns the probability associated with a Student's
t-Test.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2951175" role="code">T.TEST(Data1;
Data2; Mode; Type)</paragraph>
<paragraph xml-lang="en-US" id="par_id2949202"
role="paragraph"><emph>Data1</emph> is the dependent array or range of data for
the first record.</paragraph>
@@ -480,6 +489,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_MS"
id="bm_id2953095" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2954930" role="heading"
level="2">T.DIST</paragraph>
<paragraph xml-lang="en-US" id="par_id2953372" role="paragraph"><ahelp
hid="HID_FUNC_TDIST_MS">Returns the t-distribution.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2950521" role="code">T.DIST(Number;
DegreesFreedom; Cumulative)</paragraph>
<paragraph xml-lang="en-US" id="par_id2946991"
role="paragraph"><emph>Number</emph> is the value for which the t-distribution
is calculated.</paragraph>
@@ -496,6 +506,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_2T"
id="bm_id2853095" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2854930" role="heading"
level="2">T.DIST.2T</paragraph>
<paragraph xml-lang="en-US" id="par_id2853372" role="paragraph"><ahelp
hid="HID_FUNC_TDIST_2T">Calculates the two-tailed Student's T Distribution,
which is a continuous probability distribution that is frequently used for
testing hypotheses on small sample data sets.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2850521"
role="code">T.DIST.2T(Number; DegreesFreedom)</paragraph>
<paragraph xml-lang="en-US" id="par_id2846991"
role="paragraph"><emph>Number</emph> is the value for which the t-distribution
is calculated.</paragraph>
@@ -511,6 +522,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TDIST_RT"
id="bm_id273095" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id274930" role="heading"
level="2">T.DIST.RT</paragraph>
<paragraph xml-lang="en-US" id="par_id2753372" role="paragraph"><ahelp
hid="HID_FUNC_TDIST_RT">Calculates the right-tailed Student's T Distribution,
which is a continuous probability distribution that is frequently used for
testing hypotheses on small sample data sets.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2750521"
role="code">T.DIST.RT(Number; DegreesFreedom)</paragraph>
<paragraph xml-lang="en-US" id="par_id2746991"
role="paragraph"><emph>Number</emph> is the value for which the t-distribution
is calculated.</paragraph>
@@ -542,6 +554,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VAR_S"
id="bm_id2954898" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2953828" role="heading"
level="2">VAR.S</paragraph>
<paragraph xml-lang="en-US" id="par_id2959165" role="paragraph"><ahelp
hid="HID_FUNC_VAR_S">Estimates the variance based on a
sample.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2953054"
role="code">VAR.S(Number1; Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id2948938"
role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical
values or ranges representing a sample based on an entire
population.</paragraph>
@@ -585,6 +598,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VAR_P_MS"
id="bm_id2952359" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id2966441" role="heading"
level="2">VAR.P</paragraph>
<paragraph xml-lang="en-US" id="par_id2959199" role="paragraph"><ahelp
hid="HID_FUNC_VAR_P_MS">Calculates a variance based on the entire
population.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2947282" role="code">VAR.P(Number1;
Number2; ...; Number30)</paragraph>
<paragraph xml-lang="en-US" id="par_id2949793"
role="paragraph"><emph>Number1, Number2, ..., Number30</emph> are numerical
values or ranges representing an entire population.</paragraph>
@@ -696,6 +710,7 @@
<paragraph xml-lang="en-US" id="par_id2905200911372767"
role="paragraph">The Weibull distribution is a continuous probability
distribution, with parameters Alpha > 0 (shape) and Beta > 0 (scale).
</paragraph>
<paragraph xml-lang="en-US" id="par_id2905200911372777"
role="paragraph">If C is 0, WEIBULL.DIST calculates the probability density
function.</paragraph>
<paragraph xml-lang="en-US" id="par_id2905200911372743"
role="paragraph">If C is 1, WEIBULL.DIST calculates the cumulative distribution
function.</paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id2954478"
role="code">WEIBULL.DIST(Number; Alpha; Beta; C)</paragraph>
<paragraph xml-lang="en-US" id="par_id2951317"
role="paragraph"><emph>Number</emph> is the value at which to calculate the
Weibull distribution.</paragraph>
diff --git a/source/text/scalc/01/func_aggregate.xhp
b/source/text/scalc/01/func_aggregate.xhp
index 18e00aa4d..ba8ce64ec 100644
--- a/source/text/scalc/01/func_aggregate.xhp
+++ b/source/text/scalc/01/func_aggregate.xhp
@@ -29,7 +29,7 @@
<paragraph id="par_id2209201514174373" role="paragraph"
xml-lang="en-US"><ahelp hid="."><variable id="aggregate_des">This function
returns an aggregate result of the calculations in the range. You can use
different aggregate functions listed below. The Aggregate function enables you
to omit hidden rows, errors, SUBTOTAL and other AGGREGATE function results in
the calculation.</variable></ahelp></paragraph>
</section>
<paragraph id="par_id2209201514174453" role="note" xml-lang="en-US">AGGREGATE
function is applied to vertical ranges of data with activated AutoFilter. If
AutoFilter is not activated, automatic recalculation of the function result
does not work for newly hidden rows. It is not supposed to work with horizontal
ranges, however it can be applied to them as well, but with limitations. In
particular, the AGGREGATE function applied to a horizontal data range does not
recognize hiding columns, however correctly omits errors and results of
SUBTOTAL and other AGGREGATE functions embedded into the row. </paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#4.4"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id200801176228491" role="code"
xml-lang="en-US">AGGREGATE(Function; Option; Ref1 [; Ref2 [; …]])</paragraph>
<paragraph id="par_id2309201516102726" role="paragraph"
xml-lang="en-US">or</paragraph>
diff --git a/source/text/scalc/01/func_averageif.xhp
b/source/text/scalc/01/func_averageif.xhp
index 5498a89ef..15ad55ef0 100644
--- a/source/text/scalc/01/func_averageif.xhp
+++ b/source/text/scalc/01/func_averageif.xhp
@@ -26,6 +26,7 @@
<paragraph id="hd_id16852304621982" role="heading" level="2"
xml-lang="en-US"><variable id="averageif_head"><link
href="text/scalc/01/func_averageif.xhp">AVERAGEIF</link></variable>
function</paragraph>
<paragraph id="par_id7281266615152" role="paragraph" xml-lang="en-US"><ahelp
hid="."><variable id="averageif_des">Returns the arithmetic mean of all cells
in a range that satisfy a given condition. The AVERAGEIF function sums up all
the results that match the logical test and divides this sum by the quantity of
selected values.</variable></ahelp></paragraph>
</section>
+<embed href="text/scalc/00/avail_release.xhp#4.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id200801176228491" role="code"
xml-lang="en-US">AVERAGEIF(Range; Criterion [; Average_Range ])</paragraph>
<paragraph id="par_id15226321619829" role="paragraph"
xml-lang="en-US"><emph>Range</emph> – required argument. An array, a name of
named range or a label of a column or a row containing numbers for averaging or
numbers or text for the condition.</paragraph>
diff --git a/source/text/scalc/01/func_averageifs.xhp
b/source/text/scalc/01/func_averageifs.xhp
index e127b457c..3c72f34dc 100644
--- a/source/text/scalc/01/func_averageifs.xhp
+++ b/source/text/scalc/01/func_averageifs.xhp
@@ -26,6 +26,7 @@
<paragraph id="hd_id537445374453744" role="heading" level="2"
xml-lang="en-US"><variable id="averageifs_head"><link
href="text/scalc/01/func_averageifs.xhp">AVERAGEIFS</link></variable>
function</paragraph>
<paragraph id="par_id538405384053840" role="paragraph" xml-lang="en-US"><ahelp
hid="."><variable id="averageifs_des">Returns the arithmetic mean of all cells
in a range that satisfy given multiple criteria. The AVERAGEIFS function sums
up all the results that match the logical tests and divides this sum by the
quantity of selected values.</variable></ahelp></paragraph>
</section>
+<embed href="text/scalc/00/avail_release.xhp#4.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id21050267713178" role="code"
xml-lang="en-US">AVERAGEIFS(<embedvar
href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph>
<paragraph id="par_id165832700711773" role="paragraph"
xml-lang="en-US"><emph>Func_range</emph> – required argument. It is a range of
cells, a name of a named range or a label of a column or a row containing
values for calculating the mean.</paragraph>
diff --git a/source/text/scalc/01/func_countifs.xhp
b/source/text/scalc/01/func_countifs.xhp
index 1a5253ee3..a06f12b85 100644
--- a/source/text/scalc/01/func_countifs.xhp
+++ b/source/text/scalc/01/func_countifs.xhp
@@ -27,6 +27,7 @@
<paragraph id="hd_id456845684568" role="heading" level="2"
xml-lang="en-US"><variable id="countifs_head"><link
href="text/scalc/01/func_countifs.xhp">COUNTIFS</link></variable>
function</paragraph>
<paragraph id="par_id462646264626" role="paragraph" xml-lang="en-US"><ahelp
hid="."><variable id="countifs_des">Returns the count of cells that meet
criteria in multiple ranges.</variable></ahelp></paragraph>
</section>
+<embed href="text/scalc/00/avail_release.xhp#4.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id27421466710275" role="code"
xml-lang="en-US">COUNTIFS(Range1; Criterion1 [; Range2; Criterion2 [;
...]])</paragraph>
<paragraph id="par_id242131304318587" role="paragraph"
xml-lang="en-US"><emph>Range1</emph> – required argument. It is a range of
cells, a name of a named range or a label of a column or a row containing
values for counting and finding the corresponding criterion.</paragraph>
diff --git a/source/text/scalc/01/func_datedif.xhp
b/source/text/scalc/01/func_datedif.xhp
index c7667acfb..3d56e4a28 100644
--- a/source/text/scalc/01/func_datedif.xhp
+++ b/source/text/scalc/01/func_datedif.xhp
@@ -23,6 +23,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DATEDIF" id="bm_id3149022"
localize="false"/><paragraph role="heading" id="hd_id3155511" xml-lang="en-US"
level="2"><variable id="datedif"><link
href="text/scalc/01/func_datedif.xhp">DATEDIF</link>
</variable></paragraph>
<paragraph role="paragraph" id="par_id3153551" xml-lang="en-US"><ahelp
hid="HID_FUNC_DATEDIF">This function returns the number of whole days, months
or years between Start date and End date.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#3.6"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3150474" xml-lang="en-US">DATEDIF(Start date;
End date; Interval)</paragraph>
<paragraph role="paragraph" id="par_id3152815" xml-lang="en-US">
diff --git a/source/text/scalc/01/func_error_type.xhp
b/source/text/scalc/01/func_error_type.xhp
index 8a95507cb..a1e92361d 100644
--- a/source/text/scalc/01/func_error_type.xhp
+++ b/source/text/scalc/01/func_error_type.xhp
@@ -28,7 +28,7 @@
<paragraph id="hd_id348223482234822" role="heading" level="2"
xml-lang="en-US"><variable id="error_type_head"><link
href="text/scalc/01/func_error_type.xhp">ERROR.TYPE</link></variable>
function</paragraph>
<paragraph id="par_id350283502835028" role="paragraph" xml-lang="en-US"><ahelp
hid="."><variable id="error_type_des">Returns a number representing a specific
Error type, or the error value #N/A, if there is no error.
</variable></ahelp></paragraph>
</section>
-
+<embed href="text/scalc/00/avail_release.xhp#5.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id1861223540440" role="code"
xml-lang="en-US">ERROR.TYPE(Error_value)</paragraph>
<paragraph id="par_id217737315" role="paragraph"
xml-lang="en-US"><emph>Error_value</emph> – required argument. The error value
or a reference to a cell, whose value needs to be processed.</paragraph>
diff --git a/source/text/scalc/01/func_forecastetsadd.xhp
b/source/text/scalc/01/func_forecastetsadd.xhp
index 4f76d245e..c2c0ea197 100644
--- a/source/text/scalc/01/func_forecastetsadd.xhp
+++ b/source/text/scalc/01/func_forecastetsadd.xhp
@@ -28,7 +28,7 @@
<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
<paragraph id="par_id0603201608440530" role="paragraph"
xml-lang="en-US">FORECAST.ETS.ADD calculates with the model</paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#etsadd"/>
-
+<embed href="text/scalc/00/avail_release.xhp#5.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id0403201618594544" role="code"
xml-lang="en-US">FORECAST.ETS.ADD(targets, values, timeline, [period_length],
[data_completion], [aggregation]) </paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#target"/>
diff --git a/source/text/scalc/01/func_forecastetsmult.xhp
b/source/text/scalc/01/func_forecastetsmult.xhp
index 491d18f23..cc8926af1 100644
--- a/source/text/scalc/01/func_forecastetsmult.xhp
+++ b/source/text/scalc/01/func_forecastetsmult.xhp
@@ -29,7 +29,7 @@
<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
<paragraph id="par_id0603201608440530" role="paragraph"
xml-lang="en-US">FORECAST.ETS.MULT calculates with the model </paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#etsmult"/>
-
+<embed href="text/scalc/00/avail_release.xhp#5.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id0403201618594544" role="code"
xml-lang="en-US">FORECAST.ETS.MULT(targets, values, timeline, [period_length],
[data_completion], [aggregation]) </paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#target"/>
diff --git a/source/text/scalc/01/func_forecastetspiadd.xhp
b/source/text/scalc/01/func_forecastetspiadd.xhp
index 3cc54a9d4..7cc75c925 100644
--- a/source/text/scalc/01/func_forecastetspiadd.xhp
+++ b/source/text/scalc/01/func_forecastetspiadd.xhp
@@ -29,7 +29,7 @@
<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
<paragraph id="par_id0603201610005998" role="paragraph"
xml-lang="en-US">FORECAST.ETS.PI.ADD calculates with the model</paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#etsadd"/>
-
+<embed href="text/scalc/00/avail_release.xhp#5.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id0603201610010044" role="code"
xml-lang="en-US">FORECAST.ETS.PI.ADD(target, values, timeline,
[confidence_level], [period_length], [data_completion],
[aggregation])</paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#target"/>
diff --git a/source/text/scalc/01/func_forecastetspimult.xhp
b/source/text/scalc/01/func_forecastetspimult.xhp
index 155ba0cab..002f8fefa 100644
--- a/source/text/scalc/01/func_forecastetspimult.xhp
+++ b/source/text/scalc/01/func_forecastetspimult.xhp
@@ -29,7 +29,7 @@
<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
<paragraph id="par_id0603201610005998" role="paragraph"
xml-lang="en-US">FORECAST.ETS.PI.MULT calculates with the model</paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#etsmult"/>
-
+<embed href="text/scalc/00/avail_release.xhp#5.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id0603201610010044" role="code"
xml-lang="en-US">FORECAST.ETS.PI.MULT(target, values, timeline,
[confidence_level], [period_length], [data_completion],
[aggregation])</paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#target"/>
diff --git a/source/text/scalc/01/func_forecastetsseason.xhp
b/source/text/scalc/01/func_forecastetsseason.xhp
index 22118da34..9db5f21d0 100644
--- a/source/text/scalc/01/func_forecastetsseason.xhp
+++ b/source/text/scalc/01/func_forecastetsseason.xhp
@@ -29,7 +29,7 @@
<paragraph id="par_id0603201617510446" role="paragraph"
xml-lang="en-US"><ahelp hid="HID_FUNC_FORECAST_ETS_SEA">Returns the number of
samples in period as calculated by Calc in case of FORECAST.ETS functions when
argument <emph>period_length</emph> equals 1. </ahelp></paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
<paragraph id="par_id0403201618595132" role="paragraph" xml-lang="en-US">The
same result is returned with FORECAST.ETS.STAT functions when argument
<emph>stat_type</emph> equals 9 (and <emph>period_length</emph> equals
1).</paragraph>
-
+<embed href="text/scalc/00/avail_release.xhp#5.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id0603201618013796" role="code"
xml-lang="en-US">FORECAST.ETS.SEASONALITY (values, timeline, [data_completion],
[aggregation])</paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#values"/>
diff --git a/source/text/scalc/01/func_forecastetsstatadd.xhp
b/source/text/scalc/01/func_forecastetsstatadd.xhp
index 9e84d6aa6..a6a22b1ba 100644
--- a/source/text/scalc/01/func_forecastetsstatadd.xhp
+++ b/source/text/scalc/01/func_forecastetsstatadd.xhp
@@ -31,7 +31,7 @@
<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
<paragraph id="par_id0603201608440530" role="paragraph"
xml-lang="en-US">FORECAST.ETS.STAT.ADD calculates with the model </paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#etsadd"/>
-
+<embed href="text/scalc/00/avail_release.xhp#5.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id0603201610005728" role="code"
xml-lang="en-US">FORECAST.ETS.STAT.ADD (values, timeline, stat_type,
[period_length], [data_completion], [aggregation])</paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#values"/>
diff --git a/source/text/scalc/01/func_forecastetsstatmult.xhp
b/source/text/scalc/01/func_forecastetsstatmult.xhp
index 07dae8f64..7ac7d527c 100644
--- a/source/text/scalc/01/func_forecastetsstatmult.xhp
+++ b/source/text/scalc/01/func_forecastetsstatmult.xhp
@@ -30,7 +30,7 @@
<embed href="text/scalc/01/exponsmooth_embd.xhp#intro"/>
<paragraph id="par_id0603201608440530" role="paragraph"
xml-lang="en-US">FORECAST.ETS.STAT.MULT calculates with the model </paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#etsmult"/>
-
+<embed href="text/scalc/00/avail_release.xhp#5.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id0603201610005728" role="code"
xml-lang="en-US">FORECAST.ETS.STAT.MULT (values, timeline, stat_type,
[period_length], [data_completion], [aggregation])</paragraph>
<embed href="text/scalc/01/exponsmooth_embd.xhp#values"/>
diff --git a/source/text/scalc/01/func_imcosh.xhp
b/source/text/scalc/01/func_imcosh.xhp
index adcff3019..3855ccae4 100644
--- a/source/text/scalc/01/func_imcosh.xhp
+++ b/source/text/scalc/01/func_imcosh.xhp
@@ -36,6 +36,7 @@
</paragraph>
<embed href="text/scalc/01/ful_func.xhp#func_im_des"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
+ <embed href="text/scalc/00/avail_release.xhp#3.6"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph id="par_id16051131322110" role="code" xml-lang="en-US">
IMCOSH(Complex_number)
diff --git a/source/text/scalc/01/func_imcot.xhp
b/source/text/scalc/01/func_imcot.xhp
index 753ebdf9b..022a6a11b 100644
--- a/source/text/scalc/01/func_imcot.xhp
+++ b/source/text/scalc/01/func_imcot.xhp
@@ -40,6 +40,7 @@
</paragraph>
<embed href="text/scalc/01/ful_func.xhp#func_im_des"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
+ <embed href="text/scalc/00/avail_release.xhp#3.6"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph id="par_id16051131322110" role="code" xml-lang="en-US">
IMCOT(Complex_number)
diff --git a/source/text/scalc/01/func_imcsc.xhp
b/source/text/scalc/01/func_imcsc.xhp
index b585d45d9..5243f5964 100644
--- a/source/text/scalc/01/func_imcsc.xhp
+++ b/source/text/scalc/01/func_imcsc.xhp
@@ -40,6 +40,7 @@
</paragraph>
<embed href="text/scalc/01/ful_func.xhp#func_im_des"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
+ <embed href="text/scalc/00/avail_release.xhp#3.6"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph id="par_id30461169611909" role="code" xml-lang="en-US">
IMCSC(Complex_number)
diff --git a/source/text/scalc/01/func_imcsch.xhp
b/source/text/scalc/01/func_imcsch.xhp
index f01660ace..30249aecd 100644
--- a/source/text/scalc/01/func_imcsch.xhp
+++ b/source/text/scalc/01/func_imcsch.xhp
@@ -40,6 +40,7 @@
</paragraph>
<embed href="text/scalc/01/ful_func.xhp#func_im_des"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
+ <embed href="text/scalc/00/avail_release.xhp#3.6"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph id="par_id30461169611909" role="code" xml-lang="en-US">
IMCSCH(Complex_number)
diff --git a/source/text/scalc/01/func_imsec.xhp
b/source/text/scalc/01/func_imsec.xhp
index ee19ce11c..a0c76ff7d 100644
--- a/source/text/scalc/01/func_imsec.xhp
+++ b/source/text/scalc/01/func_imsec.xhp
@@ -40,6 +40,7 @@
</paragraph>
<embed href="text/scalc/01/ful_func.xhp#func_im_des"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
+ <embed href="text/scalc/00/avail_release.xhp#3.6"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph id="par_id66061624115094" role="code" xml-lang="en-US">
IMSEC(Complex_number)
diff --git a/source/text/scalc/01/func_imsech.xhp
b/source/text/scalc/01/func_imsech.xhp
index f38d3277f..e29fbadca 100644
--- a/source/text/scalc/01/func_imsech.xhp
+++ b/source/text/scalc/01/func_imsech.xhp
@@ -40,6 +40,7 @@
</paragraph>
<embed href="text/scalc/01/ful_func.xhp#func_im_des"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
+ <embed href="text/scalc/00/avail_release.xhp#3.6"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph id="par_id17253876723855" role="code" xml-lang="en-US">
IMSECH(Complex_number)
diff --git a/source/text/scalc/01/func_imsinh.xhp
b/source/text/scalc/01/func_imsinh.xhp
index 4b41f6835..32e7d3f89 100644
--- a/source/text/scalc/01/func_imsinh.xhp
+++ b/source/text/scalc/01/func_imsinh.xhp
@@ -36,6 +36,7 @@
</paragraph>
<embed href="text/scalc/01/ful_func.xhp#func_im_des"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
+ <embed href="text/scalc/00/avail_release.xhp#3.6"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph id="par_id284611113926520" role="code" xml-lang="en-US">
IMSINH(Complex_number)
diff --git a/source/text/scalc/01/func_imtan.xhp
b/source/text/scalc/01/func_imtan.xhp
index 79bbae150..1d67d08c7 100644
--- a/source/text/scalc/01/func_imtan.xhp
+++ b/source/text/scalc/01/func_imtan.xhp
@@ -40,6 +40,7 @@
</paragraph>
<embed href="text/scalc/01/ful_func.xhp#func_im_des"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
+ <embed href="text/scalc/00/avail_release.xhp#3.6"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph id="par_id23219159944377" role="code" xml-lang="en-US">
IMTAN(Complex_number)
diff --git a/source/text/scalc/01/func_isoweeknum.xhp
b/source/text/scalc/01/func_isoweeknum.xhp
index 1e84c4040..9556aecd4 100644
--- a/source/text/scalc/01/func_isoweeknum.xhp
+++ b/source/text/scalc/01/func_isoweeknum.xhp
@@ -35,6 +35,7 @@
</variable></paragraph>
<paragraph role="paragraph" id="par_id3149770" xml-lang="en-US"><ahelp
hid="HID_FUNC_ISOWEEKNUM">ISOWEEKNUM calculates the week number of the year for
the internal date value.</ahelp></paragraph>
<paragraph role="note" id="par_idN105E4" xml-lang="en-US">The International
Standard ISO 8601 has decreed that Monday shall be the first day of the week. A
week that lies partly in one year and partly in another is assigned a number in
the year in which most of its days lie. That means that week number 1 of any
year is the week that contains the January 4th.</paragraph>
+<embed href="text/scalc/00/avail_release.xhp#5.1"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3147236"
xml-lang="en-US">ISOWEEKNUM(Number)</paragraph>
<paragraph role="paragraph" id="par_id3147511" xml-lang="en-US">
diff --git a/source/text/scalc/01/func_maxifs.xhp
b/source/text/scalc/01/func_maxifs.xhp
index b3c6808b0..ebb829283 100644
--- a/source/text/scalc/01/func_maxifs.xhp
+++ b/source/text/scalc/01/func_maxifs.xhp
@@ -26,7 +26,7 @@
<paragraph id="hd_id658866588665886" role="heading" level="1"
xml-lang="en-US"><variable id="maxifs_head"><link
href="text/scalc/01/func_maxifs.xhp">MAXIFS</link></variable>
function</paragraph>
<paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp
hid="."><variable id="maxifs_des">Returns the maximum of the values of cells in
a range that meets multiple criteria in multiple
ranges.</variable></ahelp></paragraph>
</section>
-
+<embed href="text/scalc/00/avail_release.xhp#5.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id11655988824213" role="code"
xml-lang="en-US">MAXIFS(<embedvar
href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph>
diff --git a/source/text/scalc/01/func_minifs.xhp
b/source/text/scalc/01/func_minifs.xhp
index faac1635b..1fe496539 100644
--- a/source/text/scalc/01/func_minifs.xhp
+++ b/source/text/scalc/01/func_minifs.xhp
@@ -26,7 +26,7 @@
<paragraph id="hd_id658866588665886" role="heading" level="1"
xml-lang="en-US"><variable id="minifs_head"><link
href="text/scalc/01/func_minifs.xhp">MINIFS</link></variable>
function</paragraph>
<paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp
hid="."><variable id="minifs_des">Returns the minimum of the values of cells in
a range that meets multiple criteria in multiple
ranges.</variable></ahelp></paragraph>
</section>
-
+<embed href="text/scalc/00/avail_release.xhp#5.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id11655988824213" role="code"
xml-lang="en-US">MINIFS(<embedvar
href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph>
diff --git a/source/text/scalc/01/func_networkdays.intl.xhp
b/source/text/scalc/01/func_networkdays.intl.xhp
index ee355d7c1..c081e400e 100644
--- a/source/text/scalc/01/func_networkdays.intl.xhp
+++ b/source/text/scalc/01/func_networkdays.intl.xhp
@@ -34,6 +34,7 @@
<paragraph id="hd_id231020162211573602" role="heading" level="1"
xml-lang="en-US"><variable id="networkdaysintl"><link
href="text/scalc/01/func_networkdays.intl.xhp">NETWORKDAYS.INTL</link></variable></paragraph>
<paragraph id="par_id231020162213393086" role="paragraph"
xml-lang="en-US"><ahelp hid=".">Returns the number of workdays between a start
date and an end date. There are options to define weekend days and holidays.
The optional weekend parameter (or a string) can be used to define the weekend
days (or the non-working days in each week). Also, optionally, the user can
define a holiday list. The weekend days and user-defined holidays are not
counted as working days.</ahelp></paragraph>
</section>
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id231020162249539143" role="code"
xml-lang="en-US">NETWORKDAYS.INTL(StartDate; EndDate; Weekend;
Holidays)</paragraph>
<paragraph id="par_id231020162249533010" role="paragraph"
xml-lang="en-US"><emph>StartDate</emph> is the date from when the calculation
is carried out. If the start date is a workday, the day is included in the
calculation.</paragraph>
diff --git a/source/text/scalc/01/func_numbervalue.xhp
b/source/text/scalc/01/func_numbervalue.xhp
index cdc38aae1..7e60ca3ae 100644
--- a/source/text/scalc/01/func_numbervalue.xhp
+++ b/source/text/scalc/01/func_numbervalue.xhp
@@ -37,6 +37,7 @@
<ahelp hid="HID_FUNC_NUMBERVALUE">Convert text to number, in a
locale-independent way.</ahelp>
</paragraph>
<paragraph xml-lang="en-US" id="par_id3149281"
role="paragraph">Constraints: LEN(decimal_separator) = 1, decimal_separator
shall not appear in group_separator</paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#4.1"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3149268"
role="code">NUMBERVALUE("Text";decimal_separator;group_separator)</paragraph>
<paragraph xml-lang="en-US" id="par_id3154819"
role="paragraph"><emph>Text</emph> is a valid number expression and must be
entered with quotation marks.</paragraph>
diff --git a/source/text/scalc/01/func_rawsubtract.xhp
b/source/text/scalc/01/func_rawsubtract.xhp
index f60e33dd2..3ce5a6464 100644
--- a/source/text/scalc/01/func_rawsubtract.xhp
+++ b/source/text/scalc/01/func_rawsubtract.xhp
@@ -25,6 +25,7 @@
<paragraph id="hd_2016112109231" role="heading" level="1"
xml-lang="en-US"><link
href="text/scalc/01/func_rawsubtract.xhp">RAWSUBTRACT</link></paragraph>
<paragraph id="par_2016112109232" role="paragraph"
xml-lang="en-US"><ahelp hid=".">Subtracts a set of numbers and gives the result
without eliminating small roundoff errors.</ahelp></paragraph>
</section>
+ <embed href="text/scalc/00/avail_release.xhp#5.2"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph id="par_2016112109233" role="code"
xml-lang="en-US">RAWSUBTRACT(Minuend, Subtrahend1, Subtrahend2, ...)</paragraph>
<paragraph id="par_2016112109234" role="paragraph"
xml-lang="en-US">Subtracts the subtrahend(s) from the minuend without
eliminating roundoff errors. The function should be called with at least two
parameters.</paragraph>
diff --git a/source/text/scalc/01/func_roundsig.xhp
b/source/text/scalc/01/func_roundsig.xhp
index bf0a0884e..86d6cd6cf 100644
--- a/source/text/scalc/01/func_roundsig.xhp
+++ b/source/text/scalc/01/func_roundsig.xhp
@@ -23,6 +23,7 @@
<paragraph id="hd_id351519154702177" role="heading" level="1"
xml-lang="en-US"><link href="text/scalc/01/func_roundsig.xhp" name="command
name">ROUNDSIG</link></paragraph>
<paragraph id="par_id921519154702177" role="paragraph"
xml-lang="en-US"><variable id="roundsig"><ahelp hid="HID_FUNC_ROUNDSIG">Returns
a number rounded to a specified number of significant decimal digits of its
normalized floating point notation.</ahelp></variable></paragraph>
</section>
+ <embed href="text/scalc/00/avail_release.xhp#5.4"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph role="code" id="par_id291519155534115"
xml-lang="en-US">ROUNDSIG( Value; Digits )</paragraph>
<paragraph role="paragraph" id="par_id51519155217204"
xml-lang="en-US"><emph>Value</emph>: the number to be rounded.</paragraph>
diff --git a/source/text/scalc/01/func_skewp.xhp
b/source/text/scalc/01/func_skewp.xhp
index 942b44a6e..733b134d6 100644
--- a/source/text/scalc/01/func_skewp.xhp
+++ b/source/text/scalc/01/func_skewp.xhp
@@ -33,6 +33,7 @@
</bookmark>
<paragraph id="hd_id456845684568" role="heading" level="2"
xml-lang="en-US"><variable id="skewp_head"><link
href="text/scalc/01/func_skewp.xhp">SKEWP</link></variable></paragraph>
<paragraph id="par_id1102201617001848" role="paragraph"
xml-lang="en-US"><ahelp hid=".">Calculates the skewness of a distribution using
the population of a random variable.</ahelp></paragraph>
+<embed href="text/scalc/00/avail_release.xhp#4.1"/>
<embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/>
<paragraph id="par_id27421466710275" role="code"
xml-lang="en-US">SKEWP(Number1; Number2; ...; Number30)</paragraph>
<paragraph id="par_id242131304318587" role="paragraph"
xml-lang="en-US"><emph>Number1, Number2, ..., Number30</emph> are up to 30
numerical values or ranges.</paragraph>
diff --git a/source/text/scalc/01/func_sumifs.xhp
b/source/text/scalc/01/func_sumifs.xhp
index 93a4a67c9..364da42f7 100644
--- a/source/text/scalc/01/func_sumifs.xhp
+++ b/source/text/scalc/01/func_sumifs.xhp
@@ -26,7 +26,7 @@
<paragraph id="hd_id658866588665886" role="heading" level="1"
xml-lang="en-US"><variable id="sumifs_head"><link
href="text/scalc/01/func_sumifs.xhp">SUMIFS</link></variable>
function</paragraph>
<paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp
hid="."><variable id="sumifs_des">Returns the sum of the values of cells in a
range that meets multiple criteria in multiple
ranges.</variable></ahelp></paragraph>
</section>
-
+<embed href="text/scalc/00/avail_release.xhp#4.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id11655988824213" role="code"
xml-lang="en-US">SUMIFS(<embedvar
href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph>
diff --git a/source/text/scalc/01/func_webservice.xhp
b/source/text/scalc/01/func_webservice.xhp
index e74e1613b..c7427d6de 100644
--- a/source/text/scalc/01/func_webservice.xhp
+++ b/source/text/scalc/01/func_webservice.xhp
@@ -25,6 +25,7 @@
<paragraph role="paragraph" id="par_id3149893"
xml-lang="en-US"><ahelp
hid="HID_FUNC_WEBSERVICE">Get some web content from a
URI.</ahelp></paragraph>
</section>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id3154844"
xml-lang="en-US">WEBSERVICE(URI)</paragraph>
<paragraph role="paragraph" id="par_id3147469"
xml-lang="en-US"><emph>URI: </emph> URI text of the web service.</paragraph>
@@ -41,6 +42,7 @@
<paragraph role="heading" id="hd_id2949012" xml-lang="en-US"
level="1"><variable id="filterxmlfuncname"><link
href="text/scalc/01/func_webservice.xhp#filterxml"
name="filterxml">FILTERXML</link></variable></paragraph>
<paragraph role="paragraph" id="par_id2949893"
xml-lang="en-US"><ahelp hid="HID_FUNC_FILTERXML">Apply a XPath expression to a
XML document.</ahelp></paragraph>
</section>
+ <embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id2954844"
xml-lang="en-US">FILTERXML(XML Document; XPath expression)</paragraph>
<paragraph role="paragraph" id="par_id2947469"
xml-lang="en-US"><emph>XML Document (required):</emph> String containing a
valid XML stream.</paragraph>
@@ -59,6 +61,7 @@
<paragraph id="par_id51517132649769" role="paragraph"
xml-lang="en-US"><ahelp hid="HID_FUNC_ENCODEURL">Returns a URL-encoded
string.</ahelp></paragraph>
</section>
<paragraph role="paragraph" id="par_id721517134647880"
xml-lang="en-US">Use this function to transform text with symbols of national
alphabets (for example accented characters, non-ASCII alphabets or Asian words)
to a string of URL-standard symbols.</paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#5.0"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph role="code" id="par_id351517132879400"
xml-lang="en-US">ENCODEURL(Text)</paragraph>
<paragraph role="paragraph" id="par_id921517132924079"
xml-lang="en-US"><emph>Text</emph>: String to encode to a sequence of
URL-standard symbols.</paragraph>
diff --git a/source/text/scalc/01/func_workday.intl.xhp
b/source/text/scalc/01/func_workday.intl.xhp
index 9a3e3cc2c..58167a377 100644
--- a/source/text/scalc/01/func_workday.intl.xhp
+++ b/source/text/scalc/01/func_workday.intl.xhp
@@ -35,7 +35,7 @@
<paragraph id="hd_id231020162348002143" role="heading" level="1"
xml-lang="en-US"><variable id="workdaysintl"><link
href="text/scalc/01/func_workday.intl.xhp">WORKDAY.INTL</link></variable></paragraph>
<paragraph id="par_id23102016234837285" role="paragraph"
xml-lang="en-US"><ahelp hid=".">The result is a date number that can be
formatted as a date. User can see the date of a day that is a certain number of
workdays away from the start date (before or after). There are options to
define weekend days and holidays. The optional weekend parameter (or a string)
can be used to define the weekend days (or the non-working days in each week).
Also, optionally, the user can define a holiday list. The weekend days and
user-defined holidays are not counted as working days.</ahelp></paragraph>
</section>
-
+<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id241020160008306838" role="code"
xml-lang="en-US">WORKDAY.INTL(StartDate; Days; Weekend; Holidays)</paragraph>
<paragraph id="par_id241020160008308885" role="paragraph"
xml-lang="en-US"><emph>StartDate</emph> is the date from when the calculation
is carried out. If the start date is a workday, the day is included in the
calculation. This is required.</paragraph>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
