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