Spread WPF Documentation
Create Method (CellValueRule)
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > CellValueRule Class : Create Method
The comparison operator ComparisonOperator for the text rule.
The first object.
The second object.
The style that is set by the rule.
Creates a cell value data rule with specified parameters.
Syntax
'Declaration
 
Public Shared Function Create( _
   ByVal op As ComparisonOperator, _
   ByVal value1 As System.Object, _
   ByVal value2 As System.Object, _
   ByVal style As StyleInfo _
) As CellValueRule
'Usage
 
Dim op As ComparisonOperator
Dim value1 As System.Object
Dim value2 As System.Object
Dim style As StyleInfo
Dim value As CellValueRule
 
value = CellValueRule.Create(op, value1, value2, style)
public static CellValueRule Create( 
   ComparisonOperator op,
   System.object value1,
   System.object value2,
   StyleInfo style
)

Parameters

op
The comparison operator ComparisonOperator for the text rule.
value1
The first object.
value2
The second object.
style
The style that is set by the rule.

Return Value

The new cell value rule.
Example
This example compares values with the cell value rule.
var style = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
style.Background = new SolidColorBrush(Colors.Blue);
style.BorderLeft = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red);
style.BorderTop = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red);
style.BorderRight = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red);
style.BorderBottom = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red);
var style1 = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
style1.Background = new SolidColorBrush(Colors.Green);
var style2 = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
style2.Background = new SolidColorBrush(Colors.Yellow);

var rule = GrapeCity.Windows.SpreadSheet.Data.CellValueRule.Create(GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.Between, 2, 100, style);           
rule.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(rule);

gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 1;
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 45;
gcSpreadSheet1.Invalidate();
Dim style As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
style.Background = New SolidColorBrush(Colors.Blue)
style.BorderLeft = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red)
style.BorderTop = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red)
style.BorderRight = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red)
style.BorderBottom = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Colors.Red)
Dim style1 As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
style1.Background = New SolidColorBrush(Colors.Green)
Dim style2 As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
style2.Background = New SolidColorBrush(Colors.Yellow)

Dim s As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
Dim rule = GrapeCity.Windows.SpreadSheet.Data.CellValueRule.Create(GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.Between, 2, 100, style)

rule.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(rule)
GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 1
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 45
GcSpreadSheet1.Invalidate()
GcSpreadSheet1.Invalidate()
See Also

Reference

CellValueRule Class
CellValueRule Members