diff options
| author | Marina Plakalovic <makkica@openoffice.org> | 2012-12-14 23:40:18 +0100 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2012-12-15 21:42:39 +0100 |
| commit | f2cb873631b8b21b54a55beaba532f4bd616a9c6 (patch) | |
| tree | 09c0fecd4bd9b265069dc512cd67db4674626220 /sc/source/core/inc | |
| parent | ef54346f1912c635d74c7dee8703f5f46647881d (diff) | |
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 <arist@apache.org>
Original Author: Marina Plakalovic <makkica@openoffice.org>
Original Committer: Eike Rathke [er] <eike.rathke@oracle.com>
# HG changeset patch
# User Eike Rathke [er] <eike.rathke@oracle.com>
# Date 1288810126 -3600
# Node ID 02cf226fcde498f6fd926d45df497e9fb412fe0f
# Parent 528da6bfd0daed4355d745590d5ac3a319b08fb4
Change-Id: I08754653cd2ff20536ad3e9f260f747cb127ccdd
Diffstat (limited to 'sc/source/core/inc')
| -rw-r--r-- | sc/source/core/inc/interpre.hxx | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sc/source/core/inc/interpre.hxx b/sc/source/core/inc/interpre.hxx index 1c408f89ae75..762b818eadce 100644 --- a/sc/source/core/inc/interpre.hxx +++ b/sc/source/core/inc/interpre.hxx @@ -74,6 +74,13 @@ enum ScIterFuncIf ifAVERAGEIF // Conditional average }; +enum ScIterFuncIfs +{ + ifSUMIFS, // Multi-Conditional sum + ifAVERAGEIFS, // Multi-Conditional average + ifCOUNTIFS // Multi-Conditional count +}; + struct FormulaTokenRef_less { bool operator () ( const formula::FormulaConstTokenRef& r1, const formula::FormulaConstTokenRef& r2 ) const @@ -483,6 +490,10 @@ double IterateParametersIf( ScIterFuncIf ); void ScCountIf(); void ScSumIf(); void ScAverageIf(); +double IterateParametersIfs( ScIterFuncIfs ); +void ScSumIfs(); +void ScAverageIfs(); +void ScCountIfs(); void ScCountEmptyCells(); void ScLookup(); void ScHLookup(); |