-
DS.Documents.Excel Assembly
-
GrapeCity.Documents.Excel
-
Classes
- AsyncCustomFunction
- BaseCellType
- ButtonCellType
- CalcReference
- CellColorSortField
- CellDecoration
- CellDecorationIcon
- CellInfo
- CellPadding
- CheckBoxCellType
- CheckBoxListCellType
- ColorUtilities
- ComboBoxCellItem
- ComboBoxCellType
- CornerFold
- CsvOpenOptions
- CsvParseContext
- CsvParseResult
- CsvSaveOptions
- CustomBorderStyle
- CustomFunction
- DataImportOptions
- DataImportResult
- DataValidationJsonError
- DateTimeConverter
- DeserializationOptions
- DocumentProperties
- FindOptions
- FontColorSortField
- FormulaJsonError
- HtmlSaveOptions
- HyperLinkCellType
- IconSortField
- ImageSaveOptions
- ImageSource
- InvalidFormulaException
- InvalidTemplateException
- JsonDataSource
- JsonError
- LicenseManager
- Margin
- NumberFormatParseException
- OpenOptions
- OpenOptionsBase
- PageContentInfo
- PageInfo
- PagePrintEventArgs
- PagePrintedEventArgs
- PagePrintingEventArgs
- PageSettings
- Parameter
- PasteOption
- PdfSaveOptions
- PdfSecurityOptions
- PivotFilterOptions
- PrintManager
- PrintOutOptions
- RadioButtonListCellType
- RangeEventArgs
- RangeTemplateCellType
- RepeatSetting
- ReplaceOptions
- SaveOptions
- SaveOptionsBase
- SelectFieldItem
- SerializationOptions
- SheetEventArgs
- SignatureDetails
- SjsOpenOptions
- SjsSaveOptions
- SortFieldBase
- TextFormatInfo
- Theme
- Themes
- ValueSortField
- ViewerPreferences
- WebRequestResult
- Workbook
- WorkbookOptions
- WriteProtection
- XlsmOpenOptions
- XlsmSaveOptions
- XlsxOpenOptions
- XlsxSaveOptions
- XltxOpenOptions
- XltxSaveOptions
- Structs
- Interfaces
- Enums
-
Classes
- GrapeCity.Documents.Excel.Drawing
- GrapeCity.Documents.Excel.Expressions
- GrapeCity.Documents.Excel.Forms
-
GrapeCity.Documents.Excel
GrapeCity.Documents.Excel.PivotFilterOptions
PivotFilterOptions Class
Represents optional settings for pivot filters, containing special settings for value filters, date filters, and top 10 filters.
Namespace: GrapeCity.Documents.Excel
Assembly: DS.Documents.Excel.dll
Syntax
public class PivotFilterOptionsPublic Class PivotFilterOptionsConstructors
| Name | Description |
|---|---|
| PivotFilterOptions() |
Properties
| Name | Description |
|---|---|
| AppliedDataField | Gets or sets the value filter setting. Specifies which DataField the current field is filtered by. The value represents the index of the referenced DataField in the DataFields collection. |
| Description | Gets or sets a brief description of the filter. |
| IsTop10Type | Gets or sets a value indicating the selection direction of the 'top 10 filter'. 'True' means selecting the top n items, and 'false' means selecting the bottom n items. The default value is 'true'. |
| Name | Gets or sets the name of the filter. |
| WholeDayFilter | Gets or sets a value indicating whether the date filter should use whole days in its filtering criteria. |