Spread Windows Forms 7.0 Product Documentation
NonBlanksString Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > DefaultRowFilter Class : NonBlanksString Property


Glossary Item Box

Gets or sets the non-blanks (non-empty cells) string.

Syntax

Visual Basic (Declaration) 
Public Property NonBlanksString As String
Visual Basic (Usage)Copy Code
Dim instance As DefaultRowFilter
Dim value As String
 
instance.NonBlanksString = value
 
value = instance.NonBlanksString
C# 
public string NonBlanksString {get; set;}

Property Value

String containing the string for including non-blank items

Example

This example sets up a string to replace the "NonBlanks" 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 BasicCopy 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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.