ConditionalFormattingIcon Enumeration

Represents the predefined icon for conditional formatting.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum ConditionalFormattingIcon 
   Inherits System.Enum

'Usage
 
Dim instance As ConditionalFormattingIcon

public enum ConditionalFormattingIcon : System.Enum

Members

Member	Description
BlackCircle	Specifies the black circle icon.
BlackCircleWithBorder	Specifies the black circle with a border icon.
CircleWithOneWhiteQuarter	Specifies the circle with one white quarter icon.
CircleWithThreeWhiteQuarters	Specifies the circle with three white quarters icon.
CircleWithTwoWhiteQuarters	Specifies the circle with two white quarters icon.
Custom	Specifies a custom icon.
FourFilledBoxes	Specifies the four filled boxes icon.
GoldStar	Specifies the gold star icon.
GrayCircle	Specifies the gray circle icon.
GrayDownArrow	Specifies the gray down arrow icon.
GrayDownInclineArrow	Specifies the gray down incline arrow icon.
GraySideArrow	Specifies the gray side arrow icon.
GrayUpArrow	Specifies the gray up arrow icon.
GrayUpInclineArrow	Specifies the gray up incline arrow icon.
GreenCheck	Specifies the green check icon.
GreenCheckSymbol	Specifies the green check symbol icon.
GreenCircle	Specifies the green circle icon.
GreenFlag	Specifies the green flag icon.
GreenTrafficLight	Specifies the green traffic light icon.
GreenUpArrow	Specifies the green up arrow icon.
GreenUpTriangle	Specifies the green up triangle icon.
HalfGoldStar	Specifies the half gold star icon.
None	Specifies no icon.
OneFilledBox	Specifies the one filled box icon.
PinkCircle	Specifies the pink circle icon.
RedCircle	Specifies the red circle icon.
RedCircleWithBorder	Specifies the red circle with border icon.
RedCross	Specifies the red cross icon.
RedCrossSymbol	Specifies the red cross symbol icon.
RedDiamond	Specifies the red diamond icon.
RedDownArrow	Specifies the red down arrow icon.
RedDownTriangle	Specifies the red down triangle icon.
RedFlag	Specifies the red flag icon.
RedTrafficLight	Specifies the red traffic light icon.
SignalMeterWithFourFilledBars	Specifies the signal meter with four filled bars icon.
SignalMeterWithNoFilledBars	Specifies the signal meter with no filled bars icon.
SignalMeterWithOneFilledBar	Specifies the signal meter with one filled bar icon.
SignalMeterWithThreeFilledBars	Specifies the signal meter with three filled bars icon.
SignalMeterWithTwoFilledBars	Specifies the signal meter with two filled bars icon.
SilverStar	Specifies the silver star icon.
ThreeFilledBoxes	Specifies the three filled boxes icon.
TwoFilledBoxes	Specifies the two filled boxes icon.
WhiteCircle	Specifies the white circle icon.
YellowCircle	Specifies the yellow circle icon.
YellowDash	Specifies the yellow dash icon.
YellowDownInclineArrow	Specifies the yellow down incline arrow icon.
YellowExclamation	Specifies the yellow exclamation icon.
YellowExclamationSymbol	Specifies the yellow exclamation symbol icon.
YellowFlag	Specifies the yellow flag icon.
YellowSideArrow	Specifies the yellow side arrow icon.
YellowTrafficLight	Specifies the yellow traffic light icon.
YellowTriangle	Specifies the yellow triangle icon.
YellowUpInclineArrow	Specifies the yellow up incline arrow icon.
ZeroFilledBoxes	Specifies the zero filled boxes icon.

Example

This example sets the ConditionalFormattingIcon enumeration.

protected void Page_Load(object sender, System.EventArgs e)
{
if (this.IsPostBack) return;
FpSpread1.Sheets[0].RowCount = 5;
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.Web.Spread.IconSetConditionalFormattingRule c = new FarPoint.Web.Spread.IconSetConditionalFormattingRule(FarPoint.Web.Spread.ConditionalFormattingIconSetStyle.ThreeTriangles);
c.IconRuleSet.Add(new FarPoint.Web.Spread.ConditionalFormattingIconValue(10, FarPoint.Web.Spread.ConditionalFormattingValueType.Number, true, FarPoint.Web.Spread.ConditionalFormattingIcon.BlackCircle));
FarPoint.Web.Spread.ConditionalFormatting IconSetCF = new FarPoint.Web.Spread.ConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2), c);
FpSpread1.Sheets[0].ConditionalFormatting.Add(IconSetCF);
FarPoint.Web.Spread.IconFilterItem iconfilter = new FarPoint.Web.Spread.IconFilterItem(FarPoint.Web.Spread.ConditionalFormattingIcon.BlackCircle);
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(iconfilter);
rowFilter.ColumnDefinitions.Add(fd);
FpSpread1.ActiveSheetView.RowFilter = rowFilter;
FpSpread1.ActiveSheetView.AutoFilterColumn(1, iconfilter.DisplayName);
FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.Enhanced;
}

VB.NET

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If (IsPostBack) Then
    Return
End If
FpSpread1.Sheets(0).RowCount = 5
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.Web.Spread.IconSetConditionalFormattingRule(FarPoint.Web.Spread.ConditionalFormattingIconSetStyle.ThreeTriangles)
c.IconRuleSet.Add(New FarPoint.Web.Spread.ConditionalFormattingIconValue(10, FarPoint.Web.Spread.ConditionalFormattingValueType.Number, True, FarPoint.Web.Spread.ConditionalFormattingIcon.BlackCircle))
Dim IconSetCF As New FarPoint.Web.Spread.ConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2), c)
FpSpread1.Sheets(0).ConditionalFormatting.Add(IconSetCF)
Dim iconfilter As New FarPoint.Web.Spread.IconFilterItem(FarPoint.Web.Spread.ConditionalFormattingIcon.BlackCircle)
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(iconfilter)
rowFilter.ColumnDefinitions.Add(fd)
FpSpread1.ActiveSheetView.RowFilter = rowFilter
FpSpread1.ActiveSheetView.AutoFilterColumn(1, iconfilter.DisplayName)
FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.Enhanced
End Sub

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.ConditionalFormattingIcon

Reference

FarPoint.Web.Spread Namespace