Spread for ASP.NET 11 Product Documentation
FilterType Property
Example 


FarPoint.Web.Spread.Extender Assembly > FarPoint.Web.Spread.Extender Namespace > FilteredTextCellType Class : FilterType Property
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

Reference

FilteredTextCellType Class
FilteredTextCellType Members