AggregationType Enumeration

In This Topic

Specifies the type of aggregation on ranges of cells.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum AggregationType 
   Inherits System.Enum

'Usage
 
Dim instance As AggregationType

public enum AggregationType : System.Enum

Members

Member	Description
Avg	Returns the average of cells in a range.
AvgIgnoreHidden	Returns the average of cells (ignores hidden values) in a range.
Count	Counts the number of cells in a range that contain numbers.
CountA	Counts the number of cells in a range that are not empty.
CountAIgnoreHidden	Counts the number of cells (ignores hidden values) in a range that are not empty.
CountIgnoreHidden	Counts the number of cells (ignores hidden values) in a range that contain numbers.
Custom	Specifies custom aggregation.
Max	Returns the maximum value of cells in a range.
MaxIgnoreHidden	Returns the maximum value of cells (ignores hidden values) in a range.
Min	Indicates the row count of the cells in the specified range of cells.
MinIgnoreHidden	Indicates the row count of the cells (ignores hidden values) in the specified range of cells.
None	Indicates that aggregation for the sheet is not supported.
Product	Multiplies all the cells in a range and returns the product.
ProductIgnoreHidden	Multiplies all the cells (ignores hidden values) in a range and returns the product.
StDev	Returns the standard deviation for a set of cells in a range.
StDevIgnoreHidden	Returns the standard deviation for a set of cells (ignores hidden values) in a range.
StDevP	Calculates standard deviation based on the entire population given as cells in a range.
StDevPIgnoreHidden	Calculates standard deviation based on the entire population given as cells (ignores hidden values) in a range.
Sum	Sums values of cells in a range.
SumIgnoreHidden	Sums values of cells (ignores hidden values) in a range.
Var	Calculates variance based on a sample of a population.
VarIgnoreHidden	Calculates variance based on a sample (ignores hidden values) of a population.
VarP	Calculates variance based on the entire population.
VarPIgnoreHidden	Calculates variance based on the entire population (ignores hidden values).

Remarks

AggregationType	Function Code (Include Hidden Values)	AggregationType	Function Code (Ignore Hidden Values)
Avg	1	AvgIgnoreHidden	101
Count	2	CountIgnoreHidden	102
CountA	3	CountAIgnoreHidden	103
Max	4	MaxIgnoreHidden	104
Min	5	MinIgnoreHidden	105
Product	6	ProductIgnoreHidden	106
StDev	7	StDevIgnoreHidden	107
StDevP	8	StDevPIgnoreHidden	108
Sum	9	SumIgnoreHidden	109
Var	10	VarIgnoreHidden	110
VarP	11	VarPIgnoreHidden	111

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.Model.AggregationType

Reference

FarPoint.Web.Spread.Model Namespace