Spread for ASP.NET 9.0 Product Documentation
AggregationType Enumeration


Specifies the type of aggregation on ranges of cells.
Syntax
'Declaration
 
Public Enum AggregationType 
   Inherits System.Enum
'Usage
 
Dim instance As AggregationType
public enum AggregationType : System.Enum 
Members
MemberDescription
AvgReturns the average of cells in a range.
AvgIgnoreHiddenReturns the average of cells (ignores hidden values) in a range.
CountCounts the number of cells in a range that contain numbers.
CountACounts the number of cells in a range that are not empty.
CountAIgnoreHiddenCounts the number of cells (ignores hidden values) in a range that are not empty.
CountIgnoreHiddenCounts the number of cells (ignores hidden values) in a range that contain numbers.
CustomSpecifies custom aggregation.
MaxReturns the maximum value of cells in a range.
MaxIgnoreHiddenReturns the maximum value of cells (ignores hidden values) in a range.
MinIndicates the row count of the cells in the specified range of cells.
MinIgnoreHiddenIndicates the row count of the cells (ignores hidden values) in the specified range of cells.
NoneIndicates that aggregation for the sheet is not supported.
ProductMultiplies all the cells in a range and returns the product.
ProductIgnoreHiddenMultiplies all the cells (ignores hidden values) in a range and returns the product.
StDevReturns the standard deviation for a set of cells in a range.
StDevIgnoreHiddenReturns the standard deviation for a set of cells (ignores hidden values) in a range.
StDevPCalculates standard deviation based on the entire population given as cells in a range.
StDevPIgnoreHiddenCalculates standard deviation based on the entire population given as cells (ignores hidden values) in a range.
SumSums values of cells in a range.
SumIgnoreHiddenSums values of cells (ignores hidden values) in a range.
VarCalculates variance based on a sample of a population.
VarIgnoreHiddenCalculates variance based on a sample (ignores hidden values) of a population.
VarPCalculates variance based on the entire population.
VarPIgnoreHiddenCalculates 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

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

FarPoint.Web.Spread.Model Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.