Top10Rule Constructor

Represents a top 10 condition rule.

Syntax

Javascript (Usage)
Javascript (Specification)

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

function Top10Rule( 
   type : Top10ConditionType,
   rank : number,
   style : Style
) : Top10Rule;

Parameters

type: The comparison operator for the text rule.
rank: Gets the rank of the Top10Rule.
style: The cell style for the rule.

This example creates multiple rules.

Javascript

activeSheet.setArray(0,0,[1,2,3,4,5,6,7,8,9,10]);
var cell = new GcSpread.Sheets.CellValueRule();
cell.operator = 2;
cell.value1 = 5;
cell.ranges = [new GcSpread.Sheets.Range(0, 0, 10, 1)];
cell.style = new GcSpread.Sheets.Style();
cell.style.backColor = "red";
cell.style.foreColor = "black";
activeSheet.getConditionalFormats().addRule(cell);

var top = new GcSpread.Sheets.Top10Rule();
top.type = 0;
top.rank = 3;
top.stopIfTrue(true);
top.ranges = [new GcSpread.Sheets.Range(0, 0, 10, 1)];
top.style = new GcSpread.Sheets.Style();
top.style.foreColor = "red";
activeSheet.getConditionalFormats().addRule(top);

Reference

Top10Rule class

Send comments on this topic.