Spread WPF 14
GrapeCity.Windows.SpreadSheet.Data Namespace / AverageRule Class / Operator Property
Example


In This Topic
    Operator Property (AverageRule)
    In This Topic
    Gets the comparison operator for the text rule.
    Syntax
    'Declaration
     
    <DefaultValueAttribute(Mono.Cecil.CustomAttributeArgument)>
    Public Property Operator As AverageConditionType
    'Usage
     
    Dim instance As AverageRule
    Dim value As AverageConditionType
     
    instance.Operator = value
     
    value = instance.Operator
    [DefaultValue(Mono.Cecil.CustomAttributeArgument)]
    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)
    See Also