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

In This Topic
    ConditionalFormattingIconSetStyle Enumeration
    In This Topic
    Represents the style of the icon set.
    Public Enum ConditionalFormattingIconSetStyle 
       Inherits System.Enum
    Dim instance As ConditionalFormattingIconSetStyle
    public enum ConditionalFormattingIconSetStyle : System.Enum 
    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 circle 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.
    This example creates a conditional rule.
    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.ConditionalFormattingIconSetIndex iconset = new FarPoint.Win.Spread.ConditionalFormattingIconSetIndex(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.ThreeStars, 0);
    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, iconset));
    FarPoint.Win.Spread.ConditionalFormatting IconSetCF = new FarPoint.Win.Spread.ConditionalFormatting(new FarPoint.Win.Spread.Model.CellRange(0, 0, 2, 2), c);
    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 Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
            Dim iconset As New FarPoint.Win.Spread.ConditionalFormattingIconSetIndex(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.ThreeStars, 0)
            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, iconset))
            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