1*b1cdbd2cSJim Jagielski/************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski 24*b1cdbd2cSJim Jagielski#ifndef __com_sun_star_sheet_GeneralFunction_idl__ 25*b1cdbd2cSJim Jagielski#define __com_sun_star_sheet_GeneralFunction_idl__ 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski//============================================================================= 28*b1cdbd2cSJim Jagielski 29*b1cdbd2cSJim Jagielskimodule com { module sun { module star { module sheet { 30*b1cdbd2cSJim Jagielski 31*b1cdbd2cSJim Jagielski//============================================================================= 32*b1cdbd2cSJim Jagielski 33*b1cdbd2cSJim Jagielski/** used to specify a function to be calculated from values. 34*b1cdbd2cSJim Jagielski */ 35*b1cdbd2cSJim Jagielskipublished enum GeneralFunction 36*b1cdbd2cSJim Jagielski{ 37*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 38*b1cdbd2cSJim Jagielski 39*b1cdbd2cSJim Jagielski /** nothing is calculated. 40*b1cdbd2cSJim Jagielski */ 41*b1cdbd2cSJim Jagielski NONE, 42*b1cdbd2cSJim Jagielski 43*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 44*b1cdbd2cSJim Jagielski 45*b1cdbd2cSJim Jagielski /** function is determined automatically. 46*b1cdbd2cSJim Jagielski 47*b1cdbd2cSJim Jagielski <p>If the values are all numerical, SUM is used, otherwise COUNT.</p> 48*b1cdbd2cSJim Jagielski */ 49*b1cdbd2cSJim Jagielski AUTO, 50*b1cdbd2cSJim Jagielski 51*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 52*b1cdbd2cSJim Jagielski 53*b1cdbd2cSJim Jagielski /** sum of all numerical values is calculated. 54*b1cdbd2cSJim Jagielski */ 55*b1cdbd2cSJim Jagielski SUM, 56*b1cdbd2cSJim Jagielski 57*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 58*b1cdbd2cSJim Jagielski 59*b1cdbd2cSJim Jagielski /** all values, including non-numerical values, are counted. 60*b1cdbd2cSJim Jagielski */ 61*b1cdbd2cSJim Jagielski COUNT, 62*b1cdbd2cSJim Jagielski 63*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 64*b1cdbd2cSJim Jagielski 65*b1cdbd2cSJim Jagielski /** average of all numerical values is calculated. 66*b1cdbd2cSJim Jagielski */ 67*b1cdbd2cSJim Jagielski AVERAGE, 68*b1cdbd2cSJim Jagielski 69*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 70*b1cdbd2cSJim Jagielski 71*b1cdbd2cSJim Jagielski /** maximum value of all numerical values is calculated. 72*b1cdbd2cSJim Jagielski */ 73*b1cdbd2cSJim Jagielski MAX, 74*b1cdbd2cSJim Jagielski 75*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 76*b1cdbd2cSJim Jagielski 77*b1cdbd2cSJim Jagielski /** minimum value of all numerical values is calculated. 78*b1cdbd2cSJim Jagielski */ 79*b1cdbd2cSJim Jagielski MIN, 80*b1cdbd2cSJim Jagielski 81*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 82*b1cdbd2cSJim Jagielski 83*b1cdbd2cSJim Jagielski /** product of all numerical values is calculated. 84*b1cdbd2cSJim Jagielski */ 85*b1cdbd2cSJim Jagielski PRODUCT, 86*b1cdbd2cSJim Jagielski 87*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 88*b1cdbd2cSJim Jagielski 89*b1cdbd2cSJim Jagielski /** numerical values are counted. 90*b1cdbd2cSJim Jagielski */ 91*b1cdbd2cSJim Jagielski COUNTNUMS, 92*b1cdbd2cSJim Jagielski 93*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 94*b1cdbd2cSJim Jagielski 95*b1cdbd2cSJim Jagielski /** standard deviation is calculated based on a sample. 96*b1cdbd2cSJim Jagielski */ 97*b1cdbd2cSJim Jagielski STDEV, 98*b1cdbd2cSJim Jagielski 99*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 100*b1cdbd2cSJim Jagielski 101*b1cdbd2cSJim Jagielski /** standard deviation is calculated based on the entire population. 102*b1cdbd2cSJim Jagielski */ 103*b1cdbd2cSJim Jagielski STDEVP, 104*b1cdbd2cSJim Jagielski 105*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 106*b1cdbd2cSJim Jagielski 107*b1cdbd2cSJim Jagielski /** variance is calculated based on a sample. 108*b1cdbd2cSJim Jagielski */ 109*b1cdbd2cSJim Jagielski VAR, 110*b1cdbd2cSJim Jagielski 111*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------- 112*b1cdbd2cSJim Jagielski 113*b1cdbd2cSJim Jagielski /** variance is calculated based on the entire population. 114*b1cdbd2cSJim Jagielski */ 115*b1cdbd2cSJim Jagielski VARP 116*b1cdbd2cSJim Jagielski 117*b1cdbd2cSJim Jagielski}; 118*b1cdbd2cSJim Jagielski 119*b1cdbd2cSJim Jagielski//============================================================================= 120*b1cdbd2cSJim Jagielski 121*b1cdbd2cSJim Jagielski}; }; }; }; 122*b1cdbd2cSJim Jagielski 123*b1cdbd2cSJim Jagielski#endif 124*b1cdbd2cSJim Jagielski 125