ColorFilterItem Constructor

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal filterTextColor As Boolean, _
   ByVal color As Color _
)

'Usage
 
Dim filterTextColor As Boolean
Dim color As Color
 
Dim instance As New ColorFilterItem(filterTextColor, color)

public ColorFilterItem( 
   bool filterTextColor,
   Color color
)

Parameters

filterTextColor: A boolean value that specifies the filter based on the forecolor
color: A color value that specifies the color

This example filters based on the cell color.

C#

fpSpread1.Sheets[0].Cells[0, 0, 2, 2].BackColor = Color.Red;
FarPoint.Win.Spread.ColorFilterItem colorfilter = new FarPoint.Win.Spread.ColorFilterItem(false, Color.Red);
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(colorfilter);
rowFilter.ColumnDefinitions.Add(fd);
fpSpread1.ActiveSheet.RowFilter = rowFilter;
fpSpread1.ActiveSheet.AutoFilterColumn(1, colorfilter.DisplayName, 0);
fpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu;

VB.NET

FpSpread1.Sheets(0).Cells(0, 0, 2, 2).BackColor = Color.Red
Dim colorfilter As New FarPoint.Win.Spread.ColorFilterItem(False, Color.Red)
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(colorfilter)
rowFilter.ColumnDefinitions.Add(fd)
FpSpread1.ActiveSheet.RowFilter = rowFilter
FpSpread1.ActiveSheet.AutoFilterColumn(1, colorfilter.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

ColorFilterItem Class
ColorFilterItem Members