AverageRule Constructor

Represents an average conditional rule.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.AverageRule(type, style);

function AverageRule( 
   type : AverageConditionType,
   style : Style
) : AverageRule;

Parameters

type: The expected average rule type.
style: The cell style.

This example creates an average rule.

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");

var cfs = activeSheet.getConditionalFormats();
var average = new GcSpread.Sheets.AverageRule();
average.style = style;
average.type = GcSpread.Sheets.AverageConditionType.Above;
average.ranges = [new GcSpread.Sheets.Range(0, 0, 10, 3)];
cfs.addRule(average);

Reference

AverageRule class

Send comments on this topic.