Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum ConditionalFormattingIcon Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As ConditionalFormattingIcon | |
| C# | |
|---|---|
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 uses the ConditionalFormattingIcon enumeration.
| C# | Copy Code |
|---|---|
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.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].SetConditionalFormatting(1,1,c); fpSpread1.Sheets[0].Models.ConditionalFormatting.Add(IconSetCF); } | |
| VB.NET | Copy Code |
|---|---|
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.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).SetConditionalFormatting(1, 1, c) FpSpread1.Sheets(0).Models.ConditionalFormatting.Add(IconSetCF) End Sub | |
Inheritance Hierarchy
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.ConditionalFormattingIcon
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8