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


Glossary Item Box

Gets or sets the filter mode for the filtered text cell.

Syntax

Visual Basic (Declaration) 
Public Property FilterMode As AjaxControlToolkit.FilterModes
Visual Basic (Usage)Copy Code
Dim instance As FilteredTextCellType
Dim value As AjaxControlToolkit.FilterModes
 
instance.FilterMode = value
 
value = instance.FilterMode
C# 
public AjaxControlToolkit.FilterModes FilterMode {get; set;}

Property Value

FilterModes setting that determines the filter mode

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.