FilterMatchingMode Enumeration

Specifies the match methods used in the automatic filter.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum FilterMatchingMode 
   Inherits System.Enum

'Usage
 
Dim instance As FilterMatchingMode

public enum FilterMatchingMode : System.Enum

Members

Member	Description
AmbiguousMatchAll	Specifies to use the new ambiguous search engine when searching all substrings.
AmbiguousMatchStartWith	Specifies to use the new ambiguous search engine when searching for items that start with the value.
ExactMatchAll	Specifies to use a similar mode as MatchAll, except the search is case-sensitive.
ExactMatchStartWith	Specifies to use a similar mode as MatchStartWith, except the search is case-sensitive.
MatchAll	Specifies to search all possible substrings in the candidate list items and to ignore the case.
MatchStartWith	Specifies to use the same method as the current automatic complete matching feature and specifies to find items that start with the value and to ignore the case.

Example

This example sets the matching mode.

FarPoint.Web.Spread.AutoFilter afilter = new FarPoint.Web.Spread.AutoFilter();
afilter.Enabled = true;
afilter.MatchingSource = FarPoint.Web.Spread.FilterMatchingSource.AllColumns;
afilter.MinPrefixLength = 1;
afilter.MaxFilteredItem = 10;
afilter.Interval = 4;
afilter.MatchingMode = FarPoint.Web.Spread.FilterMatchingMode.ExactMatchAll;

System.Data.DataSet ds = new System.Data.DataSet();
System.Data.DataTable emp = new System.Data.DataTable("Employees");
System.Data.DataTable div = new System.Data.DataTable("Division");
emp.Columns.Add("LastName");
emp.Columns.Add("FirstName");
emp.Rows.Add(new Object[] { "Jones", "Marianne" });
emp.Rows.Add(new Object[] { "Fieldes", "Anna" });
emp.Rows.Add(new Object[] { "Johnson", "Anna" });
div.Columns.Add("Section");
div.Columns.Add("Specialty");
div.Rows.Add(new Object[] { "Finance", "Taxes" });
div.Rows.Add(new Object[] { "Mergers", "Legal" });
ds.Tables.AddRange(new System.Data.DataTable[] { emp, div });
FarPoint.Web.Spread.MultiColumnComboBoxCellType mccbct = new FarPoint.Web.Spread.MultiColumnComboBoxCellType();
mccbct.DataSource = ds;
mccbct.VerticalAlign = VerticalAlign.Top;
mccbct.AutoFilter = afilter;
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = mccbct;

Visual Basic

Dim afilter As New FarPoint.Web.Spread.AutoFilter()
afilter.Enabled = True
afilter.MatchingSource = FarPoint.Web.Spread.FilterMatchingSource.AllColumns
afilter.MinPrefixLength = 1
afilter.MaxFilteredItem = 10
afilter.Interval = 4
afilter.MatchingMode = FarPoint.Web.Spread.FilterMatchingMode.ExactMatchAll

Dim ds As New System.Data.DataSet()
Dim emp As New System.Data.DataTable("Employees")
Dim div As New System.Data.DataTable("Division")
emp.Columns.Add("LastName")
emp.Columns.Add("FirstName")
emp.Rows.Add(New Object() {"Jones", "Marianne"})
emp.Rows.Add(New Object() {"Fieldes", "Anna"})
emp.Rows.Add(New Object() {"Johnson", "Anna"})
div.Columns.Add("Section")
div.Columns.Add("Specialty")
div.Rows.Add(New Object() {"Finance", "Taxes"})
div.Rows.Add(New Object() {"Mergers", "Legal"})
ds.Tables.AddRange(New System.Data.DataTable() {emp, div})
Dim mccbct As New FarPoint.Web.Spread.MultiColumnComboBoxCellType()
mccbct.DataSource = ds
mccbct.VerticalAlign = VerticalAlign.Top
mccbct.AutoFilter = afilter
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = mccbct

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.FilterMatchingMode

Reference

FarPoint.Web.Spread Namespace