Spread WPF Documentation
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.
Example


In This Topic
    Create Method (CellValueRule)
    In This Topic
    Creates a cell value data rule with specified parameters.
    Syntax
    'Declaration
     
    Public Shared Function Create( _
       ByVal op As ComparisonOperator, _
       ByVal value1 As Object, _
       ByVal value2 As Object, _
       ByVal style As StyleInfo _
    ) As CellValueRule
    'Usage
     
    Dim op As ComparisonOperator
    Dim value1 As Object
    Dim value2 As Object
    Dim style As StyleInfo
    Dim value As CellValueRule
     
    value = CellValueRule.Create(op, value1, value2, style)
    public static CellValueRule Create( 
       ComparisonOperator op,
       object value1,
       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