Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.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 adds an icon for a specific value in the filter.
    protected void Page_Load(object sender, System.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;
                           }
    
    protected void Button1_Click(object sender, EventArgs e)
            {
                //IconSetConditionalFormatting
                FarPoint.Web.Spread.IconSetConditionalFormattingRule c = new FarPoint.Web.Spread.IconSetConditionalFormattingRule(FarPoint.Web.Spread.ConditionalFormattingIconSetStyle.ThreeTriangles);
                c.IconRuleSet.Add(new FarPoint.Web.Spread.ConditionalFormattingIconValue(10, FarPoint.Web.Spread.ConditionalFormattingValueType.Number, true, FarPoint.Web.Spread.ConditionalFormattingIcon.BlackCircle));
                FarPoint.Web.Spread.ConditionalFormatting IconSetCF = new FarPoint.Web.Spread.ConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2), c);                          
                //FpSpread1.Sheets[0].SetConditionalFormatting(1,1,c);
                FpSpread1.Sheets[0].ConditionalFormatting.Add(IconSetCF);
            }
    Private Sub Page_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
    
    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
                 'IconSetConditionalFormatting
                Dim c As New FarPoint.Web.Spread.IconSetConditionalFormattingRule(FarPoint.Web.Spread.ConditionalFormattingIconSetStyle.ThreeTriangles)
                c.IconRuleSet.Add(New FarPoint.Web.Spread.ConditionalFormattingIconValue(10, FarPoint.Web.Spread.ConditionalFormattingValueType.Number, True, FarPoint.Web.Spread.ConditionalFormattingIcon.BlackCircle))
                Dim IconSetCF As New FarPoint.Web.Spread.ConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange(0, 0, 2, 2), c)
                'FpSpread1.Sheets(0).SetConditionalFormatting(1, 1, c)
                FpSpread1.Sheets(0).ConditionalFormatting.Add(IconSetCF)
            End Sub
    See Also