Spread for ASP.NET 11 Product Documentation
ValidChars Property
Example 


FarPoint.Web.Spread.Extender Assembly > FarPoint.Web.Spread.Extender Namespace > FilteredTextCellType Class : ValidChars Property
Gets or sets a string that contains all the valid characters for the text field.
Syntax
'Declaration
 
Public Property ValidChars As String
'Usage
 
Dim instance As FilteredTextCellType
Dim value As String
 
instance.ValidChars = value
 
value = instance.ValidChars
public string ValidChars {get; set;}

Property Value

String containing the valid characters
Example
This example sets up a filtered cell type.
FarPoint.Web.Spread.Extender.FilteredTextCellType f = new FarPoint.Web.Spread.Extender.FilteredTextCellType();
f.FilterType = AjaxControlToolkit.FilterTypes.Custom;
f.ValidChars = "0123456789AaBbCcDdEeFf";
f.InvalidChars = "`~!@#$%^&*()-+=[]{}:;\',..<>/? ";
f.ShowEditor = true;
f.FilterMode = AjaxControlToolkit.FilterModes.ValidChars;
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = f;
Dim f As New FarPoint.Web.Spread.Extender.FilteredTextCellType
f.FilterType = AjaxControlToolkit.FilterTypes.Custom
f.ValidChars = "0123456789AaBbCcDdEeFf"
f.InvalidChars = "`~!@#$%^&*()-+=[]{}:;',.<>/? "
f.ShowEditor = True
f.FilterMode = AjaxControlToolkit.FilterModes.ValidChars
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = f
See Also

Reference

FilteredTextCellType Class
FilteredTextCellType Members