Spread ASP.NET 15
FarPoint.Web.Spread.Extender Assembly / FarPoint.Web.Spread.Extender Namespace / FilteredTextCellType Class / InvalidChars Property
Example


In This Topic
    InvalidChars Property
    In This Topic
    Gets or sets a string that contains all the invalid characters for the text field.
    Syntax
    'Declaration
     
    Public Property InvalidChars As String
    'Usage
     
    Dim instance As FilteredTextCellType
    Dim value As String
     
    instance.InvalidChars = value
     
    value = instance.InvalidChars
    public string InvalidChars {get; set;}

    Property Value

    String containing the invalid 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