[]
Represents a default row filter that extends to implement the supported row filters.
public abstract class DefaultRowFilter : IRowFilterComboSupport, IRowFilterSlim, IRowFilter, ISerializeSupport, IRowFilterFrozenSupport
Public MustInherit Class DefaultRowFilter
Implements IRowFilterComboSupport, IRowFilterSlim, IRowFilter, ISerializeSupport, IRowFilterFrozenSupport
Name | Description |
---|---|
DefaultRowFilter(SheetView) | Creates a new default row filter for the specified sheet. |
Name | Description |
---|---|
AllString | Gets or sets the all filter items string. |
BlanksString | Gets or sets the blanks (empty cells) string. |
ColumnDefinitions | Gets the collection of filter column definitions. |
FilterFrozenRows | Gets or sets whether frozen rows are filtered. |
NonBlanksString | Gets or sets the non-blanks (non-empty cells) string. |
ResetIfNoFilteredRow | Gets or sets a value which indicates that the filtered row list will be reset if there is no filtered row. Assign this property to True for compatible with version 6 or lower. |
SheetView | Gets or sets the sheet associated with this row filter. |
ShowFilterIndicator | Gets or sets whether the filter indicator should be displayed. |
UnfilteredRows | Gets or sets unfiltered rows. |
Name | Description |
---|---|
AddColumn(FilterColumnDefinition) | Adds a filter column definition to the row filter. |
AddColumn(int) | Adds a filter column definition to the row filter. |
AddColumn(int, FilterListBehavior) | Adds a filter column definition to the row filter with the specified list behavior. |
Deserialize(XmlNodeReader) | Loads the object from XML. |
GetColumnFilterIndexFromColumnIndex(int) | Gets the column filter index from the specified column. |
GetFilterColumnDefinition(int) | Gets the filter column definition from the specified column. |
GetFilteredColumnIndexes() | Gets an array of column indexes where row filters exist. |
IsFiltered(int) | Internal use only. Gets whether the specified column is filtered. |
IsRowFilteredOut(int) | Determines whether the specified row is filtered out. |
MoveFilters(int, int, int, int, int, int) | Moves the filter column(s) to another location. |
OnDataModelChanged(object, SheetDataModelEventArgs) | Occurs when the data model has changed. |
OnFilterColumnDefinitionCollectionChanged(object, CollectionChangeEventArgs) | Occurs when the filter column definition collection has changed. |
OnStyleModelChanged(object, SheetStyleModelEventArgs) | Occurs when the style model has changed. |
RemoveColumn(int) | Removes a filter column definition from the row filter. |
ResetFilter() | Resets the filter settings for the entire row filter. |
ResetFilter(int) | Resets the filter settings for the specified column. |
Serialize(XmlTextWriter) | Saves the object to XML. |