Spread Silverlight Documentation
Rank Property (Top10Rule)
Example 


Gets the rank of the Top10Rule.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property Rank As System.Integer
'Usage
 
Dim instance As Top10Rule
Dim value As System.Integer
 
instance.Rank = value
 
value = instance.Rank
[System.ComponentModel.DefaultValue()]
public System.int Rank {get; set;}

Property Value

The rank of the Top10Rule. The default is 10.
Example
This example sets the Rank property.
gcSpreadSheet1.Sheets[0].SetValue(0, 0, 1);
gcSpreadSheet1.Sheets[0].SetValue(1, 0, 50);
gcSpreadSheet1.Sheets[0].SetValue(2, 0, 11);
gcSpreadSheet1.Sheets[0].SetValue(3, 0, 5);
var style2 = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
style2.Background = new SolidColorBrush(Colors.Yellow);

GrapeCity.Windows.SpreadSheet.Data.Top10Rule test = new GrapeCity.Windows.SpreadSheet.Data.Top10Rule();
test.Style = style2;
test.Operator = GrapeCity.Windows.SpreadSheet.Data.Top10ConditionType.Top;
test.Rank = 2;
test.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(test);    
GcSpreadSheet1.Sheets(0).SetValue(0, 0, 1)
GcSpreadSheet1.Sheets(0).SetValue(1, 0, 50)
GcSpreadSheet1.Sheets(0).SetValue(2, 0, 11)
GcSpreadSheet1.Sheets(0).SetValue(3, 0, 5)
Dim style2 As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
style2.Background = New SolidColorBrush(Colors.Yellow)

Dim test As New GrapeCity.Windows.SpreadSheet.Data.Top10Rule()
test.Style = style2
test.Operator = GrapeCity.Windows.SpreadSheet.Data.Top10ConditionType.Top
test.Rank = 2
test.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(test)
Requirements

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

See Also

Reference

Top10Rule Class
Top10Rule Members

 

 


Copyright © GrapeCity, inc. All rights reserved.