ConditionalFormattingIconSetStyle Enumeration

Represents the style of the icon set.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum ConditionalFormattingIconSetStyle 
   Inherits System.Enum

'Usage
 
Dim instance As ConditionalFormattingIconSetStyle

public enum ConditionalFormattingIconSetStyle : System.Enum

Members

Member	Description
Custom	Indicates a set of custom icons.
FiveBoxes	Indicates a set of five box icons.
FiveColoredArrows	Indicates a set of five colored arrow icons.
FiveGrayArrows	Indicates a set of five gray arrow icons.
FiveQuarters	Indicates a set of five quarter icons.
FiveRatings	Indicates a set of five rating icons.
FourColoredArrows	Indicates a set of four colored arrow icons.
FourGrayArrows	Indicates a set of four gray arrow icons.
FourRatings	Indicates a set of four rating icons.
FourTrafficLights	Indicates a set of four traffic light icons.
RedToBlack	Indicates a set of circled icons from red to black.
ThreeCircledSymbols	Indicates a set of three circled symbol icons.
ThreeColoredArrows	Indicates a set of three colored arrow icons.
ThreeFlags	Indicates a set of three flag icons.
ThreeGrayArrows	Indicates a set of three gray arrow icons.
ThreeRimmedTrafficLights	Indicates a set of three rimmed traffic light icons.
ThreeSigns	Indicates a set of three sign icons.
ThreeStars	Indicates a set of three star icons.
ThreeTriangles	Indicates a set of three triangle icons.
ThreeUnCircledSymbols	Indicates a set of three uncircled symbol icons.
ThreeUnrimmedTrafficLights	Indicates a set of three unrimmed traffic light icons.

Example

This example creates a conditional rule.

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);
        }

VB.NET

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.ConditionalFormattingIconSetStyle

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

FarPoint.Win.Spread Namespace