FarPoint.Web.Spread.DefaultRowFilter

DefaultRowFilter Class

Represents a default row filter that extends to implement the supported row filters.

Inheritance

object

DefaultRowFilter

HideRowFilter

StyleRowFilter

Implements

IRowFilterComboSupport

IRowFilterSlim

IRowFilter

ISerializeSupport

IRowFilterFrozenSupport

Namespace: FarPoint.Web.Spread

Assembly: FarPoint.Web.Spread.dll

Syntax

public abstract class DefaultRowFilter : IRowFilterComboSupport, IRowFilterSlim, IRowFilter, ISerializeSupport, IRowFilterFrozenSupport

Public MustInherit Class DefaultRowFilter
    Implements IRowFilterComboSupport, IRowFilterSlim, IRowFilter, ISerializeSupport, IRowFilterFrozenSupport

Constructors

Name	Description
DefaultRowFilter(SheetView)	Creates a new default row filter for the specified sheet.

Properties

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.

Methods

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.