IconFilterItem Constructor

Overload List

Overload	Description
IconFilterItem Constructor	Initializes a new instance of the IconFilterItem class.

Example

This example creates an icon conditional formatting rule and then filters based on the icon in the cell.

fpSpread1.Sheets[0].Cells[0, 1].Value = 3;
fpSpread1.Sheets[0].Cells[1, 1].Value = 2;
fpSpread1.Sheets[0].Cells[2, 1].Value = 10;
fpSpread1.Sheets[0].Cells[3, 1].Value = 1;
FarPoint.Win.Spread.IconSetConditionalFormattingRule c = new FarPoint.Win.Spread.IconSetConditionalFormattingRule(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.ThreeTriangles);
c.IconRuleSet.Add(new FarPoint.Win.Spread.ConditionalFormattingIconValue(10, FarPoint.Win.Spread.ConditionalFormattingValueType.Number, true, FarPoint.Win.Spread.ConditionalFormattingIcon.BlackCircle));
FarPoint.Win.Spread.ConditionalFormatting IconSetCF = new FarPoint.Win.Spread.ConditionalFormatting(new FarPoint.Win.Spread.Model.CellRange(0, 0, 2, 2), c);
fpSpread1.Sheets[0].Models.ConditionalFormatting.Add(IconSetCF);
FarPoint.Win.Spread.IconFilterItem iconfilter = new FarPoint.Win.Spread.IconFilterItem(FarPoint.Win.Spread.ConditionalFormattingIcon.BlackCircle);
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(iconfilter);
rowFilter.ColumnDefinitions.Add(fd);
fpSpread1.ActiveSheet.RowFilter = rowFilter;
fpSpread1.ActiveSheet.AutoFilterColumn(1, iconfilter.DisplayName, 0);
fpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu;

VB.NET

FpSpread1.Sheets(0).Cells(0, 1).Value = 3
FpSpread1.Sheets(0).Cells(1, 1).Value = 2
FpSpread1.Sheets(0).Cells(2, 1).Value = 10
FpSpread1.Sheets(0).Cells(3, 1).Value = 1
Dim c As New FarPoint.Win.Spread.IconSetConditionalFormattingRule(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.ThreeTriangles)
c.IconRuleSet.Add(New FarPoint.Win.Spread.ConditionalFormattingIconValue(10, FarPoint.Win.Spread.ConditionalFormattingValueType.Number, True, FarPoint.Win.Spread.ConditionalFormattingIcon.BlackCircle))
Dim IconSetCF As New FarPoint.Win.Spread.ConditionalFormatting(New FarPoint.Win.Spread.Model.CellRange(0, 0, 2, 2), c)
FpSpread1.Sheets(0).Models.ConditionalFormatting.Add(IconSetCF)
Dim iconfilter As New FarPoint.Win.Spread.IconFilterItem(FarPoint.Win.Spread.ConditionalFormattingIcon.BlackCircle)
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(iconfilter)
rowFilter.ColumnDefinitions.Add(fd)
FpSpread1.ActiveSheet.RowFilter = rowFilter
FpSpread1.ActiveSheet.AutoFilterColumn(1, iconfilter.DisplayName, 0)
FpSpread1.ActiveSheet.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.EnhancedContextMenu

Requirements

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

IconFilterItem Class
IconFilterItem Members