Spread WPF Documentation
RowFilter Property (Worksheet)
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class : RowFilter Property
Gets or sets the row filter for the sheet.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property RowFilter As RowFilterBase
'Usage
 
Dim instance As Worksheet
Dim value As RowFilterBase
 
instance.RowFilter = value
 
value = instance.RowFilter
[System.ComponentModel.DefaultValue()]
public RowFilterBase RowFilter {get; set;}

Property Value

The row filter for the sheet.
Example
This example sets the RowFilter property.
GrapeCity.Windows.SpreadSheet.Data.CellRange cellrange = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1);
GrapeCity.Windows.SpreadSheet.Data.HideRowFilter hideRowFilter = new GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(cellrange);
gcSpreadSheet1.Sheets[0].RowFilter = hideRowFilter;
Dim cellrange As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)
Dim hideRowFilter As New GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(cellrange)
GcSpreadSheet1.Sheets(0).RowFilter = hideRowFilter
GcSpreadSheet1.Invalidate()
See Also

Reference

Worksheet Class
Worksheet Members