- DsExcel .NET API Overview
-
DS.Documents.Excel Assembly
-
GrapeCity.Documents.Excel
- Classes
-
Enums
- AboveBelow
- AutoFilterOperator
- AutoMergeDirection
- AutoMergeMode
- AutoMergeSelectionMode
- BackgroundImageLayout
- BarcodeType
- BorderLineStyle
- BordersIndex
- CalcError
- CalculationMode
- CellAttribute
- CellTypeDirection
- CellTypeTextAlign
- CheckBoxAlign
- ColorDataIndex
- ColorScaleType
- ConditionValueTypes
- ConsolidationFunction
- ContainsOperator
- CornerPosition
- CssExportType
- DataBarAxisPosition
- DataBarBorderType
- DataBarDirection
- DataBarFillType
- DataBarNegativeColorType
- DeleteShiftDirection
- Direction
- DisplayBlanksAs
- DupeUnique
- DynamicFilterType
- EccMode
- EditorValueType
- ErrorCorrectionLevel
- FindLookIn
- FontLanguageIndex
- FormatConditionOperator
- FormatConditionType
- FormFieldSubmitFormatType
- FunctionValueType
- GradientFillType
- GraphicColorType
- HorizontalAlignment
- HyperLinkTargetType
- IconPosition
- IconSetType
- IconType
- IgnoredErrorType
- IMEModeType
- ImportFlags
- InsertShiftDirection
- InsufficientSpaceHandling
- LabelAlignment
- LabelVisibility
- LayoutFormType
- LayoutRowType
- LookAt
- NumbersFitMode
- OpenFileFormat
- Order
- PageBreakExtent
- PageOrientation
- PageType
- PaginationOrientation
- PaperSize
- PasteType
- Pattern
- PivotCellType
- PivotFieldCalculation
- PivotFieldOrientation
- PivotFieldRepeatLabels
- PivotFilterType
- PivotLineType
- PrintErrors
- PrintLocation
- PrintQuality
- PropertyType
- ReadingOrder
- ReferenceStyle
- SaveFileFormat
- SearchDirection
- SearchOrder
- SelectionModeType
- SheetTabType
- SheetType
- SlicerSortOrder
- SortDataOption
- SortOnType
- SortOrder
- SortOrientation
- SparklineRowCol
- SparkScale
- SparkType
- SpecialCellsValue
- SpecialCellType
- SpreadJSTabStripPosition
- SubtotalLocationType
- SubtotalType
- SummaryColumn
- SummaryRow
- TableStyleElementType
- ThemeColor
- ThemeFont
- TimePeriods
- TopBottom
- TotalsCalculation
- UnderlineType
- UsedRangeType
- ValidationAlertStyle
- ValidationOperator
- ValidationType
- ValueQuoteType
- VerticalAlignment
- ViewType
- Visibility
- Interfaces
- Structs
- GrapeCity.Documents.Excel.Drawing
- GrapeCity.Documents.Excel.Expressions
- GrapeCity.Documents.Excel.Forms
-
GrapeCity.Documents.Excel
GrapeCity.Documents.Excel.DynamicFilterType
DynamicFilterType Enum
Specifies the filter type.
Namespace: GrapeCity.Documents.Excel
Assembly: DS.Documents.Excel.dll
Syntax
public enum DynamicFilterTypePublic Enum DynamicFilterTypeFields
| Name | Description |
|---|---|
| AboveAverage | Specifies to filter all above-average values. |
| BelowAverage | Specifies to filter all below-average values. |
| LastMonth | Specifies to filter all values related to last month. |
| LastQuarter | Specifies to filter all values related to last quarter. |
| LastWeek | Specifies to filter all values related to last week. |
| LastYear | Specifies to filter all values related to last year. |
| M1 | Specifies to filter all dates in January. |
| M10 | Specifies to filter all dates in October. |
| M11 | Specifies to filter all dates in November. |
| M12 | Specifies to filter all dates in December. |
| M2 | Specifies to filter all dates in February. |
| M3 | Specifies to filter all dates in March. |
| M4 | Specifies to filter all dates in April. |
| M5 | Specifies to filter all dates in May. |
| M6 | Specifies to filter all dates in June. |
| M7 | Specifies to filter all dates in July. |
| M8 | Specifies to filter all dates in August. |
| M9 | Specifies to filter all dates in September. |
| NextMonth | Specifies to filter all values related to next month. |
| NextQuarter | Specifies to filter all values related to next quarter. |
| NextWeek | Specifies to filter all values related to next week. |
| NextYear | Specifies to filter all values related to next year. |
| None | Specifies none. |
| Q1 | Specifies to filter all dates in Quarter1. |
| Q2 | Specifies to filter all dates in Quarter2. |
| Q3 | Specifies to filter all dates in Quarter3. |
| Q4 | Specifies to filter all dates in Quarter4. |
| ThisMonth | Specifies to filter all values related to the current month. |
| ThisQuarter | Specifies to filter all values related to the current quarter. |
| ThisWeek | Specifies to filter all values related to the current week. |
| ThisYear | Specifies to filter all values related to the current year. |
| Today | Specifies to filter all values related to the current date. |
| Tomorrow | Specifies to filter all values related to tomorrow. |
| YearToDate | Specifies to filter all values from today until a year ago. |
| Yesterday | Specifies to filter all values related to yesterday. |