Spread WPF 15
GrapeCity.Windows.SpreadSheet.Data Namespace / Worksheet Class / RowFilter Property
Example


In This Topic
    RowFilter Property (Worksheet)
    In This Topic
    Gets or sets the row filter for the sheet.
    Syntax
    'Declaration
 
<DefaultValueAttribute("")>
Public Property RowFilter As RowFilterBase
    'Usage
 
Dim instance As Worksheet
Dim value As RowFilterBase
 
instance.RowFilter = value
 
value = instance.RowFilter
    [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

     

     

    Copyright © 2021 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page