Spread WPF Documentation
AddCellValueRule Method
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > ConditionalFormat Class : AddCellValueRule Method
The ComparisonOperator comparison operator.
The first value.
The second value.
The style that is set to the cell when the condition is met.
The cell ranges where the rule is applied.
Adds the cell value rule to the rule collection.
Syntax
'Declaration
 
Public Function AddCellValueRule( _
   ByVal comparisonOperator As ComparisonOperator, _
   ByVal value1 As System.Object, _
   ByVal value2 As System.Object, _
   ByVal style As StyleInfo, _
   ByVal ParamArray ranges() As CellRange _
) As CellValueRule
'Usage
 
Dim instance As ConditionalFormat
Dim comparisonOperator As ComparisonOperator
Dim value1 As System.Object
Dim value2 As System.Object
Dim style As StyleInfo
Dim ranges() As CellRange
Dim value As CellValueRule
 
value = instance.AddCellValueRule(comparisonOperator, value1, value2, style, ranges)
public CellValueRule AddCellValueRule( 
   ComparisonOperator comparisonOperator,
   System.object value1,
   System.object value2,
   StyleInfo style,
   params CellRange[] ranges
)

Parameters

comparisonOperator
The ComparisonOperator comparison operator.
value1
The first value.
value2
The second value.
style
The style that is set to the cell when the condition is met.
ranges
The cell ranges where the rule is applied.

Return Value

Returns the new cell value rule.
Example
This example creates a cell value rule.
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);

GcSpreadSheet1.Sheets[0].ConditionalFormats.AddCellValueRule(GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.Between, 1, 8, style2, new GrapeCity.Windows.SpreadSheet.Data.CellRange[] {new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)});
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)

GcSpreadSheet1.Sheets(0).ConditionalFormats.AddCellValueRule(GrapeCity.Windows.SpreadSheet.Data.ComparisonOperator.Between, 1, 8, style2, New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)})
See Also

Reference

ConditionalFormat Class
ConditionalFormat Members