Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / ConditionalFormattingIcon Enumeration
Example Example

In This Topic
    ConditionalFormattingIcon Enumeration
    In This Topic
    Represents the predefined icon for conditional formatting.
    Public Enum ConditionalFormattingIcon 
       Inherits System.Enum
    Dim instance As ConditionalFormattingIcon
    public enum ConditionalFormattingIcon : System.Enum 
    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.
    This example uses the ConditionalFormattingIcon enumeration.
    private void Form1_Load(object sender, EventArgs e)
                fpSpread1.Sheets[0].Cells[0, 0].Value = 3;
                fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
                fpSpread1.Sheets[0].Cells[1, 1].Value = 10;
                fpSpread1.Sheets[0].Cells[0, 2].Value = 1;
            private void button1_Click(object sender, EventArgs e)
                FarPoint.Win.Spread.IconSetConditionalFormattingRule c = new FarPoint.Win.Spread.IconSetConditionalFormattingRule(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.ThreeTriangles);
                c.IconRuleSet.Insert(0, 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);    
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            FpSpread1.Sheets(0).Cells(0, 0).Value = 3
            FpSpread1.Sheets(0).Cells(1, 0).Value = 2
            FpSpread1.Sheets(0).Cells(1, 1).Value = 10
            FpSpread1.Sheets(0).Cells(0, 2).Value = 1
        End Sub
        Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
            Dim c As New FarPoint.Win.Spread.IconSetConditionalFormattingRule(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.ThreeTriangles)
            c.IconRuleSet.Insert(0, 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)        
        End Sub
    Inheritance Hierarchy


    See Also