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


In This Topic
    AverageRule Constructor
    In This Topic
    Constructs an average rule.
    Syntax
    'Declaration
     
    Public Function New()
    'Usage
     
    Dim instance As New AverageRule()
    public AverageRule()
    Example
    This example creates an average 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);
    
    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