addAverageRule Method

Adds an average rule to the rule collection.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.ConditionalFormats(worksheet);
var value; // Type: object
value = instance.addAverageRule(type, style, ranges);

function addAverageRule( 
   type : AverageConditionType,
   style : Style,
   ranges : Array
) : object;

Parameters

type: The 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 whose item type is GcSpread.Sheets.Range.

Return Value

The average rule added to the rule collection.

Example

This example uses the addAverageRule method.

Javascript

activeSheet.setValue(0,0, 1,3);
activeSheet.setValue(1,0, 50,3);
activeSheet.setValue(2,0, 100,3);
activeSheet.setValue(3,0, 2,3);
activeSheet.setValue(4,0, 60,3);
activeSheet.setValue(5,0, 90,3);
activeSheet.setValue(6,0, 3,3);
activeSheet.setValue(7,0, 40,3);
activeSheet.setValue(8,0, 70,3);
activeSheet.setValue(9,0, 5,3);
activeSheet.setValue(10,0, 35,3);
 var style = new GcSpread.Sheets.Style();
style.backColor = "red";
style.borderLeft =new GcSpread.Sheets.LineBorder("blue");
style.borderTop = new GcSpread.Sheets.LineBorder("blue");
style.borderRight = new GcSpread.Sheets.LineBorder("blue");
style.borderBottom = new GcSpread.Sheets.LineBorder("blue");
activeSheet.getConditionalFormats().addAverageRule( GcSpread.Sheets.AverageConditionType.Above,style,[new GcSpread.Sheets.Range(0, 0, 10, 3)]);

Reference

ConditionalFormats type