Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / AverageRule Class / Create Method
The AverageConditionType average condition type.
The style.
Example


In This Topic
    Create Method (AverageRule)
    In This Topic
    Creates an average rule with the specified average condition and style information.
    Syntax
    'Declaration
     
    Public Shared Function Create( _
       ByVal op As AverageConditionType, _
       ByVal style As StyleInfo _
    ) As AverageRule
    'Usage
     
    Dim op As AverageConditionType
    Dim style As StyleInfo
    Dim value As AverageRule
     
    value = AverageRule.Create(op, style)
    public static AverageRule Create( 
       AverageConditionType op,
       StyleInfo style
    )

    Parameters

    op
    The AverageConditionType average condition type.
    style
    The style.

    Return Value

    The new average rule.
    Example
    This example uses the average 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.AverageRule.Create(GrapeCity.Windows.SpreadSheet.Data.AverageConditionType.Above, 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);
    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.AverageRule.Create(GrapeCity.Windows.SpreadSheet.Data.AverageConditionType.Above, 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)
    See Also