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