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

In This Topic
    FilterType Property
    In This Topic
    Gets or sets the type of filter for the filtered text cell.
    Public Property FilterType As AjaxControlToolkit.FilterTypes
    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
    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