reset Method

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.AverageRule(type, style);
var value; // Type: any
value = instance.reset();

function reset() : any;

This example uses the reset 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");

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);
average.reset();

Reference

AverageRule class