Spread Silverlight Documentation
Operator Property (AverageRule)
Example 


Gets the comparison operator for the text rule.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property Operator As AverageConditionType
'Usage
 
Dim instance As AverageRule
Dim value As AverageConditionType
 
instance.Operator = value
 
value = instance.Operator
[System.ComponentModel.DefaultValue()]
public AverageConditionType 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].Cells[0, 0].Value = 1;
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 10;
gcSpreadSheet1.Sheets[0].Cells[2, 0].Value = 6;
gcSpreadSheet1.Sheets[0].Cells[3, 0].Value = -3;
var style2 = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
style2.Background = new SolidColorBrush(Colors.Yellow);

GrapeCity.Windows.SpreadSheet.Data.AverageRule test = new GrapeCity.Windows.SpreadSheet.Data.AverageRule();
test.Style = style2;
test.Operator = GrapeCity.Windows.SpreadSheet.Data.AverageConditionType.EqualOrAbove;
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).Cells(0, 0).Value = 1
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 10
GcSpreadSheet1.Sheets(0).Cells(2, 0).Value = 6
GcSpreadSheet1.Sheets(0).Cells(3, 0).Value = -3
Dim style2 As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
style2.Background = New SolidColorBrush(Colors.Yellow)

Dim test As New GrapeCity.Windows.SpreadSheet.Data.AverageRule()
test.Style = style2
test.Operator = GrapeCity.Windows.SpreadSheet.Data.AverageConditionType.EqualOrAbove
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

AverageRule Class
AverageRule Members

 

 


Copyright © GrapeCity, inc. All rights reserved.