Spread Windows Forms 11.0 Product Documentation
ConditionalFormattingIcon Enumeration
Example Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace : ConditionalFormattingIcon Enumeration
Represents the predefined icon for conditional formatting.
Syntax
'Declaration
 
Public Enum ConditionalFormattingIcon 
   Inherits System.Enum
'Usage
 
Dim instance As ConditionalFormattingIcon
public enum ConditionalFormattingIcon : System.Enum 
Members
MemberDescription
BlackCircleSpecifies the black circle icon.
BlackCircleWithBorderSpecifies the black circle with a border icon.
CircleWithOneWhiteQuarterSpecifies the circle with one white quarter icon.
CircleWithThreeWhiteQuartersSpecifies the circle with three white quarters icon.
CircleWithTwoWhiteQuartersSpecifies the circle with two white quarters icon.
CustomSpecifies a custom icon
FourFilledBoxesSpecifies the four filled boxes icon.
GoldStarSpecifies the gold star icon.
GrayCircleSpecifies the gray circle icon.
GrayDownArrowSpecifies the gray down arrow icon.
GrayDownInclineArrowSpecifies the gray down incline arrow icon.
GraySideArrowSpecifies the gray side arrow icon.
GrayUpArrowSpecifies the gray up arrow icon.
GrayUpInclineArrowSpecifies the gray up incline arrow icon.
GreenCheckSpecifies the green check icon.
GreenCheckSymbolSpecifies the green check symbol icon.
GreenCircleSpecifies the green circle icon.
GreenFlagSpecifies the green flag icon.
GreenTrafficLightSpecifies the green traffic light icon.
GreenUpArrowSpecifies the green up arrow icon.
GreenUpTriangleSpecifies the green up triangle icon.
HalfGoldStarSpecifies the half gold star icon.
NoneSpecifies no icon
OneFilledBoxSpecifies the one filled box icon.
PinkCircleSpecifies the pink circle icon.
RedCircleSpecifies the red circle icon.
RedCircleWithBorderSpecifies the red circle with border icon.
RedCrossSpecifies the red cross icon.
RedCrossSymbolSpecifies the red cross symbol icon.
RedDiamondSpecifies the red diamond icon.
RedDownArrowSpecifies the red down arrow icon.
RedDownTriangleSpecifies the red down triangle icon.
RedFlagSpecifies the red flag icon.
RedTrafficLightSpecifies the red traffic light icon.
SignalMeterWithFourFilledBarsSpecifies the signal meter with four filled bars icon.
SignalMeterWithNoFilledBarsSpecifies the signal meter with no filled bars icon.
SignalMeterWithOneFilledBarSpecifies the signal meter with one filled bar icon.
SignalMeterWithThreeFilledBarsSpecifies the signal meter with three filled bars icon.
SignalMeterWithTwoFilledBarsSpecifies the signal meter with two filled bars icon.
SilverStarSpecifies the silver star icon.
ThreeFilledBoxesSpecifies the three filled boxes icon.
TwoFilledBoxesSpecifies the two filled boxes icon.
WhiteCircleSpecifies the white circle icon.
YellowCircleSpecifies the yellow circle icon.
YellowDashSpecifies the yellow dash icon.
YellowDownInclineArrowSpecifies the yellow down incline arrow icon.
YellowExclamationSpecifies the yellow exclamation icon.
YellowExclamationSymbolSpecifies the yellow exclamation symbol icon.
YellowFlagSpecifies the yellow flag icon.
YellowSideArrowSpecifies the yellow side arrow icon.
YellowTrafficLightSpecifies the yellow traffic light icon.
YellowTriangleSpecifies the yellow triangle icon.
YellowUpInclineArrowSpecifies the yellow up incline arrow icon.
ZeroFilledBoxesSpecifies the zero filled boxes icon.
Example
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)
        {

            //IconSetConditionalFormatting
            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);    
            //fpSpread1.Sheets[0].SetConditionalFormatting(1,1,c);
            fpSpread1.Sheets[0].Models.ConditionalFormatting.Add(IconSetCF);
        }
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
        'IconSetConditionalFormatting
        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)        
        FpSpread1.Sheets(0).Models.ConditionalFormatting.Add(IconSetCF)
    End Sub
Inheritance Hierarchy

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

See Also

Reference

FarPoint.Win.Spread Namespace