Fix bug fdo#80431 Help entries for GAMMA functions

Provides help entries for functions GAMMA.DIST GAMMA.INV and GAMMALN.PRECISE

Change-Id: I9a675d40f7eca6a799e49706e062ea77e05feffd
Reviewed-on: https://gerrit.libreoffice.org/9916
Reviewed-by: Caolán McNamara <caolanm@redhat.com>
Tested-by: Caolán McNamara <caolanm@redhat.com>

1 files changed, 59 insertions, 0 deletions

diff --git a/source/text/scalc/01/04060182.xhp b/source/text/scalc/01/04060182.xhp
index f462edb160..3d595d033b 100644
--- a/source/text/scalc/01/04060182.xhp
+++ b/source/text/scalc/01/04060182.xhp
@@ -155,6 +155,29 @@
          <paragraph xml-lang="en-US" id="par_id3153331" role="paragraph" l10n="U" oldref="55">
             <item type="input">=GAMMAINV(0.8;1;1)</item> yields 1.61.</paragraph>
       </section>
+      
+      <section id="gammadotinv">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2914841"><bookmark_value>GAMMA.INV function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMAINV_MS" id="bm_id2919249" localize="false"/>
+<paragraph xml-lang="en-US" id="hd_id2914841" role="heading" level="2" l10n="U"
+                    oldref="47">GAMMA.INV</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2913932" role="paragraph" l10n="U" oldref="48"><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 GAMAINV and was introduced for interoperability with other office suites.</paragraph>
+         <paragraph xml-lang="en-US" id="hd_id2919949" role="heading" level="3" l10n="U"
+                    oldref="49">Syntax</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2915828" role="code" l10n="U" oldref="50">GAMMA.INV(Number; Alpha; Beta)</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2915138" role="paragraph" l10n="U" oldref="51">
+            <emph>Number</emph> is the probability value for which the inverse Gamma distribution is to be calculated.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2912785" role="paragraph" l10n="U" oldref="52">
+            <emph>Alpha</emph> is the parameter Alpha of the Gamma distribution.</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2914561" role="paragraph" l10n="U" oldref="53">
+            <emph>Beta</emph> is the parameter Beta of the Gamma distribution.</paragraph>
+         <paragraph xml-lang="en-US" id="hd_id2918734" role="heading" level="3" l10n="U"
+                    oldref="54">Example</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2913331" role="paragraph" l10n="U" oldref="55">
+            <item type="input">=GAMMA.INV(0.8;1;1)</item> yields 1.61.</paragraph>
+      </section>
       <section id="gammaln">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3154806"><bookmark_value>GAMMALN function</bookmark_value>
          <bookmark_value>natural logarithm of Gamma function</bookmark_value>
@@ -173,6 +196,24 @@
          <paragraph xml-lang="en-US" id="par_id3153730" role="paragraph" l10n="U" oldref="63">
             <item type="input">=GAMMALN(2)</item> yields 0.</paragraph>
       </section>
+      <section id="gammalnprecise">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2914806"><bookmark_value>GAMMALN.PRECISE function</bookmark_value>
+         <bookmark_value>natural logarithm of Gamma function</bookmark_value>
+</bookmark><comment>mw added one entry</comment>
+<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" l10n="U"
+                    oldref="57">GAMMALN.PRECISE</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2918572" role="paragraph" l10n="U" oldref="58"><ahelp hid="HID_FUNC_GAMMALN_MS">Returns the natural logarithm of the Gamma function: G(x).</ahelp></paragraph>
+         <paragraph xml-lang="en-US" id="hd_id2912999" role="heading" level="3" l10n="U"
+                    oldref="59">Syntax</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2913112" role="code" l10n="U" oldref="60">GAMMALN.PRECISE(Number)</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2914502" role="paragraph" l10n="U" oldref="61">
+            <emph>Number</emph> is the value for which the natural logarithm of the Gamma function is to be calculated.</paragraph>
+         <paragraph xml-lang="en-US" id="hd_id2913568" role="heading" level="3" l10n="U"
+                    oldref="62">Example</paragraph>
+         <paragraph xml-lang="en-US" id="par_id2913730" role="paragraph" l10n="U" oldref="63">
+            <item type="input">=GAMMALN.PRECISE(2)</item> yields 0.</paragraph>
+      </section>
       <section id="gammadist">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3150132"><bookmark_value>GAMMADIST function</bookmark_value>
 </bookmark>
@@ -197,6 +238,24 @@
          <paragraph xml-lang="en-US" id="par_id3145354" role="paragraph" l10n="U" oldref="74">
             <item type="input">=GAMMADIST(2;1;1;1)</item> yields 0.86.</paragraph>
       </section>
+      <section id="gammadotdist">
+<bookmark xml-lang="en-US" branch="index" id="bm_id240620142206421">
+<bookmark_value>GAMMA.DIST function</bookmark_value>
+</bookmark>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GAMMADIST_MS" id="bm_id2406201421290724" localize="false"/>
+<paragraph id="hd_id2406201422120061" role="heading" xml-lang="en-US" level="2">GAMMA.DIST</paragraph>
+<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 GAMADIST and was introduced for interoperability with other office suites.</paragraph>
+<paragraph id="hd_id2406201422383599" role="heading" xml-lang="en-US" level="3">Syntax</paragraph>
+<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>
+<paragraph id="par_id2406201422385590" role="paragraph" xml-lang="en-US"><emph>Alpha</emph> is the parameter Alpha of the Gamma distribution.</paragraph>
+<paragraph id="par_id2406201422390458" role="paragraph" xml-lang="en-US"><emph>Beta</emph> is the parameter Beta of the Gamma distribution</paragraph>
+<paragraph id="par_id2406201422391058" role="paragraph" xml-lang="en-US"><emph>C</emph> (optional) = 0 or False calculates the density function <emph>C</emph> = 1 or True calculates the distribution.</paragraph>
+<paragraph id="hd_id2406201422391870" role="heading" xml-lang="en-US" level="3">Example</paragraph>
+<paragraph id="par_id2406201422392251" role="paragraph" xml-lang="en-US"><item type="input">=GAMMA.DIST(2;1;1;1)</item> yields 0.86.</paragraph>
+</section>
       <section id="gauss">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3150272"><bookmark_value>GAUSS function</bookmark_value>
          <bookmark_value>normal distribution; standard</bookmark_value>