(04060182.xhp) Include square brackets in syntax sections to indicate optional parameters.

Also updated GEOMEAN() and HARMEAN() to cater for up to 255 arguments rather than 30.

Change-Id: I706f1f8426b04b3ec06064d505116151b55f2b00
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95240
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
(cherry picked from commit 8a1427c35e2392ecfe8ecaee84ab1c24fa5b87ae)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95733
Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>

1 files changed, 10 insertions, 12 deletions

diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp
index c02ddbbc00..b6a78433b0 100644
--- a/source/text/scalc/01/04060182.xhp
+++ b/source/text/scalc/01/04060182.xhp
@@ -172,7 +172,7 @@
     <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_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>
     <paragraph xml-lang="en-US" id="par_id2950029" role="paragraph"><emph>degreesFreedom1</emph> is the degrees of freedom in the numerator in the F distribution.</paragraph>
     <paragraph xml-lang="en-US" id="par_id2946877" role="paragraph"><emph>degreesFreedom2</emph> is the degrees of freedom in the denominator in the F distribution.</paragraph>
@@ -285,7 +285,7 @@
          <paragraph xml-lang="en-US" id="par_id3155931" role="paragraph"><ahelp hid="HID_FUNC_GAMMAVERT">Returns the values of a Gamma distribution.</ahelp></paragraph>
          <paragraph xml-lang="en-US" id="par_id0119200903333675" role="paragraph">The inverse function is GAMMAINV.</paragraph>
          <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-         <paragraph xml-lang="en-US" id="par_id3155436" role="code">GAMMADIST(Number; Alpha; Beta; C)</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3155436" role="code">GAMMADIST(Number; Alpha; Beta [; C])</paragraph>
          <paragraph xml-lang="en-US" id="par_id3150571" role="paragraph">
             <emph>Number</emph> is the value for which the Gamma distribution is to be calculated.</paragraph>
          <paragraph xml-lang="en-US" id="par_id3145295" role="paragraph">
@@ -343,9 +343,8 @@
 <h2 id="hd_id3148425">GEOMEAN</h2>
          <paragraph xml-lang="en-US" id="par_id3156257" role="paragraph"><ahelp hid="HID_FUNC_GEOMITTEL">Returns the geometric mean of a sample.</ahelp></paragraph>
          <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-         <paragraph xml-lang="en-US" id="par_id3153720" role="code">GEOMEAN(Number1; Number2; ...; Number30)</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3152585" role="paragraph">
-            <emph>Number1, Number2, ..., Number30</emph> are numeric arguments or ranges that represent a random sample.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3153720" role="code">GEOMEAN(<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_id3149819" role="paragraph">
             <item type="input">=GEOMEAN(23;46;69)</item> = 41.79. The geometric mean value of this random sample is therefore 41.79.</paragraph>
@@ -374,7 +373,7 @@
 <h2 id="hd_id3153216">ZTEST</h2>
          <paragraph xml-lang="en-US" id="par_id3150758" role="paragraph"><ahelp hid="HID_FUNC_GTEST">Calculates the probability of observing a z-statistic greater than the one computed based on a sample.</ahelp></paragraph>
          <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-         <paragraph xml-lang="en-US" id="par_id3153274" role="code">ZTEST(Data; mu; Sigma)</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3153274" role="code">ZTEST(Data; mu [; Sigma])</paragraph>
          <paragraph xml-lang="en-US" id="par_id3156109" role="paragraph">
             <emph>Data</emph> is the given sample, drawn from a normally distributed population.</paragraph>
          <paragraph xml-lang="en-US" id="par_id3149977" role="paragraph">
@@ -391,7 +390,7 @@
 <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_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>
 <paragraph xml-lang="en-US" id="par_id2949977" role="paragraph"><emph>mu</emph> is the known mean of the population.</paragraph>
 <paragraph xml-lang="en-US" id="par_id2954740" role="paragraph"><emph>Sigma</emph> (optional) is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used.</paragraph>
@@ -406,10 +405,9 @@
 <h2 id="hd_id3153623">HARMEAN</h2>
          <paragraph xml-lang="en-US" id="par_id3155102" role="paragraph"><ahelp hid="HID_FUNC_HARMITTEL">Returns the harmonic mean of a data set.</ahelp></paragraph>
          <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-         <paragraph xml-lang="en-US" id="par_id3149287" role="code">HARMEAN(Number1; Number2; ...; Number30)</paragraph>
-         <paragraph xml-lang="en-US" id="par_id3154303" role="paragraph">
-            <emph>Number1, Number2, ..., Number30</emph> are up to 30 values or ranges, that can be used to calculate the harmonic mean.</paragraph>
-        <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+         <paragraph xml-lang="en-US" id="par_id3149287" role="code">HARMEAN(<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_id3146093" role="paragraph">
             <item type="input">=HARMEAN(23;46;69)</item> = 37.64. The harmonic mean of this random sample is thus 37.64</paragraph>
       </section>
@@ -422,7 +420,7 @@
          <paragraph xml-lang="en-US" id="par_id3159341" role="paragraph"><ahelp hid="HID_FUNC_HYPGEOMVERT">Returns the hypergeometric distribution.</ahelp></paragraph>
          <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
 
-         <paragraph xml-lang="en-US" id="par_id3155388" role="code">HYPGEOMDIST(X; NSample; Successes; NPopulation[; Cumulative])</paragraph>
+         <paragraph xml-lang="en-US" id="par_id3155388" role="code">HYPGEOMDIST(X; NSample; Successes; NPopulation [; Cumulative])</paragraph>
          <paragraph xml-lang="en-US" id="par_id3154933" role="paragraph">
             <emph>X</emph> is the number of results achieved in the random sample.</paragraph>
          <paragraph xml-lang="en-US" id="par_id3153106" role="paragraph">