diff options
author | Winfried Donkers <winfrieddonkers@libreoffice.org> | 2013-11-17 10:54:37 +0100 |
---|---|---|
committer | Eike Rathke <erack@redhat.com> | 2013-11-20 12:25:18 -0600 |
commit | 5a1fa549520aad341b1b8cfe59b1e1b6ed3e4164 (patch) | |
tree | 893c20737f93ebfa44363f37b159258775e23617 /formula | |
parent | b3ecd33b45d131e63bff287ae564c4225a946959 (diff) |
fdo#71436 add Excel 2010 functions for F-distribution
Added F.DIST.RT, F.INV.RT, F.TEST, which are renamed
FDIST, FINV and FTEST and handle the right tail F-distribution.
Added F.DIST and F.INV, which are new functions and handle
the left tail F-distribution.
Change-Id: Ia7fa26a25f3188249f280733d6111951e2600704
Reviewed-on: https://gerrit.libreoffice.org/6701
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Eike Rathke <erack@redhat.com>
Diffstat (limited to 'formula')
-rw-r--r-- | formula/source/core/resource/core_resource.src | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/formula/source/core/resource/core_resource.src b/formula/source/core/resource/core_resource.src index 536de400c235..609928bf5430 100644 --- a/formula/source/core/resource/core_resource.src +++ b/formula/source/core/resource/core_resource.src @@ -284,6 +284,8 @@ Resource RID_STRLIST_FUNCTION_NAMES_ENGLISH_ODFF String SC_OPCODE_LOG_NORM_DIST { Text = "LOGNORMDIST" ; }; String SC_OPCODE_T_DIST { Text = "LEGACY.TDIST" ; }; String SC_OPCODE_F_DIST { Text = "LEGACY.FDIST" ; }; + String SC_OPCODE_F_DIST_LT { Text = "COM.MICROSOFT.F.DIST" ; }; + String SC_OPCODE_F_DIST_RT { Text = "COM.MICROSOFT.F.DIST.RT" ; }; String SC_OPCODE_CHI_DIST { Text = "LEGACY.CHIDIST" ; }; String SC_OPCODE_CHI_DIST_MS { Text = "COM.MICROSOFT.CHISQ.DIST.RT" ; }; String SC_OPCODE_WEIBULL { Text = "WEIBULL" ; }; @@ -314,6 +316,7 @@ Resource RID_STRLIST_FUNCTION_NAMES_ENGLISH_ODFF String SC_OPCODE_CONFIDENCE_N { Text = "COM.MICROSOFT.CONFIDENCE.NORM" ; }; String SC_OPCODE_CONFIDENCE_T { Text = "COM.MICROSOFT.CONFIDENCE.T" ; }; String SC_OPCODE_F_TEST { Text = "FTEST" ; }; + String SC_OPCODE_F_TEST_MS { Text = "COM.MICROSOFT.F.TEST" ; }; String SC_OPCODE_TRIM_MEAN { Text = "TRIMMEAN" ; }; String SC_OPCODE_PROB { Text = "PROB" ; }; String SC_OPCODE_CORREL { Text = "CORREL" ; }; @@ -336,6 +339,8 @@ Resource RID_STRLIST_FUNCTION_NAMES_ENGLISH_ODFF String SC_OPCODE_GAMMA_INV { Text = "GAMMAINV" ; }; String SC_OPCODE_T_INV { Text = "TINV" ; }; String SC_OPCODE_F_INV { Text = "LEGACY.FINV" ; }; + String SC_OPCODE_F_INV_LT { Text = "COM.MICROSOFT.F.INV" ; }; + String SC_OPCODE_F_INV_RT { Text = "COM.MICROSOFT.F.INV.RT" ; }; String SC_OPCODE_CHI_TEST { Text = "LEGACY.CHITEST" ; }; String SC_OPCODE_CHI_TEST_MS { Text = "COM.MICROSOFT.CHISQ.TEST" ; }; String SC_OPCODE_LOG_INV { Text = "LOGINV" ; }; @@ -647,6 +652,8 @@ Resource RID_STRLIST_FUNCTION_NAMES_ENGLISH_OOXML String SC_OPCODE_LOG_NORM_DIST { Text = "LOGNORMDIST" ; }; String SC_OPCODE_T_DIST { Text = "TDIST" ; }; String SC_OPCODE_F_DIST { Text = "FDIST" ; }; + String SC_OPCODE_F_DIST_LT { Text = "_xlfn.F.DIST" ; }; + String SC_OPCODE_F_DIST_RT { Text = "_xlfn.F.DIST.RT" ; }; String SC_OPCODE_CHI_DIST { Text = "CHIDIST" ; }; String SC_OPCODE_CHI_DIST_MS { Text = "_xlfn.CHISQ.DIST.RT" ; }; String SC_OPCODE_WEIBULL { Text = "WEIBULL" ; }; @@ -677,6 +684,7 @@ Resource RID_STRLIST_FUNCTION_NAMES_ENGLISH_OOXML String SC_OPCODE_CONFIDENCE_N { Text = "_xlfn.CONFIDENCE.NORM" ; }; String SC_OPCODE_CONFIDENCE_T { Text = "_xlfn.CONFIDENCE.T" ; }; String SC_OPCODE_F_TEST { Text = "FTEST" ; }; + String SC_OPCODE_F_TEST_MS { Text = "_xlfn.F.TEST" ; }; String SC_OPCODE_TRIM_MEAN { Text = "TRIMMEAN" ; }; String SC_OPCODE_PROB { Text = "PROB" ; }; String SC_OPCODE_CORREL { Text = "CORREL" ; }; @@ -699,6 +707,8 @@ Resource RID_STRLIST_FUNCTION_NAMES_ENGLISH_OOXML String SC_OPCODE_GAMMA_INV { Text = "GAMMAINV" ; }; String SC_OPCODE_T_INV { Text = "TINV" ; }; String SC_OPCODE_F_INV { Text = "FINV" ; }; + String SC_OPCODE_F_INV_LT { Text = "_xlfn.F.INV" ; }; + String SC_OPCODE_F_INV_RT { Text = "_xlfn.F.INV.RT" ; }; String SC_OPCODE_CHI_TEST { Text = "CHITEST" ; }; String SC_OPCODE_CHI_TEST_MS { Text = "_xlfn.CHISQ.TEST" ; }; String SC_OPCODE_LOG_INV { Text = "LOGINV" ; }; @@ -1012,6 +1022,8 @@ Resource RID_STRLIST_FUNCTION_NAMES_ENGLISH String SC_OPCODE_LOG_NORM_DIST { Text = "LOGNORMDIST" ; }; String SC_OPCODE_T_DIST { Text = "TDIST" ; }; String SC_OPCODE_F_DIST { Text = "FDIST" ; }; + String SC_OPCODE_F_DIST_LT { Text = "F.DIST" ; }; + String SC_OPCODE_F_DIST_RT { Text = "F.DIST.RT" ; }; String SC_OPCODE_CHI_DIST { Text = "CHIDIST" ; }; String SC_OPCODE_CHI_DIST_MS { Text = "CHISQ.DIST.RT" ; }; String SC_OPCODE_WEIBULL { Text = "WEIBULL" ; }; @@ -1042,6 +1054,7 @@ Resource RID_STRLIST_FUNCTION_NAMES_ENGLISH String SC_OPCODE_CONFIDENCE_N { Text = "CONFIDENCE.NORM" ; }; String SC_OPCODE_CONFIDENCE_T { Text = "CONFIDENCE.T" ; }; String SC_OPCODE_F_TEST { Text = "FTEST" ; }; + String SC_OPCODE_F_TEST_MS { Text = "F.TEST" ; }; String SC_OPCODE_TRIM_MEAN { Text = "TRIMMEAN" ; }; String SC_OPCODE_PROB { Text = "PROB" ; }; String SC_OPCODE_CORREL { Text = "CORREL" ; }; @@ -1064,6 +1077,8 @@ Resource RID_STRLIST_FUNCTION_NAMES_ENGLISH String SC_OPCODE_GAMMA_INV { Text = "GAMMAINV" ; }; String SC_OPCODE_T_INV { Text = "TINV" ; }; String SC_OPCODE_F_INV { Text = "FINV" ; }; + String SC_OPCODE_F_INV_LT { Text = "F.INV" ; }; + String SC_OPCODE_F_INV_RT { Text = "F.INV.RT" ; }; String SC_OPCODE_CHI_TEST { Text = "CHITEST" ; }; String SC_OPCODE_CHI_TEST_MS { Text = "CHISQ.TEST" ; }; String SC_OPCODE_LOG_INV { Text = "LOGINV" ; }; @@ -2085,6 +2100,14 @@ Resource RID_STRLIST_FUNCTION_NAMES { Text [ en-US ] = "FDIST" ; }; + String SC_OPCODE_F_DIST_LT + { + Text [ en-US ] = "F.DIST" ; + }; + String SC_OPCODE_F_DIST_RT + { + Text [ en-US ] = "F.DIST.RT" ; + }; String SC_OPCODE_CHI_DIST { Text [ en-US ] = "CHIDIST" ; @@ -2205,6 +2228,10 @@ Resource RID_STRLIST_FUNCTION_NAMES { Text [ en-US ] = "FTEST" ; }; + String SC_OPCODE_F_TEST_MS + { + Text [ en-US ] = "F.TEST" ; + }; String SC_OPCODE_TRIM_MEAN { Text [ en-US ] = "TRIMMEAN" ; @@ -2293,6 +2320,14 @@ Resource RID_STRLIST_FUNCTION_NAMES { Text [ en-US ] = "FINV" ; }; + String SC_OPCODE_F_INV_LT + { + Text [ en-US ] = "F.INV" ; + }; + String SC_OPCODE_F_INV_RT + { + Text [ en-US ] = "F.INV.RT" ; + }; String SC_OPCODE_CHI_TEST { Text [ en-US ] = "CHITEST" ; |