diff options
| author | Winfried Donkers <winfrieddonkers@libreoffice.org> | 2016-05-03 21:19:19 +0200 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2016-05-04 21:54:01 +0000 |
| commit | c57dc741a6f221f53f3c8da2f521c6ece63246c2 (patch) | |
| tree | ded3a12b1dbb08fe920045fadf09a2e877e6145d /sc/source/ui/src/scfuncs.src | |
| parent | 75ac19149d21f5164e7bb3ea1b114670e1d7859e (diff) | |
tdf#97831 [part] Add Excel 2016 functions to Calc
Functions MINIFS and MAXIFS
Change-Id: I4bd2e8b82f8377af81f4373d0c33ac286588b8df
Reviewed-on: https://gerrit.libreoffice.org/24619
Tested-by: Jenkins <ci@libreoffice.org>
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Eike Rathke <erack@redhat.com>
Diffstat (limited to 'sc/source/ui/src/scfuncs.src')
| -rw-r--r-- | sc/source/ui/src/scfuncs.src | 78 |
1 files changed, 78 insertions, 0 deletions
diff --git a/sc/source/ui/src/scfuncs.src b/sc/source/ui/src/scfuncs.src index 04c9388985c2..4ce4a7590502 100644 --- a/sc/source/ui/src/scfuncs.src +++ b/sc/source/ui/src/scfuncs.src @@ -11663,6 +11663,84 @@ Resource RID_SC_FUNCTION_DESCRIPTIONS2 Text [ en-US ] = "Value to return when corresponding value argument matches expression." ; }; }; + Resource SC_OPCODE_MINIFS_MS + { + String 1 // Description + { + Text [ en-US ] = "Returns the minimum value in a range that meet multiple criteria in multiple ranges." ; + }; + ExtraData = + { + 0; + ID_FUNCTION_GRP_STATISTIC; + HID_FUNC_MINIFS_MS; + PAIRED_VAR_ARGS + 1; 0; 0; 0; + 0; + }; + String 2 // Name of Parameter 1 + { + Text [ en-US ] = "min_range" ; + }; + String 3 // Description of Parameter 1 + { + Text [ en-US ] = "The range from which the minimum will be determined." ; + }; + String 4 // Name of Parameter 2 + { + Text [ en-US ] = "range" ; + }; + String 5 // Description of Parameter 2 + { + Text [ en-US ] = "The range from which the minimum value is to be taken." ; + }; + String 6 // Name of Parameter 3 + { + Text [ en-US ] = "criteria" ; + }; + String 7 // Description of Parameter 3 + { + Text [ en-US ] = "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given." ; + }; + }; + Resource SC_OPCODE_MAXIFS_MS + { + String 1 // Description + { + Text [ en-US ] = "Returns the maximum value in a range that meet multiple criteria in multiple ranges." ; + }; + ExtraData = + { + 0; + ID_FUNCTION_GRP_STATISTIC; + HID_FUNC_MAXIFS_MS; + PAIRED_VAR_ARGS + 1; 0; 0; 0; + 0; + }; + String 2 // Name of Parameter 1 + { + Text [ en-US ] = "max_range" ; + }; + String 3 // Description of Parameter 1 + { + Text [ en-US ] = "The range from which the maximum will be determined." ; + }; + String 4 // Name of Parameter 2 + { + Text [ en-US ] = "range" ; + }; + String 5 // Description of Parameter 2 + { + Text [ en-US ] = "The range from which the minimum value is to be taken." ; + }; + String 6 // Name of Parameter 3 + { + Text [ en-US ] = "criteria" ; + }; + String 7 // Description of Parameter 3 + { + Text [ en-US ] = "Criteria 1, criteria 2,... are the criteria to be applied to the ranges given." ; + }; + }; // -=*# Resource for function EXACT #*=- Resource SC_OPCODE_EXACT { |