source/text/scalc/01/04060105.xhp | 41 ++++++++++-----------
source/text/scalc/01/04060107.xhp | 6 +--
source/text/scalc/01/04060110.xhp | 7 +--
source/text/scalc/01/04060185.xhp | 71 +++++++++++++++++++-------------------
4 files changed, 62 insertions(+), 63 deletions(-)
New commits:
commit e22ee2eda6415961d879f58407bf59604e46dbd3
Author: Steve Fanning <stevemfanning...@gmail.com>
AuthorDate: Thu Mar 26 10:47:29 2020 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Mar 26 14:58:27 2020 +0100
tdf#131361 Adjust number of function parameters (3)
Fix for STDEV, STDEV.P, STDEV.S, STDEVA, STDEVP, STDEVPA,
VAR, VAR.P, VAR.S, VARA, VARP, VARPA,
AND, OR, XOR, SUMPRODUCT, CONCATENATE
Change-Id: I869f6d7fc687e645b9ee8c0ca36ff690c4108db3
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91103
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060105.xhp
b/source/text/scalc/01/04060105.xhp
index 97c212d50..c2de532c2 100644
--- a/source/text/scalc/01/04060105.xhp
+++ b/source/text/scalc/01/04060105.xhp
@@ -31,25 +31,25 @@
<bookmark_value>Function Wizard; logical</bookmark_value>
<bookmark_value>functions; logical functions</bookmark_value>
</bookmark>
-<paragraph xml-lang="en-US" id="hd_id3153484" role="heading" level="1">Logical
Functions</paragraph>
+<h1 id="hd_id3153484">Logical Functions</h1>
<paragraph xml-lang="en-US" id="par_id3149312"
role="paragraph"><variable id="logischtext">This category contains the
<emph>Logical</emph> functions.
</variable></paragraph>
-<paragraph role="heading" id="hd_id631520887352751" level="3"
xml-lang="en-US">Handling non-logical arguments in logical functions</paragraph>
+<h3 id="hd_id631520887352751">Handling non-logical arguments in logical
functions</h3>
<list type="unordered">
<listitem>
- <paragraph id="par_id431520887384579" role="listitem"
xml-lang="en-US">Zero (0) is equivalent to FALSE and all other numbers are
equivalent to TRUE.</paragraph>
+ <paragraph id="par_id431520887384579" role="listitem"
xml-lang="en-US">Zero (0) is equivalent to FALSE and all other numbers are
equivalent to TRUE.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id881520887475288" role="listitem"
xml-lang="en-US">Empty cells and text in cells are ignored.</paragraph>
+ <paragraph id="par_id881520887475288" role="listitem"
xml-lang="en-US">Empty cells and text in cells are ignored.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id461520887504085" role="listitem"
xml-lang="en-US">A #VALUE error is raised if all arguments are
ignored.</paragraph>
+ <paragraph id="par_id461520887504085" role="listitem"
xml-lang="en-US">A #VALUE error is raised if all arguments are
ignored.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id591520888006686" role="listitem"
xml-lang="en-US">A #VALUE error is raised if one argument is direct text (not
text in a cell).</paragraph>
+ <paragraph id="par_id591520888006686" role="listitem"
xml-lang="en-US">A #VALUE error is raised if one argument is direct text (not
text in a cell).</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id321520889630477" role="listitem"
xml-lang="en-US">Errors as argument lead to an error.</paragraph>
+ <paragraph id="par_id321520889630477" role="listitem"
xml-lang="en-US">Errors as argument lead to an error.</paragraph>
</listitem>
</list>
<section id="howtoget">
@@ -60,13 +60,12 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3147505"><bookmark_value>AND function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UND" id="bm_id3145320"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147505" role="heading"
level="2">AND</paragraph>
+<h2 id="hd_id3147505">AND</h2>
<paragraph xml-lang="en-US" id="par_id3153959"
role="paragraph"><ahelp hid="HID_FUNC_UND">Returns TRUE if all arguments are
TRUE.</ahelp> If one of the elements is FALSE, this function returns the FALSE
value.</paragraph>
<paragraph xml-lang="en-US" id="par_id3146100" 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/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3159123"
role="code">AND(LogicalValue1; LogicalValue2 ...LogicalValue30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150038" role="paragraph">
- <emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are
conditions to be checked. All conditions can be either TRUE or FALSE. If a
range is entered as a parameter, the function uses all values of the range. The
result is TRUE if the logical value in all cells within the cell range is
TRUE.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3159123"
role="code">AND(<embedvar href="text/scalc/01/ful_func.xhp#logical255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#logical255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153123" role="paragraph">The
logical values of entries 12<13; 14>12, and 7<6 are to be
checked:</paragraph>
<paragraph xml-lang="en-US" id="par_id3145632" role="paragraph">
@@ -78,7 +77,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3149015"><bookmark_value>FALSE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FALSCH" id="bm_id3154678"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149015" role="heading"
level="2">FALSE</paragraph>
+<h2 id="hd_id3149015">FALSE</h2>
<paragraph xml-lang="en-US" id="par_id3149890"
role="paragraph"><ahelp hid="HID_FUNC_FALSCH">Returns the logical value
FALSE.</ahelp> The FALSE() function does not require any arguments, and always
returns the logical value FALSE.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3150030"
role="code">FALSE()</paragraph>
@@ -92,7 +91,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3150141"><bookmark_value>IF
function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WENN" id="bm_id3152789"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3150141" role="heading"
level="2">IF</paragraph>
+<h2 id="hd_id3150141">IF</h2>
<paragraph xml-lang="en-US" id="par_id3148740"
role="paragraph"><ahelp hid="HID_FUNC_WENN">Specifies a logical test to be
performed.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3154558" role="code">IF(Test;
ThenValue; OtherwiseValue)</paragraph>
@@ -113,7 +112,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3155954"><bookmark_value>NOT function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NICHT" id="bm_id3145168"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3155954" role="heading"
level="2">NOT</paragraph>
+<h2 id="hd_id3155954">NOT</h2>
<paragraph xml-lang="en-US" id="par_id3153570"
role="paragraph"><ahelp hid="HID_FUNC_NICHT">Complements (inverts) a logical
value.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3157996"
role="code">NOT(LogicalValue)</paragraph>
@@ -127,13 +126,12 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3148394"><bookmark_value>OR
function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ODER" id="bm_id3155620"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3148394" role="heading"
level="2">OR</paragraph>
+<h2 id="hd_id3148394">OR</h2>
<paragraph xml-lang="en-US" id="par_id3156060"
role="paragraph"><ahelp hid="HID_FUNC_ODER">Returns TRUE if at least one
argument is TRUE.</ahelp> This function returns the value FALSE, if all the
arguments have the logical value FALSE.</paragraph>
<paragraph xml-lang="en-US" id="par_id3148771" 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/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3150468"
role="code">OR(LogicalValue1; LogicalValue2 ...LogicalValue30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3155819" role="paragraph">
- <emph>LogicalValue1; LogicalValue2 ...LogicalValue30</emph> are
conditions to be checked. All conditions can be either TRUE or FALSE. If a
range is entered as a parameter, the function uses all values of the
range.<comment>UFI: first try to fix bugtraq 4905779</comment></paragraph>
+ <paragraph xml-lang="en-US" id="par_id3150468"
role="code">OR(<embedvar href="text/scalc/01/ful_func.xhp#logical255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#logical255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3154870" role="paragraph">The
logical values of entries 12<11; 13>22, and 45=45 are to be
checked.</paragraph>
<paragraph xml-lang="en-US" id="par_id3155371" role="paragraph">
@@ -145,7 +143,7 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3156256"><bookmark_value>TRUE function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WAHR" id="bm_id3148426"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3156256" role="heading"
level="2">TRUE</paragraph>
+<h2 id="hd_id3156256">TRUE</h2>
<paragraph xml-lang="en-US" id="par_id3155985"
role="paragraph"><ahelp hid="HID_FUNC_WAHR">The logical value is set to
TRUE.</ahelp> The TRUE() function does not require any arguments, and always
returns the logical value TRUE.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3152590"
role="code">TRUE()</paragraph>
@@ -162,12 +160,13 @@
<bookmark xml-lang="en-US" branch="index"
id="bm_id3156257"><bookmark_value>XOR function</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_XOR" id="bm_id3148427"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3156257" role="heading"
level="2">XOR</paragraph>
+<h2 id="hd_id3156257">XOR</h2>
<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>
+ <paragraph xml-lang="en-US" id="par_id3150469"
role="code">XOR(<embedvar href="text/scalc/01/ful_func.xhp#logical255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#logical255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3083286" role="paragraph">
<item type="input">=XOR(TRUE;TRUE)</item> returns FALSE</paragraph>
diff --git a/source/text/scalc/01/04060107.xhp
b/source/text/scalc/01/04060107.xhp
index 93da1256f..958e6ced7 100644
--- a/source/text/scalc/01/04060107.xhp
+++ b/source/text/scalc/01/04060107.xhp
@@ -986,9 +986,9 @@
<paragraph id="hd_id3163286" role="heading" level="2"
xml-lang="en-US">SUMPRODUCT</paragraph>
<paragraph id="par_id3163314" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_SUMMENPRODUKT">Multiplies corresponding elements in the given
arrays, and returns the sum of those products.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph id="par_id3163347" role="code"
xml-lang="en-US">SUMPRODUCT(Array1; Array2; ...; Array30)</paragraph>
- <paragraph id="par_id3163362" role="paragraph"
xml-lang="en-US"><emph>Array1, Array2; ...; Array30</emph> represent arrays
whose corresponding elements are to be multiplied.</paragraph>
- <paragraph id="par_idN11B19" role="paragraph" xml-lang="en-US">At least one
array must be part of the argument list. If only one array is given, all array
elements are summed.</paragraph>
+ <paragraph id="par_id3163347" role="code" xml-lang="en-US">SUMPRODUCT(Array
1[; Array 2;][...;[Array 255]])</paragraph>
+ <paragraph id="par_id3163362" role="paragraph"
xml-lang="en-US"><emph>Array 1[; Array 2;][...;[Array 255]]</emph> represent
arrays whose corresponding elements are to be multiplied.</paragraph>
+ <paragraph id="par_idN11B19" role="paragraph" xml-lang="en-US">At least
one array must be part of the argument list. If only one array is given, all
array elements are summed. If more than one array is given, they must all be
the same size.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<table id="tbl_id6215704">
<tablerow>
diff --git a/source/text/scalc/01/04060110.xhp
b/source/text/scalc/01/04060110.xhp
index 91ff8aa62..5f0bbc9c5 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -189,15 +189,12 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3149688">
<bookmark_value>CONCATENATE function</bookmark_value>
</bookmark>
-
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VERKETTEN"
id="bm_id3153084" localize="false"/>
-
<h2 id="hd_id3149688">CONCATENATE</h2>
<paragraph id="par_id3154524" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_VERKETTEN">Combines several text strings into one
string.</ahelp></paragraph>
-
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3155954" role="code" xml-lang="en-US">CONCATENATE(
<embedvar href="text/scalc/01/ful_func.xhp#string255_1" markup="keep"/>
)</paragraph>
-<embed href="text/scalc/01/ful_func.xhp#string255"/>
+<paragraph id="par_id3155954" role="code"
xml-lang="en-US">CONCATENATE(<embedvar
href="text/scalc/01/ful_func.xhp#string255_1" markup="keep"/>)</paragraph>
+<paragraph role="paragraph" id="par_id781585222554150"><emph>String 1[; String
2][; … ;[String 255]]</emph> are strings or references to cells containing
strings.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3150008" role="paragraph" xml-lang="en-US"> <item
type="input">=CONCATENATE("Good ";"Morning ";"Mrs. ";"Doe")</item> returns:
Good Morning Mrs. Doe.</paragraph>
</section>
diff --git a/source/text/scalc/01/04060185.xhp
b/source/text/scalc/01/04060185.xhp
index 056953c3f..38a0157d2 100644
--- a/source/text/scalc/01/04060185.xhp
+++ b/source/text/scalc/01/04060185.xhp
@@ -158,12 +158,11 @@
<h2 id="hd_id3149143">STDEV</h2>
<paragraph xml-lang="en-US" id="par_id3146888"
role="paragraph"><ahelp hid="HID_FUNC_STABW">Estimates the standard deviation
based on a sample.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3149946"
role="code">STDEV(Number1; Number2; ...; Number30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3157904" role="paragraph">
- <emph>Number1, Number2, ..., Number30</emph> are numerical values
or ranges representing a sample based on an entire population.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149946"
role="code">STDEV(<embedvar href="text/scalc/01/ful_func.xhp#number255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#number255"/>
+ <paragraph id="par_id211585163957345" role="paragraph"
xml-lang="en-US">The parameters should specify at least two values.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
- <paragraph xml-lang="en-US" id="par_id3149434" role="paragraph">
- <item type="input">=STDEV(A1:A50)</item> returns the estimated
standard deviation based on the data referenced.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149434"
role="paragraph"><input>=STDEV(A1:A50)</input> returns the estimated standard
deviation based on the data referenced.</paragraph>
</section>
<section id="stdeva">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3144745"><bookmark_value>STDEVA function</bookmark_value>
@@ -172,9 +171,10 @@
<h2 id="hd_id3144745">STDEVA</h2>
<paragraph xml-lang="en-US" id="par_id3151234"
role="paragraph"><ahelp hid="HID_FUNC_STABWA">Calculates the standard deviation
of an estimation based on a sample.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3147422"
role="code">STDEVA(Value1; Value2; ...; Value30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154547" role="paragraph">
- <emph>Value1, Value2, ..., Value30</emph> are values or ranges
representing a sample derived from an entire population. Text has the value
0.</paragraph>
+
+ <paragraph xml-lang="en-US" id="par_id3147422"
role="code">STDEVA(<embedvar href="text/scalc/01/ful_func.xhp#number255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#number255"/>
+ <paragraph id="par_id981585163977014" role="paragraph"
xml-lang="en-US">The parameters should specify at least two values. Text has
the value 0.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3148581" role="paragraph">
<item type="input">=STDEVA(A1:A50)</item> returns the estimated
standard deviation based on the data referenced.</paragraph>
@@ -187,9 +187,9 @@
<h2 id="hd_id3149734">STDEVP</h2>
<paragraph xml-lang="en-US" id="par_id3149187"
role="paragraph"><ahelp hid="HID_FUNC_STABWN">Calculates the standard deviation
based on the entire population.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3154392"
role="code">STDEVP(Number1; Number2; ...; Number30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3155261" role="paragraph">
- <emph>Number1, Number2, ..., Number30</emph> are numerical values
or ranges representing an entire population.</paragraph>
+
+ <paragraph xml-lang="en-US" id="par_id3154392"
role="code">STDEVP(<embedvar href="text/scalc/01/ful_func.xhp#number255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153933" role="paragraph">
<item type="input">=STDEVP(A1:A50)</item> returns a standard
deviation of the data referenced.</paragraph>
@@ -204,8 +204,9 @@
<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>
+
+ <paragraph xml-lang="en-US" id="par_id2954392"
role="code">STDEV.P(<embedvar href="text/scalc/01/ful_func.xhp#number255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2953933" role="paragraph"><item
type="input">=STDEV.P(A1:A50)</item> returns a standard deviation of the data
referenced.</paragraph>
</section>
@@ -219,8 +220,10 @@
<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>
+
+ <paragraph xml-lang="en-US" id="par_id2854392"
role="code">STDEV.S(<embedvar href="text/scalc/01/ful_func.xhp#number255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#number255"/>
+ <paragraph id="par_id671585163972431" role="paragraph"
xml-lang="en-US">The parameters should specify at least two values.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2853933" role="paragraph"><item
type="input">=STDEV.S(A1:A50)</item> returns a standard deviation of the data
referenced.</paragraph>
</section>
@@ -231,9 +234,9 @@
<h2 id="hd_id3154522">STDEVPA</h2>
<paragraph xml-lang="en-US" id="par_id3149549"
role="paragraph"><ahelp hid="HID_FUNC_STABWNA">Calculates the standard
deviation based on the entire population.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3146851"
role="code">STDEVPA(Value1; Value2; ...; Value30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153109" role="paragraph">
- <emph>Value1, Value2, ..., Value30</emph> are values or ranges
representing an entire population. Text has the value 0.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3146851"
role="code">STDEVPA(<embedvar href="text/scalc/01/ful_func.xhp#number255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#number255"/>
+ <paragraph id="par_id961585163990543" role="paragraph"
xml-lang="en-US">Text has the value 0.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3145163" role="paragraph">
<item type="input">=STDEVPA(A1:A50)</item> returns the standard
deviation of the data referenced.</paragraph>
@@ -538,9 +541,10 @@
<h2 id="hd_id3153828">VAR</h2>
<paragraph xml-lang="en-US" id="par_id3159165"
role="paragraph"><ahelp hid="HID_FUNC_VARIANZ">Estimates the variance based on
a sample.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3153054"
role="code">VAR(Number1 ; Number2; ...; Number30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3148938" role="paragraph">
- <emph>Number1, Number2, ..., Number30</emph> are numerical values
or ranges representing a sample based on an entire population.</paragraph>
+
+ <paragraph xml-lang="en-US" id="par_id3153054"
role="code">VAR(<embedvar href="text/scalc/01/ful_func.xhp#number255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#number255"/>
+ <paragraph id="par_id721585215582420" role="paragraph"
xml-lang="en-US">The parameters should specify at least two values.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153575" role="paragraph">
<item type="input">=VAR(A1:A50)</item>
@@ -556,8 +560,9 @@
<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>
+ <paragraph xml-lang="en-US" id="par_id2953054"
role="code">VAR.S(<embedvar href="text/scalc/01/ful_func.xhp#number255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#number255"/>
+ <paragraph id="par_id891585215590756" role="paragraph"
xml-lang="en-US">The parameters should specify at least two values.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2953575" role="paragraph"><item
type="input">=VAR.S(A1:A50)</item></paragraph>
</section>
@@ -568,9 +573,9 @@
<h2 id="hd_id3151045">VARA</h2>
<paragraph xml-lang="en-US" id="par_id3155122"
role="paragraph"><ahelp hid="HID_FUNC_VARIANZA">Estimates a variance based on a
sample. The value of text is 0.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3149999"
role="code">VARA(Value1; Value2; ...; Value30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3158421" role="paragraph">
- <emph>Value1, Value2, ..., Value30</emph> are values or ranges
representing a sample derived from an entire population. Text has the value
0.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149999"
role="code">VARA(<embedvar href="text/scalc/01/ful_func.xhp#number255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#number255"/>
+ <paragraph id="par_id451585215586628" role="paragraph"
xml-lang="en-US">The parameters should specify at least two values.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3154279" role="paragraph">
<item type="input">=VARA(A1:A50)</item>
@@ -583,9 +588,8 @@
<h2 id="hd_id3166441">VARP</h2>
<paragraph xml-lang="en-US" id="par_id3159199"
role="paragraph"><ahelp hid="HID_FUNC_VARIANZEN">Calculates a variance based on
the entire population.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3147282"
role="code">VARP(Number1; Number2; ...; Number30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149793" role="paragraph">
- <emph>Number1, Number2, ..., Number30</emph> are numerical values
or ranges representing an entire population.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3147282"
role="code">VARP(<embedvar href="text/scalc/01/ful_func.xhp#number255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153385" role="paragraph">
<item type="input">=VARP(A1:A50)</item>
@@ -600,8 +604,8 @@
<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>
+ <paragraph xml-lang="en-US" id="par_id2947282" role="code">VAR.P(<embedvar
href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id2953385" role="paragraph"><item
type="input">=VAR.P(A1:A50)</item></paragraph>
</section>
@@ -612,9 +616,8 @@
<h2 id="hd_id3153688">VARPA</h2>
<paragraph xml-lang="en-US" id="par_id3149109"
role="paragraph"><ahelp hid="HID_FUNC_VARIANZENA">Calculates the variance based
on the entire population. The value of text is 0.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
- <paragraph xml-lang="en-US" id="par_id3149967"
role="code">VARPA(Value1; Value2; ...; Value30)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149920" role="paragraph">
- <emph>Value1, Value2, ..., Value30</emph> are values or ranges
representing an entire population.</paragraph>
+ <paragraph xml-lang="en-US" id="par_id3149967"
role="code">VARPA(<embedvar href="text/scalc/01/ful_func.xhp#number255_1"
markup="keep"/>)</paragraph>
+ <embed href="text/scalc/01/ful_func.xhp#number255"/>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3156203" role="paragraph">
<item type="input">=VARPA(A1:A50)</item>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
