Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / ConditionalFormattingRule Class / Priority Property
Example


In This Topic
    Priority Property (ConditionalFormattingRule)
    In This Topic
    Gets or sets the priority.
    Syntax
    'Declaration
     
    Public Property Priority As Integer
    'Usage
     
    Dim instance As ConditionalFormattingRule
    Dim value As Integer
     
    instance.Priority = value
     
    value = instance.Priority
    public int Priority {get; set;}

    Property Value

    The priority.
    Example
    This example sets the Priority property.
    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)
            {
                FarPoint.Web.Spread.IconSetConditionalFormattingRule rule = new FarPoint.Web.Spread.IconSetConditionalFormattingRule(FarPoint.Web.Spread.ConditionalFormattingIconSetStyle.ThreeFlags);
                FarPoint.Web.Spread.ConditionalFormatting cfRule = new FarPoint.Web.Spread.ConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange(0, 1, 5, 1), rule);
                FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cfRule);
                rule.Priority = 1;
                FarPoint.Web.Spread.IconSetConditionalFormattingRule rule1 = new FarPoint.Web.Spread.IconSetConditionalFormattingRule(FarPoint.Web.Spread.ConditionalFormattingIconSetStyle.FiveRatings);
                FarPoint.Web.Spread.ConditionalFormatting cfRule1 = new FarPoint.Web.Spread.ConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange(0, 1, 6, 1), rule1);
                FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cfRule1);
                rule1.Priority = 2; 
            }
    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
    
    Dim rule As New FarPoint.Web.Spread.IconSetConditionalFormattingRule(FarPoint.Web.Spread.ConditionalFormattingIconSetStyle.ThreeFlags)
    Dim cfRule As New FarPoint.Web.Spread.ConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange(0, 1, 5, 1), rule)
    FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cfRule)
    Rule.Priority = 1
    Dim rule1 = New FarPoint.Web.Spread.IconSetConditionalFormattingRule(FarPoint.Web.Spread.ConditionalFormattingIconSetStyle.FiveRatings)
    Dim cfRule1 = New FarPoint.Web.Spread.ConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange(0, 1, 6, 1), rule1)
    FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cfRule1)
    rule1.Priority = 2
    See Also