[]
        
(Showing Draft Content)

FarPoint.Web.Spread.DefaultRowFilter

DefaultRowFilter Class

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

Inheritance
DefaultRowFilter
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.