SpreadJS Documentation
AverageRule Constructor
The expected average rule type.
The cell style.
Represents an average conditional rule.
Syntax
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.
Example
This example creates an average rule.
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);
See Also

Reference

AverageRule class

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.