Spread Windows Forms 12.0 Product Documentation
BlanksString Property (DefaultRowFilter)

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > DefaultRowFilter Class : BlanksString Property
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 string for including blanks
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


DefaultRowFilter Class
DefaultRowFilter Members