Spread ASP.NET 14
FarPoint.Web.Spread.Extender Assembly / FarPoint.Web.Spread.Extender Namespace / FilteredTextCellType Class / FilterType Property
Example


In This Topic
    FilterType Property
    In This Topic
    Gets or sets the type of filter for the filtered text cell.
    Syntax
    'Declaration
     
    Public Property FilterType As AjaxControlToolkit.FilterTypes
    'Usage
     
    Dim instance As FilteredTextCellType
    Dim value As AjaxControlToolkit.FilterTypes
     
    instance.FilterType = value
     
    value = instance.FilterType
    public AjaxControlToolkit.FilterTypes FilterType {get; set;}

    Property Value

    FilterType setting that determines the type of filter
    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