- 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
- ActionResult<T>
- Alignment
- AutoFilterColumn
- Border
- BorderLine
- Break
- CellProtection
- CellReference
- CfExecutedResult
- CfIcon
- CfValue
- Color
- CustomFilterCriteria
- DataValidationExecutedResult
- DataValidationSuggestionItem
- DateGroupItem
- Fill
- FormatResult
- GradientFillEffect
- GradientStop
- NumberFormat
- Reference
- StyleFormat
- TableStyleElement
- WorksheetReference
- Enums
- 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.CustomFilterCriteria
CustomFilterCriteria Struct
A custom AutoFilter specifies an operator and a value. There can be at most two customFilters specified, and in that case the parent element specifies whether the two conditions are joined by 'and' or 'or'. For any cells whose values do not meet the specified criteria, the corresponding rows shall be hidden from view when the fitler is applied.
Namespace: GrapeCity.Spreadsheet
Assembly: GrapeCity.Spreadsheet.dll
Syntax
public struct CustomFilterCriteriaPublic Structure CustomFilterCriteriaConstructors
| Name | Description |
|---|---|
| CustomFilterCriteria(CustomFilterOperator, CalcError) | Initializes a new instance of the CustomFilterCriteria struct. |
| CustomFilterCriteria(CustomFilterOperator, bool) | Initializes a new instance of the CustomFilterCriteria struct. |
| CustomFilterCriteria(CustomFilterOperator, DateTime) | Initializes a new instance of the CustomFilterCriteria struct. |
| CustomFilterCriteria(CustomFilterOperator, double) | Initializes a new instance of the CustomFilterCriteria struct. |
| CustomFilterCriteria(CustomFilterOperator, string) | Initializes a new instance of the CustomFilterCriteria struct. |
Fields
| Name | Description |
|---|---|
| None | Returns a "None" filter criteria. |
Properties
| Name | Description |
|---|---|
| Operator | Gets the operator of this CustomFilterCriteria. |
| Value | Gets the value of this CustomFilterCriteria. |