Spread Windows Forms 12.0 Product Documentation
AggregateOption Enumeration


GrapeCity.Spreadsheet Assembly > GrapeCity.CalcEngine Namespace : AggregateOption Enumeration
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

Reference

GrapeCity.CalcEngine Namespace