FilterType Property

Gets or sets the type of filter for the filtered text cell.

Syntax

Visual Basic
C#

'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;

Visual Basic

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

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FilteredTextCellType Class
FilteredTextCellType Members