GrapeCity.Xaml.SpreadSheet.Data
HideRowFilter Class Members
Properties  Methods 


The following tables list the members exposed by HideRowFilter.

Public Constructors
 NameDescription
Public ConstructorHideRowFilter ConstructorOverloaded.   
Top
Public Properties
 NameDescription
Public PropertyIsFilteredOverridden.  Gets whether any of the columns are filtered.  
Public PropertyRangeOverridden.  Gets or sets the cell range for the hide row filter.  
Public PropertySheet Gets or sets the sheet. (Inherited from GrapeCity.Xaml.SpreadSheet.Data.RowFilterBase)
Public PropertyShowFilterButton Gets or sets a value that indicates whether to show a filter button. (Inherited from GrapeCity.Xaml.SpreadSheet.Data.RowFilterBase)
Top
Public Methods
 NameDescription
Public MethodAddAverageFilter Adds the average filter for the row filter. (Inherited from GrapeCity.Xaml.SpreadSheet.Data.RowFilterBase)
Public MethodAddBackgroundFilter Adds the background filter for the row filter. (Inherited from GrapeCity.Xaml.SpreadSheet.Data.RowFilterBase)
Public MethodAddDateFilter Adds the date filter for the row filter. (Inherited from GrapeCity.Xaml.SpreadSheet.Data.RowFilterBase)
Public MethodAddFilterItemOverridden.  Adds a specified filter to the row filter.  
Public MethodAddForegroundFilter Adds the foreground filter for the row filter. (Inherited from GrapeCity.Xaml.SpreadSheet.Data.RowFilterBase)
Public MethodAddNumberFilter Adds the number filter for the row filter. (Inherited from GrapeCity.Xaml.SpreadSheet.Data.RowFilterBase)
Public MethodAddRowFilteredIn Filters the specified row.  
Public MethodAddTextFilter Adds the text filter for the row filter. (Inherited from GrapeCity.Xaml.SpreadSheet.Data.RowFilterBase)
Public MethodAddTop10Filter Adds the top 10 filter for the row filter. (Inherited from GrapeCity.Xaml.SpreadSheet.Data.RowFilterBase)
Public MethodClearFilterItems Removes all filters for every column.  
Public MethodFilterOverloaded. Overridden.  Filters all columns.  
Public MethodGetColumnSortState Gets the current sort state.  
Public MethodGetFilterableBackgroundColorItems Gets the background colors for filtered data to be displayed in the drop-down list for the specified column.  
Public MethodGetFilterableDataItemsOverridden.  Gets the data that can be filtered and is to be displayed in the drop-down list for the specified column.  
Public MethodGetFilterableForeColorItems Gets the foreground colors for filtered data to be displayed in the drop-down list for the specified column.  
Public MethodGetFilteredColumns Gets the indexes of columns that are filtered.  
Public MethodGetFilteredItemsOverridden.  Gets all the filtered conditions.  
Public MethodGetFilterItemsOverridden.  Gets the filters for the specified column.  
Public MethodGetSorttedColumnIndex Gets the sorted column index.  
Public MethodIsColumnFilteredOverridden.  Determines whether the specified column is filtered.  
Public MethodIsRowFilteredOutOverridden.  Determines whether the specified row is filtered out.  
Public MethodIsSortted Gets whether the filter is sorted.  
Public MethodReFilterOverridden.  Refreshes all the filters.  
Public MethodRemoveFilterItemsOverridden.  Removes the filter for the specified column.  
Public MethodResetOverridden.  Clears all filters.  
Public MethodSortColumn Sorts the specified column in the specified order.  
Public MethodUnfilterOverloaded. Overridden.  Removes the filter for all columns.  
Top
Protected Methods
 NameDescription
Protected MethodOnAddColumnsOverridden.  Adds columns to the filter after the specified column.  
Protected MethodOnAddRowsOverridden.  Adds rows to the filter after the specified row.  
Protected MethodOnClearOverridden.  Removes filters from the specified range  
Protected MethodOnCopyOverridden.  Copies filters from the start range and pastes into a range of cells at the end location.  
Protected MethodOnMoveOverridden.  Moves filters from the start range to a range of cells at the end location.  
Protected MethodOnRemoveColumnsOverridden.  Removes columns from the filter starting with the specified column.  
Protected MethodOnRemoveRowsOverridden.  Removes rows in the filter from the specified row.  
Protected MethodOnSwapOverridden.  Swaps filters in the specified range from one location to another.  
Top
See Also

Reference

HideRowFilter Class
GrapeCity.Xaml.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options