- 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
-
Interfaces
- IAboveAverage
- IAlternatingStyles
- IAreas
- IArray<T>
- IAuthor
- IAutoFilter
- IAutoFilterOwner
- IBorder
- IBorders
- ICellEditor
- ICellRenderer
- ICellType
- ICharacters
- IColorPalette
- IColorScale
- IColorScaleCriteria
- IColorScaleCriterion
- IColorStops
- IColumnFooter
- IColumnHeader
- IComment
- ICommentThreaded
- IComments
- ICommentsThreaded
- IConditionValue
- IDataManager
- IDatabar
- IDatabarBorder
- IFilter
- IFilters
- IFont
- IFormatCondition
- IFormatConditions
- IFormatter
- IGradient
- IGraphic
- IHyperlink
- IHyperlinks
- IIconCriteria
- IIconCriterion
- IIconSetCondition
- IInterior
- IMedia
- IName
- INames
- INegativeBarFormat
- INumFmtSupportCellType
- IOutline
- IProtection
- IRange
- IReadonlyArray<T>
- IRowHeader
- ISheet
- ISheetView
- ISheets
- ISort
- ISortComparer
- ISortField
- ISortFields
- ISparkAxes
- ISparkColor
- ISparkHorizontalAxis
- ISparkPoints
- ISparkVerticalAxis
- ISparkline
- ISparklineGroup
- ISparklineGroups
- IStyle
- IStyles
- ITable
- ITableColumn
- ITableColumns
- ITableRow
- ITableRows
- ITableStyle
- ITableStyleElement
- ITableStyleElements
- ITableStyles
- ITables
- ITop10
- IUniqueValues
- IValidation
- IWorkbook
- IWorkbookSet
- IWorkbooks
-
IWorksheet
-
Properties
- ActiveCell
- AutoFilter
- AutoFilterMode
- AutoUpdateFilter
- Behaviors
- Cells
- ChartObjects
- CircularReference
- CircularReferences
- ColumnCount
- ColumnFooter
- ColumnHeader
- Columns
- Comments
- CommentsThreaded
- CustomProperties
- DataManager
- DisplayPageBreaks
- EnableSelection
- Hyperlinks
- Index
- Names
- Options
- Outline
- Owner
- Pictures
- Protection
- RowCount
- RowHeader
- Rows
- Selection
- Shapes
- Slicers
- Sort
- StandardHeight
- StandardWidth
- Styles
- SubType
- Tables
- UsedRange
- View
- Methods
-
Properties
- IWorksheetStyles
- IWorksheetView
- IWorksheets
- 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.IWorksheet.AutoFilter
AutoFilter Property
AutoFilter
Gets an IAutoFilter object if filtering is on.
Declaration
IAutoFilter AutoFilter { get; }ReadOnly Property AutoFilter As IAutoFilterProperty Value
| Type | Description |
|---|---|
| IAutoFilter | An IAutoFilter object represents the filter of this IWorksheet object. |
Remarks
The property returns Nothing if filtering is off.
To create an IAutoFilter object for a worksheet, you must turn auto-filtering on for a range on the worksheet either manually or using the AutoFilter(bool, bool) method of the IRange object.