From e22ee2eda6415961d879f58407bf59604e46dbd3 Mon Sep 17 00:00:00 2001
From: Steve Fanning <stevemfanning.wh@gmail.com>
Date: Thu, 26 Mar 2020 10:47:29 -0300
Subject: 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.hallot@libreoffice.org>
---
 source/text/scalc/01/04060185.xhp | 71 ++++++++++++++++++++-------------------
 1 file changed, 37 insertions(+), 34 deletions(-)

(limited to 'source/text/scalc/01/04060185.xhp')

diff --git a/source/text/scalc/01/04060185.xhp b/source/text/scalc/01/04060185.xhp
index 056953c3f7..38a0157d2d 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>
-- 
cgit