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/ui/src/scfuncs.src | |
| 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/ui/src/scfuncs.src')
| -rw-r--r-- | sc/source/ui/src/scfuncs.src | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/sc/source/ui/src/scfuncs.src b/sc/source/ui/src/scfuncs.src index bb32178cc793..e7f986d28a8b 100644 --- a/sc/source/ui/src/scfuncs.src +++ b/sc/source/ui/src/scfuncs.src @@ -2929,6 +2929,47 @@ Resource RID_SC_FUNCTION_DESCRIPTIONS1 Text [ en-US ] = "The range from which the values are to be totalled." ; }; }; + + // -=*# Resource for function AVERAGEIF #*=- + Resource SC_OPCODE_AVERAGE_IF + { + String 1 // Description + { + Text [ en-US ] = "Averages the arguments that meet the conditions." ; + }; + ExtraData = + { + 0; + ID_FUNCTION_GRP_MATH; + U2S( HID_FUNC_AVERAGEIF ); + 3; 0; 0; 1; + 0; + }; + String 2 // Name of Parameter 1 + { + Text [ en-US ] = "range" ; + }; + String 3 // Description of Parameter 1 + { + Text [ en-US ] = "The range to be evaluated by the criteria given." ; + }; + String 4 // Name of Parameter 2 + { + Text [ en-US ] = "criteria" ; + }; + String 5 // Description of Parameter 2 + { + Text [ en-US ] = "The cell range in which the search criteria are given." ; + }; + String 6 // Name of Parameter 3 + { + Text [ en-US ] = "average_range" ; + }; + String 7 // Description of Parameter 3 + { + Text [ en-US ] = "The range from which the values are to be averaged." ; + }; + }; // -=*# Resource for function ZÄHLENWENN #*=- Resource SC_OPCODE_COUNT_IF { |