Rank Property (TopRankedValuesConditionalFormattingRule)

Visual Basic
C#

'Declaration
 
Public Property Rank As Integer

'Usage
 
Dim instance As TopRankedValuesConditionalFormattingRule
Dim value As Integer
 
instance.Rank = value
 
value = instance.Rank

public int Rank {get; set;}

Property Value

The rank.

This example sets the Rank property.

C#

if (this.IsPostBack) return;

FpSpread1.Sheets[0].Cells[0, 0].Value = 3;
FpSpread1.Sheets[0].Cells[0, 1].Value = 50;
FpSpread1.Sheets[0].Cells[0, 2].Value = 1;
FpSpread1.Sheets[0].Cells[1, 0].Value = 22;
FpSpread1.Sheets[0].Cells[1, 1].Value = 10;
FpSpread1.Sheets[0].Cells[1, 2].Value = 70;
FpSpread1.Sheets[0].Cells[2, 0].Value = 45;
FpSpread1.Sheets[0].Cells[2, 1].Value = 20;
FpSpread1.Sheets[0].Cells[2, 2].Value = 65;

// TopRank CF
FarPoint.Web.Spread.TopRankedValuesConditionalFormattingRule topRank = new FarPoint.Web.Spread.TopRankedValuesConditionalFormattingRule();
topRank.BackColor = Color.Tomato;
topRank.Rank = 2;
topRank.IsPercent = true;
FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, topRank);

Visual Basic

If (Me.IsPostBack) Then Return
FpSpread1.Sheets(0).Cells(0, 0).Value = 3
FpSpread1.Sheets(0).Cells(0, 1).Value = 50
FpSpread1.Sheets(0).Cells(0, 2).Value = 1
FpSpread1.Sheets(0).Cells(1, 0).Value = 22
FpSpread1.Sheets(0).Cells(1, 1).Value = 10
FpSpread1.Sheets(0).Cells(1, 2).Value = 70
FpSpread1.Sheets(0).Cells(2, 0).Value = 45
FpSpread1.Sheets(0).Cells(2, 1).Value = 20
FpSpread1.Sheets(0).Cells(2, 2).Value = 65

'TopRank CF
Dim topRank As New FarPoint.Web.Spread.TopRankedValuesConditionalFormattingRule()
topRank.BackColor = Drawing.Color.Tomato
topRank.Rank = 2
topRank.IsPercent = True
FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, topRank)

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

TopRankedValuesConditionalFormattingRule Class
TopRankedValuesConditionalFormattingRule Members