diff options
| author | Marina Plakalovic <makkica@openoffice.org> | 2012-12-14 20:42:52 +0100 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2012-12-15 21:42:39 +0100 |
| commit | fff5031898f743c3adf5fcc35bc95fff48094ebb (patch) | |
| tree | 1960204911472480b34d3135bdaa044869471434 /sc/source/core/inc | |
| parent | 9c321f0d21281cc6b1d5303f24de00d5bb2849db (diff) | |
calcishmakkica: #i101466# implement AVERAGEIF
Merged from Apache OO with adaptions.
http://svn.apache.org/viewvc?rev=1381445&view=rev
Original Apache OO committer: Andrew Rist <arist@apache.org>
Original Author: Marina Plakalovic <makkica@openoffice.org>
Original Author: Eike Rathke [er] <eike.rathke@oracle.com>
Original Committer: Eike Rathke [er] <eike.rathke@oracle.com>
slightly reworked patch by <makkica>
# HG changeset patch
# User Eike Rathke [er] <eike.rathke@oracle.com>
# Date 1284055400 -7200
# Node ID 237cb91dd986ff11eb100cc631206cda102e91f7
# Parent 1c32319bb02fdf173de6a609fca9f2e9c9f4c73a
Change-Id: Id168462272dc8d618513319ebab41fde5c728b08
Diffstat (limited to 'sc/source/core/inc')
| -rw-r--r-- | sc/source/core/inc/interpre.hxx | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sc/source/core/inc/interpre.hxx b/sc/source/core/inc/interpre.hxx index 24230dab8aa7..1c408f89ae75 100644 --- a/sc/source/core/inc/interpre.hxx +++ b/sc/source/core/inc/interpre.hxx @@ -68,6 +68,12 @@ enum ScIterFunc { ifMAX // Maximum }; +enum ScIterFuncIf +{ + ifSUMIF, // Conditional sum + ifAVERAGEIF // Conditional average +}; + struct FormulaTokenRef_less { bool operator () ( const formula::FormulaConstTokenRef& r1, const formula::FormulaConstTokenRef& r2 ) const @@ -473,8 +479,10 @@ void ScColumn(); void ScRow(); void ScTable(); void ScMatch(); +double IterateParametersIf( ScIterFuncIf ); void ScCountIf(); void ScSumIf(); +void ScAverageIf(); void ScCountEmptyCells(); void ScLookup(); void ScHLookup(); |