Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / DefaultRowFilter Class / BlanksString Property

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

    Property Value

    String containing the display text for the Blanks option
    This example changes the text of a filter list item.
    FarPoint.Web.Spread.NamedStyle instyle = new FarPoint.Web.Spread.NamedStyle();
    FarPoint.Web.Spread.NamedStyle outstyle = new FarPoint.Web.Spread.NamedStyle();
    instyle.BackColor = Color.Yellow;
    outstyle.BackColor = Color.Gray;
    FarPoint.Web.Spread.StyleRowFilter rf = new FarPoint.Web.Spread.StyleRowFilter(FpSpread1.Sheets[0], instyle, outstyle);
    FpSpread1.Sheets[0].RowFilter = rf;
    // Assign filter and customize filter options
    FpSpread1.Sheets[0].RowFilter.ShowFilterIndicator = true;
    FpSpread1.Sheets[0].RowFilter.AllString = "Show All";
    FpSpread1.Sheets[0].RowFilter.BlanksString = "Show The Blanks";
    FpSpread1.Sheets[0].RowFilter.NonBlanksString = "Show The Non-Blanks";
    Dim instyle As New FarPoint.Web.Spread.NamedStyle()
    Dim outstyle As New FarPoint.Web.Spread.NamedStyle()
    instyle.BackColor = Color.Yellow
    outstyle.BackColor = Color.Gray
    Dim rf As New FarPoint.Web.Spread.StyleRowFilter(FpSpread1.Sheets(0), instyle, outstyle)
    FpSpread1.Sheets(0).RowFilter = rf
    ' Assign filter and customize filter options
    FpSpread1.Sheets(0).RowFilter.ShowFilterIndicator = True
    FpSpread1.Sheets(0).RowFilter.AllString = "Show All"
    FpSpread1.Sheets(0).RowFilter.BlanksString = "Show The Blanks"
    FpSpread1.Sheets(0).RowFilter.NonBlanksString = "Show The Non-Blanks"
    See Also