Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.CalcEngine Namespace / AggregateOption Enumeration


In This Topic
    AggregateOption Enumeration
    In This Topic
    Represents a options that determines which values to ignore in the evaluation range for the function.
    Syntax
    'Declaration
     
    
    Public Enum AggregateOption 
       Inherits System.Enum
    'Usage
     
    
    Dim instance As AggregateOption
    public enum AggregateOption : System.Enum 
    Members
    MemberDescription
    IgnoreErrorIgnore error values.
    IgnoreErrorNestedAggregationIgnore error values, nested SUBTOTAL and AGGREGATE functions.
    IgnoreHiddenIgnore hidden rows.
    IgnoreHiddenErrorIgnore hidden rows and error values.
    IgnoreHiddenErrorNestedAggregationIgnore hidden rows, error values, nested SUBTOTAL and AGGREGATE functions.
    IgnoreHiddenNestedAggregationIgnore hidden rows, nested SUBTOTAL and AGGREGATE functions.
    IgnoreNestedAggregationIgnore nested SUBTOTAL and AGGREGATE functions.
    IgnoreNothingIgnore nothing.
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             GrapeCity.CalcEngine.AggregateOption

    See Also