DynamicFilterItem Constructor

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal dynamicFilterType As DynamicFilterType _
)

'Usage
 
Dim dynamicFilterType As DynamicFilterType
 
Dim instance As New DynamicFilterItem(dynamicFilterType)

public DynamicFilterItem( 
   DynamicFilterType dynamicFilterType
)

Parameters

dynamicFilterType

This example filters above average values.

C#

fpSpread1.Sheets[0].Cells[0, 0, 2, 2].Value = 3;
FarPoint.Win.Spread.DynamicFilterItem dy = new FarPoint.Win.Spread.DynamicFilterItem(FarPoint.Win.Spread.DynamicFilterType.AboveAverage);
FarPoint.Win.Spread.IRowFilter rowFilter = new FarPoint.Win.Spread.HideRowFilter(fpSpread1.ActiveSheet);
FarPoint.Win.Spread.FilterColumnDefinition fd = new FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Custom);
fd.Filters.Add(dy);
rowFilter.ColumnDefinitions.Add(fd);
fpSpread1.ActiveSheet.RowFilter = rowFilter;
fpSpread1.ActiveSheet.AutoFilterColumn(1, dy.DisplayName, 0);
fpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu;

VB.NET

FpSpread1.Sheets(0).Cells(0, 0, 2, 2).Value = 3
Dim dy As New FarPoint.Win.Spread.DynamicFilterItem(FarPoint.Win.Spread.DynamicFilterType.AboveAverage)
Dim rowFilter As New FarPoint.Win.Spread.HideRowFilter(FpSpread1.ActiveSheet)
Dim fd As New FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Custom)
fd.Filters.Add(dy)
rowFilter.ColumnDefinitions.Add(fd)
FpSpread1.ActiveSheet.RowFilter = rowFilter
FpSpread1.ActiveSheet.AutoFilterColumn(1, dy.DisplayName, 0)
FpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

DynamicFilterItem Class
DynamicFilterItem Members