Color Property (ColorFilterItem)

Visual Basic
C#

'Declaration
 
Public Property Color As Color

'Usage
 
Dim instance As ColorFilterItem
Dim value As Color
 
instance.Color = value
 
value = instance.Color

public Color Color {get; set;}

This example sets a color filter.

C#

FarPoint.Web.Spread.ColorFilterItem cfilter = new FarPoint.Web.Spread.ColorFilterItem(false, Color.Beige);
cfilter.Color = Color.Beige;
cfilter.FilterTextColor = false;

FarPoint.Web.Spread.IRowFilter rowFilter = new FarPoint.Web.Spread.HideRowFilter(FpSpread1.ActiveSheetView);
FarPoint.Web.Spread.FilterColumnDefinition fd = new FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.Custom);
fd.Filters.Add(cfilter);
rowFilter.ColumnDefinitions.Add(fd);
FpSpread1.ActiveSheetView.RowFilter = rowFilter;

FpSpread1.ActiveSheetView.Cells[0, 1].BackColor = Color.Beige;
FpSpread1.ActiveSheetView.Cells[1, 1].BackColor = Color.Aqua;
FpSpread1.ActiveSheetView.Cells[2, 1].BackColor = Color.Beige;

Visual Basic

Dim cfilter As New FarPoint.Web.Spread.ColorFilterItem(False, Color.Beige)
cfilter.Color = Color.Beige
cfilter.FilterTextColor = False

Dim rowFilter As New FarPoint.Web.Spread.HideRowFilter(FpSpread1.ActiveSheetView)
Dim fd As New FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.Custom)
fd.Filters.Add(cfilter)
rowFilter.ColumnDefinitions.Add(fd)
FpSpread1.ActiveSheetView.RowFilter = rowFilter

FpSpread1.ActiveSheetView.Cells(0, 1).BackColor = Color.Beige
FpSpread1.ActiveSheetView.Cells(1, 1).BackColor = Color.Aqua
FpSpread1.ActiveSheetView.Cells(2, 1).BackColor = Color.Beige

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

ColorFilterItem Class
ColorFilterItem Members