FarPoint.Web.Spread.Model.AggregationType

AggregationType Enum

Specifies the type of aggregation on ranges of cells.

Namespace: FarPoint.Web.Spread.Model

Assembly: FarPoint.Web.Spread.dll

Syntax

public enum AggregationType

Public Enum AggregationType

Fields

Name	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).