FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace : AggregationType Enumeration |
'Declaration Public Enum AggregationType Inherits System.Enum
'Usage Dim instance As AggregationType
public enum AggregationType : System.Enum
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). |
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 |
System.Object
System.ValueType
System.Enum
FarPoint.Web.Spread.Model.AggregationType
Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional