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


In This Topic
    BlanksString Property (DefaultRowFilter)
    In This Topic
    Gets or sets the blanks (empty cells) string.
    Syntax
    'Declaration
     
    Public Property BlanksString As String
    'Usage
     
    Dim instance As DefaultRowFilter
    Dim value As String
     
    instance.BlanksString = value
     
    value = instance.BlanksString
    public string BlanksString {get; set;}

    Property Value

    String containing the string for including blanks
    Example
    This examples sets up a string to replace the "Blanks" 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