GrapeCity.Xaml.SpreadSheet.Data
RowFilterBase Class Members
Fields  Properties  Methods 


GrapeCity.Xaml.SpreadSheet.Data Namespace : RowFilterBase Class

The following tables list the members exposed by RowFilterBase.

Public Fields
 NameDescription
Public Fieldstatic (Shared in Visual Basic)BlankItem Indicates a blank item in the filter.  
Top
Public Properties
 NameDescription
Public PropertyIsFiltered Gets a value that indicates whether any row is filtered.  
Public PropertyRange Gets or sets the cell range for the row filter.  
Public PropertySheet Gets or sets the sheet.  
Public PropertyShowFilterButton Gets or sets a value that indicates whether to show a filter button.  
Top
Public Methods
 NameDescription
Public MethodAddAverageFilter Adds the average filter for the row filter.  
Public MethodAddBackgroundFilter Adds the background filter for the row filter.  
Public MethodAddDateFilter Adds the date filter for the row filter.  
Public MethodAddFilterItem Adds a specified filter to the row filter.  
Public MethodAddForegroundFilter Adds the foreground filter for the row filter.  
Public MethodAddNumberFilter Adds the number filter for the row filter.  
Public MethodAddTextFilter Adds the text filter for the row filter.  
Public MethodAddTop10Filter Adds the top 10 filter for the row filter.  
Public MethodFilterOverloaded.  Filters all columns.  
Public MethodGetFilterableDataItems Gets the data that can be filtered and is to be displayed in the drop-down list for the specified column.  
Public MethodGetFilteredItems Gets all the filtered conditions.  
Public MethodGetFilterItems Gets the filters for a specified column.  
Public MethodIsColumnFiltered Determines whether a specified column is filtered.  
Public MethodIsRowFilteredOut Determines whether the specified row is filtered out.  
Public MethodReFilter Refreshes all the filters.  
Public MethodRemoveFilterItems Removes the specified filter.  
Public MethodReset Clears all filters.  
Public MethodUnfilterOverloaded.  Removes the filter for all columns.  
Top
Protected Methods
 NameDescription
Protected MethodOnAddColumns Adds columns in the filter after the specified column.  
Protected MethodOnAddRows Adds rows in the filter after the specified row.  
Protected MethodOnClear Removes filters in the specified range  
Protected MethodOnCopy Copies filters from the start range and pastes into a range of cells at the end location.  
Protected MethodOnMove Moves filters from the start range to a range of cells at the end location.  
Protected MethodOnRemoveColumns Removes columns in the filter from the specified column.  
Protected MethodOnRemoveRows Removes rows in the filter from the specified row.  
Protected MethodOnSwap Swaps filters of the specified range from one location to another.  
Top
See Also

Reference

RowFilterBase Class
GrapeCity.Xaml.SpreadSheet.Data Namespace

 

 

Copyright © GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page