Gets or sets the blanks (empty cells) string.
Syntax
Visual Basic (Declaration) | |
---|
Public Property BlanksString As String |
Visual Basic (Usage) | Copy Code |
---|
Dim instance As DefaultRowFilter
Dim value As String
instance.BlanksString = value
value = instance.BlanksString |
C# | |
---|
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.
C# | Copy Code |
---|
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";
|
Visual Basic | Copy Code |
---|
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"
|
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also