diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-04-25 17:53:14 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-04-27 13:59:57 +0200 |
| commit | 0a874cee4a5d694b6c055b896d4dc64f7151b001 (patch) | |
| tree | 271886a28c592a2bdb2ab6f024de974bb2e29cfd | |
| parent | 4eace90975b889ef35d10ea35032cae0b569595e (diff) | |
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.hallot@libreoffice.org>
43 files changed, 108 insertions, 37 deletions
diff --git a/source/text/scalc/01/04060104.xhp b/source/text/scalc/01/04060104.xhp index db7bb6c02f..a7d70bd22e 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 63c8289ec8..97c212d50e 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 c2f40d1c8b..68631cebc9 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 c582ffc300..31722b8cfb 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 9506f99b52..ba44e34a22 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 7d8f448e82..0a22215b9f 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 ec6c2ee6a4..bc016f6fc4 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 7c7c25bb1d..8411b77664 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 f6ecd7cc33..24e1893dcf 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 6b03223313..9f7e210a05 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 901aa10bd7..9d5c12c764 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 18e00aa4d7..ba8ce64ec0 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 5498a89efa..15ad55ef07 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 e127b457c5..3c72f34dce 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 1a5253ee32..a06f12b85c 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 c7667acfba..3d56e4a286 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 8a95507cb6..a1e92361d9 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 4f76d245e9..c2c0ea197d 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 491d18f236..cc8926af18 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 3cc54a9d40..7cc75c9255 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 155ba0cab2..002f8fefaa 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 22118da34a..9db5f21d0b 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 9e84d6aa6a..a6a22b1ba5 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 07dae8f643..7ac7d527c6 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 adcff30190..3855ccae4b 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 753ebdf9b3..022a6a11b3 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 b585d45d9a..5243f59640 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 f01660acee..30249aecd5 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 ee19ce11c5..a0c76ff7db 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 f38d3277fd..e29fbadca8 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 4b41f6835b..32e7d3f89f 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 79bbae1502..1d67d08c7e 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 1e84c40402..9556aecd4b 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 b3c6808b00..ebb829283f 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 faac1635b0..1fe496539d 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 ee355d7c17..c081e400ec 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 cdc38aae1f..7e60ca3aed 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 f60e33dd2f..3ce5a64646 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 bf0a0884e1..86d6cd6cf6 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 942b44a6e9..733b134d6a 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 93a4a67c96..364da42f75 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 e74e1613b7..c7427d6de3 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 9a3e3cc2c9..58167a377d 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> |