Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / DefaultRowFilter Class / AllString Property
Example


In This Topic
    AllString Property (DefaultRowFilter)
    In This Topic
    Gets or sets the all filter items string.
    Syntax
    'Declaration
 
Public Property AllString As String
    'Usage
 
Dim instance As DefaultRowFilter
Dim value As String
 
instance.AllString = value
 
value = instance.AllString
    public string AllString {get; set;}

    Property Value

    String containing the string for including all items
    Example
    This examples sets up a string to replace the "All" string in the filter list. 
    fpSpread1.ActiveSheet.Columns[1].AllowAutoFilter = true;
fpSpread1.ActiveSheet.RowFilter.ShowFilterIndicator = true;
fpSpread1.ActiveSheet.RowFilter.AllString = "Show All"; 
fpSpread1.ActiveSheet.RowFilter.BlanksString = "Show The Blanks";
fpSpread1.ActiveSheet.RowFilter.NonBlanksString = "Show The Non-Blanks";

    FpSpread1.ActiveSheet.Columns(1).AllowAutoFilter = True
FpSpread1.ActiveSheet.RowFilter.ShowFilterIndicator = True
FpSpread1.ActiveSheet.RowFilter.AllString = "Show All" 
FpSpread1.ActiveSheet.RowFilter.BlanksString = "Show The Blanks"
FpSpread1.ActiveSheet.RowFilter.NonBlanksString = "Show The Non-Blanks"
    See Also

    Reference

    DefaultRowFilter Class
    DefaultRowFilter Members

     

     

    Copyright © 2003-2020 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page