Spread WinForms 15
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
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

 

 

Copyright © 2021 GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page