Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / AggregationType Enumeration


In This Topic
    AggregationType Enumeration
    In This Topic
    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

    See Also