Spread for ASP.NET 8.0 Product Documentation
Priority Property (ConditionalFormattingRule)
Example 


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
Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

ConditionalFormattingRule Class
ConditionalFormattingRule Members

 

 


Copyright © GrapeCity, inc. All rights reserved.