fdo#72197 Add Excel 2010 functions

MODE.SNGL, MODE.MULT, NEGBINOM.DIST, Z.TEST

Change-Id: I55eb05e1ebdb9dbc3ce9ae84e3cdacfdfa112091
Reviewed-on: https://gerrit.libreoffice.org/7776
Tested-by: LibreOffice gerrit bot <gerrit@libreoffice.org>
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Eike Rathke <erack@redhat.com>

1 files changed, 136 insertions, 0 deletions

diff --git a/sc/source/ui/src/scfuncs.src b/sc/source/ui/src/scfuncs.src
index e57b6186eb23..e7cfe2660f9c 100644
--- a/sc/source/ui/src/scfuncs.src
+++ b/sc/source/ui/src/scfuncs.src
@@ -5591,6 +5591,54 @@ Resource RID_SC_FUNCTION_DESCRIPTIONS2
             Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample." ;
         };
     };
+     // -=*# Resource for function MOD.SNGL #*=-
+    Resource SC_OPCODE_MODAL_VALUE_MS
+    {
+        String 1 // Description
+        {
+            Text [ en-US ] = "Returns the most common value in a sample." ;
+        };
+        ExtraData =
+        {
+            0;
+            ID_FUNCTION_GRP_STATISTIC;
+            U2S( HID_FUNC_MODAL_VALUE_MS );
+            VAR_ARGS;   0;
+            0;
+        };
+        String 2 // Name of Parameter 1
+        {
+            Text [ en-US ] = "number " ;
+        };
+        String 3 // Description of Parameter 1
+        {
+            Text [ en-US ] = "Number 1, number 2, ... are 1 to 30 numerical arguments which portray a sample." ;
+        };
+    };
+     // -=*# Resource for function MOD.MULTI #*=-
+    Resource SC_OPCODE_MODAL_VALUE_MULTI
+    {
+        String 1 // Description
+        {
+            Text [ en-US ] = "Returns the most common value in a sample." ;
+        };
+        ExtraData =
+        {
+            0;
+            ID_FUNCTION_GRP_STATISTIC;
+            U2S( HID_FUNC_MODAL_VALUE_MULTI );
+            VAR_ARGS;   0;
+            0;
+        };
+        String 2 // Name of Parameter 1
+        {
+            Text [ en-US ] = "number " ;
+        };
+        String 3 // Description of Parameter 1
+        {
+            Text [ en-US ] = "Number 1, number 2, ... are 1 to 254 numerical arguments which portray a sample." ;
+        };
+    };
      // -=*# Resource for function MEDIAN #*=-
     Resource SC_OPCODE_MEDIAN
     {
@@ -6471,6 +6519,54 @@ Resource RID_SC_FUNCTION_DESCRIPTIONS2
             Text [ en-US ] = "The success probability of a trial." ;
         };
     };
+     // -=*# Resource for function NEGBINOM.DIST #*=-
+    Resource SC_OPCODE_NEG_BINOM_DIST_MS
+    {
+        String 1 // Description
+        {
+            Text [ en-US ] = "Values of the negative binomial distribution." ;
+        };
+        ExtraData =
+        {
+            0;
+            ID_FUNCTION_GRP_STATISTIC;
+            U2S( HID_FUNC_NEGBINOMDIST_MS );
+            4;  0;  0;  0;  0;
+            0;
+        };
+        String 2 // Name of Parameter 1
+        {
+            Text [ en-US ] = "X" ;
+        };
+        String 3 // Description of Parameter 1
+        {
+            Text [ en-US ] = "The number of failures in the trial range." ;
+        };
+        String 4 // Name of Parameter 2
+        {
+            Text [ en-US ] = "R" ;
+        };
+        String 5 // Description of Parameter 2
+        {
+            Text [ en-US ] = "The number of successes in the trial sequence." ;
+        };
+        String 6 // Name of Parameter 3
+        {
+            Text [ en-US ] = "SP" ;
+        };
+        String 7 // Description of Parameter 3
+        {
+            Text [ en-US ] = "The success probability of a trial." ;
+        };
+        String 8 // Name of Parameter 4
+        {
+            Text [ en-US ] = "Cumulative" ;
+        };
+        String 9 // Description of Parameter 4
+        {
+            Text [ en-US ] = "0 or FALSE calculates the probability density function. Any other value or TRUE calculates the cumulative distribution function." ;
+        };
+    };
      // -=*# Resource for function KRITBINOM #*=-
     Resource SC_OPCODE_KRIT_BINOM
     {
@@ -8890,6 +8986,46 @@ Resource RID_SC_FUNCTION_DESCRIPTIONS2
             Text [ en-US ] = "The known standard deviation of the population. If omitted, the standard deviation of the given sample is used." ;
         };
     };
+     // -=*# Resource for function Z.TEST #*=-
+    Resource SC_OPCODE_Z_TEST_MS
+    {
+        String 1 // Description
+        {
+            Text [ en-US ] = "Calculates the probability of observing a z-statistic greater than the one computed based on a sample." ;
+        };
+        ExtraData =
+        {
+            0;
+            ID_FUNCTION_GRP_STATISTIC;
+            U2S( HID_FUNC_Z_TEST_MS );
+            3;  0;  0;  1;
+            0;
+        };
+        String 2 // Name of Parameter 1
+        {
+            Text [ en-US ] = "data" ;
+        };
+        String 3 // Description of Parameter 1
+        {
+            Text [ en-US ] = "The given sample, drawn from a normally distributed population." ;
+        };
+        String 4 // Name of Parameter 2
+        {
+            Text [ en-US ] = "mu" ;
+        };
+        String 5 // Description of Parameter 2
+        {
+            Text [ en-US ] = "The known mean of the population." ;
+        };
+        String 6 // Name of Parameter 3
+        {
+            Text [ en-US ] = "sigma" ;
+        };
+        String 7 // Description of Parameter 3
+        {
+            Text [ en-US ] = "The known standard deviation of the population. If omitted, the standard deviation of the given sample is used." ;
+        };
+    };
      // -=*# Resource for function CHITEST #*=-
     Resource SC_OPCODE_CHI_TEST
     {