| 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