Visual Basic (Declaration) | |
---|---|
Public Enum FilterListBehavior Inherits System.Enum |
Visual Basic (Usage) | ![]() |
---|---|
Dim instance As FilterListBehavior |
C# | |
---|---|
public enum FilterListBehavior : System.Enum |
Member | Description |
---|---|
Blank | [2] Displays the "(Blanks)" item in the drop-down list when appropriate |
Custom | [0] Uses the custom filter |
Default | [1031] Uses the default filter behavior, including Blank, NonBlank, and SortAlphabetically |
DefaultFilter | [1024] Includes in the drop-down list the DefaultFilterItem implementation of IFilterItem |
NonBlank | [4] Displays the "(NonBlanks)" item in the drop-down list when appropriate |
SortAlphabetically | [1025] Uses the default filter behavior and sorts the drop-down list alphabetically |
SortByLeastOccurrences | [1040] Sorts the drop-down list by the number of times an item occurs from least to most |
SortByMostOccurrences | [1032] Sorts the drop-down list by the number of times an item occurs from most to least |
SortNoSort | [1056] Uses the default filter behavoir and does not perform a sort on the drop-down list. |
SortNumerically | [1088] Uses the default filter behavior and sorts the drop-down list numerically |
This example returns the row and column of the found text if it's in a cell.
C# | ![]() |
---|---|
FarPoint.Win.Spread.NamedStyle instyle = new FarPoint.Win.Spread.NamedStyle(); FarPoint.Win.Spread.NamedStyleim outstyle = new FarPoint.Win.Spread.NamedStyle(); instyle.BackColor = Color.Yellow; outstyle.BackColor = Color.Aquamarine; FarPoint.Win.Spread.FilterColumnDefinition fcd = new FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.SortByMostOccurrences | FarPoint.Win.Spread.FilterListBehavior.Default); FarPoint.Win.Spread.FilterColumnDefinition fcd1 = new FarPoint.Win.Spread.FilterColumnDefinition(2); FarPoint.Win.Spread.FilterColumnDefinition fcd2 = new FarPoint.Win.Spread.FilterColumnDefinition(); FarPoint.Win.Spread.StyleRowFilter sf = new FarPoint.Win.Spread.StyleRowFilter(fpSpread1.ActiveSheet, instyle, outstyle); sf.AddColumn(fcd); sf.AddColumn(fcd1); sf.AddColumn(fcd2); fpSpread1.ActiveSheet.RowFilter = sf; |
Visual Basic | ![]() |
---|---|
Dim instyle As New FarPoint.Win.Spread.NamedStyle Dim outstyle As New FarPoint.Win.Spread.NamedStyle instyle.BackColor = Color.Yellow outstyle.BackColor = Color.Aquamarine Dim fcd As New FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.SortByMostOccurrences Or FarPoint.Win.Spread.FilterListBehavior.Default) Dim fcd1 As New FarPoint.Win.Spread.FilterColumnDefinition(2) Dim fcd2 As New FarPoint.Win.Spread.FilterColumnDefinition Dim sf As New FarPoint.Win.Spread.StyleRowFilter(fpSpread1.ActiveSheet, instyle, outstyle) sf.AddColumn(fcd) sf.AddColumn(fcd1) sf.AddColumn(fcd2) fpSpread1.ActiveSheet.RowFilter = sf |
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.FilterListBehavior
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
Reference
FarPoint.Win.Spread NamespaceListBehavior Property (FilterColumnDefinition Class)