Range Property (RowFilterBase)

Gets or sets the cell range for the row filter.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Property Range As CellRange

'Usage
 
Dim instance As RowFilterBase
Dim value As CellRange
 
instance.Range = value
 
value = instance.Range

public virtual CellRange Range {get; set;}

Example

This example creates a row filter.

gcSpreadSheet1.Sheets[0].RowFilter = new HideRowFilter();
gcSpreadSheet1.Sheets[0].RowFilter.Range = new CellRange(1, 1, 4, 4);

private void Button_Click(object sender, RoutedEventArgs e)
        {
            gcSpreadSheet1.Sheets[0].RowFilter.ShowFilterButton = false;
            gcSpreadSheet1.Invalidate();
        }

VB.NET

GcSpreadSheet1.Sheets(0).RowFilter = New HideRowFilter()
GcSpreadSheet1.Sheets(0).RowFilter.Range = New CellRange(1, 1, 4, 4)

Private Sub Button_Click(sender As System.Object, e As System.Windows.RoutedEventArgs)
        GcSpreadSheet1.Sheets(0).RowFilter.ShowFilterButton = False
        GcSpreadSheet1.Invalidate()
    End Sub

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

RowFilterBase Class
RowFilterBase Members