From f2cb873631b8b21b54a55beaba532f4bd616a9c6 Mon Sep 17 00:00:00 2001 From: Marina Plakalovic Date: Fri, 14 Dec 2012 23:40:18 +0100 Subject: calcishmakkica: #i90269# #i95144# #i101466# implement SUMIFS, AVERAGEIFS, COUNTIFS Merged from Apache OO with adaptions. http://svn.apache.org/viewvc?rev=1381447&view=rev Original Apache OO committer: Andrew Rist Original Author: Marina Plakalovic Original Committer: Eike Rathke [er] # HG changeset patch # User Eike Rathke [er] # Date 1288810126 -3600 # Node ID 02cf226fcde498f6fd926d45df497e9fb412fe0f # Parent 528da6bfd0daed4355d745590d5ac3a319b08fb4 Change-Id: I08754653cd2ff20536ad3e9f260f747cb127ccdd --- formula/inc/formula/compiler.hrc | 7 +++++-- formula/inc/formula/opcode.hxx | 5 ++++- 2 files changed, 9 insertions(+), 3 deletions(-) (limited to 'formula/inc') 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, -- cgit