Spread WPF Documentation
AddAverageRule Method
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > ConditionalFormat Class : AddAverageRule Method
The AverageConditionType average condition type.
The style that is applied to the cell when the condition is met.
The cell ranges where the rule is applied.
Adds an average rule to the rule collection.
Syntax
'Declaration
 
Public Function AddAverageRule( _
   ByVal type As AverageConditionType, _
   ByVal style As StyleInfo, _
   ByVal ParamArray ranges() As CellRange _
) As AverageRule
'Usage
 
Dim instance As ConditionalFormat
Dim type As AverageConditionType
Dim style As StyleInfo
Dim ranges() As CellRange
Dim value As AverageRule
 
value = instance.AddAverageRule(type, style, ranges)
public AverageRule AddAverageRule( 
   AverageConditionType type,
   StyleInfo style,
   params CellRange[] ranges
)

Parameters

type
The AverageConditionType average condition type.
style
The style that is applied to the cell when the condition is met.
ranges
The cell ranges where the rule is applied.

Return Value

Returns the new average rule.
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);

GcSpreadSheet1.Sheets[0].ConditionalFormats.AddAverageRule(GrapeCity.Windows.SpreadSheet.Data.AverageConditionType.EqualOrAbove, 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.AddAverageRule(GrapeCity.Windows.SpreadSheet.Data.AverageConditionType.EqualOrAbove, style2, new GrapeCity.Windows.SpreadSheet.Data.CellRange() { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) })
See Also

Reference

ConditionalFormat Class
ConditionalFormat Members