diff options
Diffstat (limited to 'formula/inc')
| -rw-r--r-- | formula/inc/formula/compiler.hrc | 7 | ||||
| -rw-r--r-- | formula/inc/formula/opcode.hxx | 5 |
2 files changed, 9 insertions, 3 deletions
diff --git a/formula/inc/formula/compiler.hrc b/formula/inc/formula/compiler.hrc index 9ae1c1850a08..582e3a589c93 100644 --- a/formula/inc/formula/compiler.hrc +++ b/formula/inc/formula/compiler.hrc @@ -393,8 +393,11 @@ #define SC_OPCODE_GET_DATEDIF 400 #define SC_OPCODE_XOR 401 #define SC_OPCODE_AVERAGE_IF 402 -#define SC_OPCODE_STOP_2_PAR 403 -#define SC_OPCODE_LAST_OPCODE_ID 403 /* last OpCode */ +#define SC_OPCODE_SUM_IFS 403 +#define SC_OPCODE_AVERAGE_IFS 404 +#define SC_OPCODE_COUNT_IFS 405 +#define SC_OPCODE_STOP_2_PAR 406 +#define SC_OPCODE_LAST_OPCODE_ID 405 /* last OpCode */ /*** Internal ***/ #define SC_OPCODE_INTERNAL_BEGIN 9999 diff --git a/formula/inc/formula/opcode.hxx b/formula/inc/formula/opcode.hxx index 046d25b752ad..cd1831b89637 100644 --- a/formula/inc/formula/opcode.hxx +++ b/formula/inc/formula/opcode.hxx @@ -274,7 +274,10 @@ enum OpCodeEnum ocCountEmptyCells = SC_OPCODE_COUNT_EMPTY_CELLS, ocCountIf = SC_OPCODE_COUNT_IF, ocSumIf = SC_OPCODE_SUM_IF, - ocAverageIf = SC_OPCODE_AVERAGE_IF, + ocAverageIf = SC_OPCODE_AVERAGE_IF, + ocSumIfs = SC_OPCODE_SUM_IFS, + ocAverageIfs = SC_OPCODE_AVERAGE_IFS, + ocCountIfs = SC_OPCODE_COUNT_IFS, ocLookup = SC_OPCODE_LOOKUP, ocVLookup = SC_OPCODE_V_LOOKUP, ocHLookup = SC_OPCODE_H_LOOKUP, |