fdo#73146 Add Excel 2010 functions

PERCENTILE.EXC, PERCENTILE.INC
PERCENTRANK.EXC, PERCENTRANK.INC
QUARTILE.EXC, QUARTILE.INC
RANK.EQ, RANK.AVG

Function ScInterpreter::ScRank() has been rewritten to give the function
the same way of computing as the related functions in this patch.

Change-Id: If3096b265bd47ca5f4afcab7ff746f7c8511df82
Reviewed-on: https://gerrit.libreoffice.org/7319
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Eike Rathke <erack@redhat.com>

1 files changed, 56 insertions, 0 deletions

diff --git a/formula/source/core/resource/core_resource.src b/formula/source/core/resource/core_resource.src
index 4f7444167d02..d3b3ea351300 100644
--- a/formula/source/core/resource/core_resource.src
+++ b/formula/source/core/resource/core_resource.src
@@ -319,6 +319,14 @@ Resource RID_STRLIST_FUNCTION_NAMES_ENGLISH_ODFF
     String SC_OPCODE_RANK { Text = "RANK" ; };
     String SC_OPCODE_PERCENTILE { Text = "PERCENTILE" ; };
     String SC_OPCODE_PERCENT_RANK { Text = "PERCENTRANK" ; };
+    String SC_OPCODE_PERCENTILE_INC { Text = "COM.MICROSOFT.PERCENTILE.INC" ; };
+    String SC_OPCODE_PERCENT_RANK_INC { Text = "COM.MICROSOFT.PERCENTRANK.INC" ; };
+    String SC_OPCODE_QUARTILE_INC { Text = "COM.MICROSOFT.QUARTILE.INC" ; };
+    String SC_OPCODE_RANK_EQ { Text = "COM.MICROSOFT.RANK.EQ" ; };
+    String SC_OPCODE_PERCENTILE_EXC { Text = "COM.MICROSOFT.PERCENTILE.EXC" ; };
+    String SC_OPCODE_PERCENT_RANK_EXC { Text = "COM.MICROSOFT.PERCENTRANK.EXC" ; };
+    String SC_OPCODE_QUARTILE_EXC { Text = "COM.MICROSOFT.QUARTILE.EXC" ; };
+    String SC_OPCODE_RANK_AVG { Text = "COM.MICROSOFT.RANK.AVG" ; };
     String SC_OPCODE_LARGE { Text = "LARGE" ; };
     String SC_OPCODE_SMALL { Text = "SMALL" ; };
     String SC_OPCODE_FREQUENCY { Text = "FREQUENCY" ; };
@@ -705,6 +713,14 @@ Resource RID_STRLIST_FUNCTION_NAMES_ENGLISH_OOXML
     String SC_OPCODE_RANK { Text = "RANK" ; };
     String SC_OPCODE_PERCENTILE { Text = "PERCENTILE" ; };
     String SC_OPCODE_PERCENT_RANK { Text = "PERCENTRANK" ; };
+    String SC_OPCODE_PERCENTILE_INC { Text = "_xlfn.PERCENTILE.INC" ; };
+    String SC_OPCODE_PERCENT_RANK_INC { Text = "_xlfn.PERCENTRANK.INC" ; };
+    String SC_OPCODE_QUARTILE_INC { Text = "_xlfn.QUARTILE.INC" ; };
+    String SC_OPCODE_RANK_EQ { Text = "_xlfn.RANK.EQ" ; };
+    String SC_OPCODE_PERCENTILE_EXC { Text = "_xlfn.PERCENTILE.EXC" ; };
+    String SC_OPCODE_PERCENT_RANK_EXC { Text = "_xlfn.PERCENTRANK.EXC" ; };
+    String SC_OPCODE_QUARTILE_EXC { Text = "_xlfn.QUARTILE.EXC" ; };
+    String SC_OPCODE_RANK_AVG { Text = "_xlfn.RANK.AVG" ; };
     String SC_OPCODE_LARGE { Text = "LARGE" ; };
     String SC_OPCODE_SMALL { Text = "SMALL" ; };
     String SC_OPCODE_FREQUENCY { Text = "FREQUENCY" ; };
@@ -1093,6 +1109,14 @@ Resource RID_STRLIST_FUNCTION_NAMES_ENGLISH
     String SC_OPCODE_RANK { Text = "RANK" ; };
     String SC_OPCODE_PERCENTILE { Text = "PERCENTILE" ; };
     String SC_OPCODE_PERCENT_RANK { Text = "PERCENTRANK" ; };
+    String SC_OPCODE_PERCENTILE_INC { Text = "PERCENTILE.INC" ; };
+    String SC_OPCODE_PERCENT_RANK_INC { Text = "PERCENTRANK.INC" ; };
+    String SC_OPCODE_QUARTILE_INC { Text = "QUARTILE.INC" ; };
+    String SC_OPCODE_RANK_EQ { Text = "RANK.EQ" ; };
+    String SC_OPCODE_PERCENTILE_EXC { Text = "PERCENTILE.EXC" ; };
+    String SC_OPCODE_PERCENT_RANK_EXC { Text = "PERCENTRANK.EXC" ; };
+    String SC_OPCODE_QUARTILE_EXC { Text = "QUARTILE.EXC" ; };
+    String SC_OPCODE_RANK_AVG { Text = "RANK.AVG" ; };
     String SC_OPCODE_LARGE { Text = "LARGE" ; };
     String SC_OPCODE_SMALL { Text = "SMALL" ; };
     String SC_OPCODE_FREQUENCY { Text = "FREQUENCY" ; };
@@ -2297,6 +2321,38 @@ Resource RID_STRLIST_FUNCTION_NAMES
     {
         Text [ en-US ] = "PERCENTRANK" ;
     };
+    String SC_OPCODE_PERCENTILE_INC
+    {
+        Text [ en-US ] = "PERCENTILE.INC" ;
+    };
+    String SC_OPCODE_PERCENT_RANK_INC
+    {
+        Text [ en-US ] = "PERCENTRANK.INC" ;
+    };
+    String SC_OPCODE_QUARTILE_INC
+    {
+        Text [ en-US ] = "QUARTILE.INC" ;
+    };
+    String SC_OPCODE_RANK_EQ
+    {
+        Text [ en-US ] = "RANK.EQ" ;
+    };
+    String SC_OPCODE_PERCENTILE_EXC
+    {
+        Text [ en-US ] = "PERCENTILE.EXC" ;
+    };
+    String SC_OPCODE_PERCENT_RANK_EXC
+    {
+        Text [ en-US ] = "PERCENTRANK.EXC" ;
+    };
+    String SC_OPCODE_QUARTILE_EXC
+    {
+        Text [ en-US ] = "QUARTILE.EXC" ;
+    };
+    String SC_OPCODE_RANK_AVG
+    {
+        Text [ en-US ] = "RANK.AVG" ;
+    };
     String SC_OPCODE_LARGE
     {
         Text [ en-US ] = "LARGE" ;