Spread Silverlight Documentation
Operator Property (Top10Rule)
Example 


Gets the comparison operator for the text rule.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property Operator As Top10ConditionType
'Usage
 
Dim instance As Top10Rule
Dim value As Top10ConditionType
 
instance.Operator = value
 
value = instance.Operator
[System.ComponentModel.DefaultValue()]
public Top10ConditionType Operator {get; set;}

Property Value

The comparison operator for the text rule. The default value is Containing.
Example
This example sets the Operator 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.