Spread for ASP.NET 11 Product Documentation
FilterMode Property
Example 


FarPoint.Web.Spread.Extender Assembly > FarPoint.Web.Spread.Extender Namespace > FilteredTextCellType Class : FilterMode Property
Gets or sets the filter mode for the filtered text cell.
Syntax
'Declaration
 
Public Property FilterMode As AjaxControlToolkit.FilterModes
'Usage
 
Dim instance As FilteredTextCellType
Dim value As AjaxControlToolkit.FilterModes
 
instance.FilterMode = value
 
value = instance.FilterMode
public AjaxControlToolkit.FilterModes FilterMode {get; set;}

Property Value

FilterModes setting that determines the filter mode
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