Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / IconSetConditionalFormattingRule Class / IconRuleSet Property
Example


In This Topic
    IconRuleSet Property
    In This Topic
    Gets the icons.
    Syntax
    'Declaration
     
    Public ReadOnly Property IconRuleSet As ConditionalFormattingIconRuleSet
    'Usage
     
    Dim instance As IconSetConditionalFormattingRule
    Dim value As ConditionalFormattingIconRuleSet
     
    value = instance.IconRuleSet
    public ConditionalFormattingIconRuleSet IconRuleSet {get;}
    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, new FarPoint.Win.Spread.ConditionalFormattingIconSetIndex(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.FiveQuarters, 0)));
                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(sender As Object, e As 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, New FarPoint.Win.Spread.ConditionalFormattingIconSetIndex(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.FiveQuarters, 0)))
            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
    See Also