Spread for ASP.NET 11 Product Documentation
Color Property (ColorFilterItem)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > ColorFilterItem Class : Color Property
Gets or sets the filter based on color.
Syntax
'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;}
Example
This example sets a color filter.
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;
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
See Also

Reference

ColorFilterItem Class
ColorFilterItem Members