scfuncs.src (245212b4) scfuncs.src (1b1b70fb)
1/**************************************************************
2 *
3 * Licensed to the Apache Software Foundation (ASF) under one
4 * or more contributor license agreements. See the NOTICE file
5 * distributed with this work for additional information
6 * regarding copyright ownership. The ASF licenses this file
7 * to you under the Apache License, Version 2.0 (the
8 * "License"); you may not use this file except in compliance

--- 2916 unchanged lines hidden (view full) ---

2925 {
2926 Text [ en-US ] = "average_range" ;
2927 };
2928 String 7 // Description of Parameter 3
2929 {
2930 Text [ en-US ] = "The range from which the values are to be averaged." ;
2931 };
2932 };
1/**************************************************************
2 *
3 * Licensed to the Apache Software Foundation (ASF) under one
4 * or more contributor license agreements. See the NOTICE file
5 * distributed with this work for additional information
6 * regarding copyright ownership. The ASF licenses this file
7 * to you under the Apache License, Version 2.0 (the
8 * "License"); you may not use this file except in compliance

--- 2916 unchanged lines hidden (view full) ---

2925 {
2926 Text [ en-US ] = "average_range" ;
2927 };
2928 String 7 // Description of Parameter 3
2929 {
2930 Text [ en-US ] = "The range from which the values are to be averaged." ;
2931 };
2932 };
2933
2934 Resource SC_OPCODE_SUM_IFS
2935 {
2936 String 1 // Description
2937 {
2938 Text [ en-US ] = "Totals the values of cells in a range that meet multiple criteria in multiple ranges." ;
2939 };
2940 ExtraData =
2941 {
2942 0;
2943 ID_FUNCTION_GRP_MATH;
2944 U2S( HID_FUNC_SUMIFS );
2945 PAIRED_VAR_ARGS+1; 0; 0; 0;
2946 0;
2947 };
2948 String 2 // Name of Parameter 1
2949 {
2950 Text [ en-US ] = "sum_range" ;
2951 };
2952 String 3 // Description of Parameter 1
2953 {
2954 Text [ en-US ] = "The range from which the values are to be totalled." ;
2955 };
2956 String 4 // Name of Parameter 2
2957 {
2958 Text [ en-US ] = "range" ;
2959 };
2960 String 5 // Description of Parameter 2
2961 {
2962 Text [ en-US ] = "Range 1, range 2,... are the ranges to be evaluated by the criteria given." ;
2963 };
2964 String 6 // Name of Parameter 3
2965 {
2966 Text [ en-US ] = "criteria" ;
2967 };
2968 String 7 // Description of Parameter 3
2969 {
2970 Text [ en-US ] = "Criteria 1, criteria 2,... are the cell ranges in which the search criteria are given." ;
2971 };
2972 };
2973
2974 // -=*# Resource for function AVERAGEIFS #*=-
2975 Resource SC_OPCODE_AVERAGE_IFS
2976 {
2977 String 1 // Description
2978 {
2979 Text [ en-US ] = "Averages the value of the cells that meet multiple criteria in multiple ranges." ;
2980 };
2981 ExtraData =
2982 {
2983 0;
2984 ID_FUNCTION_GRP_MATH;
2985 U2S( HID_FUNC_AVERAGEIFS );
2986 PAIRED_VAR_ARGS+1; 0; 0; 0;
2987 0;
2988 };
2989 String 2 // Name of Parameter 1
2990 {
2991 Text [ en-US ] = "average_range" ;
2992 };
2993 String 3 // Description of Parameter 1
2994 {
2995 Text [ en-US ] = "The range from which the values are to be averaged." ;
2996 };
2997 String 4 // Name of Parameter 2
2998 {
2999 Text [ en-US ] = "range" ;
3000 };
3001 String 5 // Description of Parameter 2
3002 {
3003 Text [ en-US ] = "Range 1, range 2,... are the ranges to be evaluated by the criteria given." ;
3004 };
3005 String 6 // Name of Parameter 3
3006 {
3007 Text [ en-US ] = "criteria" ;
3008 };
3009 String 7 // Description of Parameter 3
3010 {
3011 Text [ en-US ] = "Criteria 1, criteria 2,... are the cell ranges in which the search criteria are given." ;
3012 };
3013 };
3014
3015 // -=*# Resource for function COUNTIFS #*=-
3016 Resource SC_OPCODE_COUNT_IFS
3017 {
3018 String 1 // Description
3019 {
3020 Text [ en-US ] = "Counts the cells that meet multiple criteria in multiple ranges." ;
3021 };
3022 ExtraData =
3023 {
3024 0;
3025 ID_FUNCTION_GRP_MATH;
3026 U2S( HID_FUNC_COUNTIFS );
3027 PAIRED_VAR_ARGS; 0; 0;
3028 0;
3029 };
3030 String 2 // Name of Parameter 1
3031 {
3032 Text [ en-US ] = "range" ;
3033 };
3034 String 3 // Description of Parameter 1
3035 {
3036 Text [ en-US ] = "Range 1, range 2,... are the ranges to be evaluated by the criteria given." ;
3037 };
3038 String 4 // Name of Parameter 2
3039 {
3040 Text [ en-US ] = "criteria" ;
3041 };
3042 String 5 // Description of Parameter 2
3043 {
3044 Text [ en-US ] = "Criteria 1, criteria 2,... are the cell ranges in which the search criteria are given." ;
3045 };
3046 };
3047
2933 // -=*# Resource for function ZÄHLENWENN #*=-
2934 Resource SC_OPCODE_COUNT_IF
2935 {
2936 String 1 // Description
2937 {
2938 Text [ en-US ] = "Counts the arguments which meet the set conditions." ;
2939 };
2940 ExtraData =

--- 6167 unchanged lines hidden --- 		3048 // -=*# Resource for function ZÄHLENWENN #*=-
3049 Resource SC_OPCODE_COUNT_IF
3050 {
3051 String 1 // Description
3052 {
3053 Text [ en-US ] = "Counts the arguments which meet the set conditions." ;
3054 };
3055 ExtraData =

--- 6167 unchanged lines hidden ---