Spread for ASP.NET 7.0 Product Documentation
Priority Property
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > ConditionalFormattingRule Class : Priority Property


Glossary Item Box

Gets or sets the priority.

Syntax

Visual Basic (Declaration) 
Public Property Priority As Integer
Visual Basic (Usage)Copy Code
Dim instance As ConditionalFormattingRule
Dim value As Integer
 
instance.Priority = value
 
value = instance.Priority
C# 
public int Priority {get; set;}

Property Value

The priority.

Example

This example sets the Priority property.
C#Copy Code
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; 
        }
VB.NETCopy Code
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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.