FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace : ConditionalFormattingIcon Enumeration |
'Declaration Public Enum ConditionalFormattingIcon Inherits System.Enum
'Usage Dim instance As ConditionalFormattingIcon
public enum ConditionalFormattingIcon : System.Enum
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. |
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); }
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
System.Object
System.ValueType
System.Enum
FarPoint.Win.Spread.ConditionalFormattingIcon
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8