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 /include/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 'include/formula')
| -rw-r--r-- | include/formula/compiler.hrc | 7 | ||||
| -rw-r--r-- | include/formula/opcode.hxx | 5 |
2 files changed, 11 insertions, 1 deletions
diff --git a/include/formula/compiler.hrc b/include/formula/compiler.hrc index 1cf1c2d44f2f..4f2f4e6d67c8 100644 --- a/include/formula/compiler.hrc +++ b/include/formula/compiler.hrc @@ -425,8 +425,13 @@ #define SC_OPCODE_CHISQ_INV_MS 427 #define SC_OPCODE_CONFIDENCE_N 428 #define SC_OPCODE_CONFIDENCE_T 429 +#define SC_OPCODE_F_DIST_LT 430 +#define SC_OPCODE_F_DIST_RT 431 +#define SC_OPCODE_F_INV_LT 432 +#define SC_OPCODE_F_INV_RT 433 +#define SC_OPCODE_F_TEST_MS 434 -#define SC_OPCODE_STOP_2_PAR 430 /* last function with two or more parameters' OpCode + 1 */ +#define SC_OPCODE_STOP_2_PAR 435 /* last function with two or more parameters' OpCode + 1 */ #define SC_OPCODE_STOP_FUNCTION SC_OPCODE_STOP_2_PAR /* last function's OpCode + 1 */ #define SC_OPCODE_LAST_OPCODE_ID (SC_OPCODE_STOP_FUNCTION - 1) /* last OpCode */ diff --git a/include/formula/opcode.hxx b/include/formula/opcode.hxx index 75fdb9210972..b5953f769765 100644 --- a/include/formula/opcode.hxx +++ b/include/formula/opcode.hxx @@ -326,6 +326,8 @@ enum OpCodeEnum ocLogNormDist = SC_OPCODE_LOG_NORM_DIST, ocTDist = SC_OPCODE_T_DIST, ocFDist = SC_OPCODE_F_DIST, + ocFDist_LT = SC_OPCODE_F_DIST_LT, + ocFDist_RT = SC_OPCODE_F_DIST_RT, ocChiDist = SC_OPCODE_CHI_DIST, ocChiDist_MS = SC_OPCODE_CHI_DIST_MS, ocChiSqDist = SC_OPCODE_CHISQ_DIST, @@ -359,6 +361,7 @@ enum OpCodeEnum ocConfidence_N = SC_OPCODE_CONFIDENCE_N, ocConfidence_T = SC_OPCODE_CONFIDENCE_T, ocFTest = SC_OPCODE_F_TEST, + ocFTest_MS = SC_OPCODE_F_TEST_MS, ocTrimMean = SC_OPCODE_TRIM_MEAN, ocProb = SC_OPCODE_PROB, ocCorrel = SC_OPCODE_CORREL, @@ -381,6 +384,8 @@ enum OpCodeEnum ocGammaInv = SC_OPCODE_GAMMA_INV, ocTInv = SC_OPCODE_T_INV, ocFInv = SC_OPCODE_F_INV, + ocFInv_LT = SC_OPCODE_F_INV_LT, + ocFInv_RT = SC_OPCODE_F_INV_RT, ocChiTest = SC_OPCODE_CHI_TEST, ocChiTest_MS = SC_OPCODE_CHI_TEST_MS, ocLogInv = SC_OPCODE_LOG_INV, |