Spread for ASP.NET 7.0 Product Documentation
FilterType Property
See Also  Example Support Options
FarPoint.Web.Spread.Extender Assembly > FarPoint.Web.Spread.Extender Namespace > FilteredTextCellType Class : FilterType Property


Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Property FilterType As AjaxControlToolkit.FilterTypes
Visual Basic (Usage)Copy Code
Dim instance As FilteredTextCellType
Dim value As AjaxControlToolkit.FilterTypes
 
instance.FilterType = value
 
value = instance.FilterType
C# 
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.
C#Copy Code
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 BasicCopy Code
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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.