- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.PDF Assembly
- FarPoint.Win Assembly
- FarPoint.Win.Chart Assembly
- FarPoint.Win.Spread Assembly
- GrapeCity.CalcEngine Assembly
-
GrapeCity.Spreadsheet Assembly
- GrapeCity.CalcEngine
- GrapeCity.Core
-
GrapeCity.Spreadsheet
- Classes
- Structs
-
Enums
- AboveBelow
- AlignmentAttributes
- AutoFillType
- AutoFilterOperator
- Behaviors
- BorderLineStyle
- BordersIndex
- BuiltInSlicerStyles
- BuiltInStyle
- BuiltInTableStyles
- CalcFeatures
- Calculation
- CalculationOnDemandMode
- CalendarType
- CellDataType
- CfValueType
- CharacterSet
- ChartLocks
- ClassicCfRuleType
- ColorType
- ColumnDataType
- Compatibility
- ContainsOperator
- CustomFilterOperator
- CutCopyMode
- DataRestrictions
- DataValidationErrorStyle
- DataValidationOperator
- DataValidationType
- DatabarAxisPosition
- DatabarBorderType
- DatabarDirection
- DatabarFillType
- DatabarNegativeColorType
- DateTimeGrouping
- DeleteShiftDirection
- Direction
- DisplayBlanksAs
- DisplayValueStyle
- DupeUnique
- DynamicFilterType
- EnableSelection
- FilterDataType
- FilterOptions
- FilterScopes
- FindLookIn
- FontAttributes
- FontFamily
- FontStyle
- FormatColorEnum
- FormatConditionOperator
- FormatConditionType
- FormatOptions
- GradientType
- HorizontalAlignment
- HyperlinkType
- IconSetType
- ImeMode
- InsertFormatOrigin
- InsertShiftDirection
- LookAt
- ManipulationOptions
- MergePolicy
- NewRowPosition
- NumberFormatConvertMode
- Operator
- PageBreak
- PasteSpecialOperation
- PasteType
- PatternType
- PredefinedNumberFormats
- ProtectionMode
- ReferenceStyle
- SearchDirection
- SearchOrder
- SheetViewType
- SheetVisibility
- SortDataOption
- SortMethod
- SortOn
- SortOrder
- SortOrientation
- SparkScale
- SparkType
- SparklineRowCol
- SpecialCellType
- SpecialCellsValue
- StyleFormatApplyment
- SummaryColumn
- SummaryRow
- TableStyleElementType
- TableStyleSettings
- TableType
- TextParsingType
- TextQualifier
- TextReadingOrder
- ThemeFont
- TimePeriods
- TopBottom
- TotalsCalculation
- UnderlineStyle
- UpdateLinks
- VerticalAlignment
- VerticalTextAlignment
- WorkbookLocks
- WorksheetLocks
- WorksheetSubType
- WorksheetType
- YesNoCancel
- YesNoGuess
- Interfaces
- GrapeCity.Spreadsheet.Charts
- GrapeCity.Spreadsheet.Commands
- GrapeCity.Spreadsheet.Drawing
- GrapeCity.Spreadsheet.IO
- GrapeCity.Spreadsheet.IO.OpenXml
- GrapeCity.Spreadsheet.IO.Pdf
- GrapeCity.Spreadsheet.Localization
- GrapeCity.Spreadsheet.Printing
- GrapeCity.Spreadsheet.Slicers
- GrapeCity.Spreadsheet.UI
- GrapeCity.Spreadsheet.WinForms.Ribbon Assembly
- GrapeCity.Win.PluginInputMan Assembly
GrapeCity.Spreadsheet.AutoFilterOperator
AutoFilterOperator Enum
Specifies the operator to use to associate two criteria applied by a filter.
Namespace: GrapeCity.Spreadsheet
Assembly: GrapeCity.Spreadsheet.dll
Syntax
public enum AutoFilterOperatorPublic Enum AutoFilterOperatorFields
| Name | Description |
|---|---|
| And | Logical AND of Criteria1 and Criteria2. |
| Bottom10Items | Lowest-valued items displayed (number of items specified in Criteria1). |
| Bottom10Percent | Lowest-valued items displayed (percentage specified in Criteria1). |
| FilterCellColor | Color of the cell |
| FilterDynamic | Dynamic filter |
| FilterFontColor | Color of the font |
| FilterIcon | Filter icon |
| FilterValues | Filter values |
| Or | Logical OR of Criteria1 or Criteria2. |
| Top10Items | Highest-valued items displayed (number of items specified in Criteria1). |
| Top10Percent | Highest-valued items displayed (percentage specified in Criteria1). |