summaryrefslogtreecommitdiff
path: root/formula/source
diff options
context:
space:
mode:
authorWinfried Donkers <winfrieddonkers@libreoffice.org>2014-01-08 17:15:22 +0100
committerEike Rathke <erack@redhat.com>2014-01-30 12:30:56 +0000
commit8185ecf65addcd0c10eda6863a849e39b93684d3 (patch)
tree404ce7ccdfbd870d5187ccad5417ab101b39cfed /formula/source
parentf5115e33e4c5e49e9b79ed32fccc193a99c3dc30 (diff)
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>
Diffstat (limited to 'formula/source')
-rw-r--r--formula/source/core/resource/core_resource.src56
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" ;