Top10Rule class

Represents a top 10 condition rule.

Syntax

Javascript (Usage)
Javascript (Specification)

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

function Top10Rule;

Example

This example creates a rule.

Javascript

var style = new GcSpread.Sheets.Style();
style.backColor = "red";
var rule = new GcSpread.Sheets.Top10Rule(GcSpread.Sheets.Top10ConditionType.Top,2,style);
rule.ranges=[new GcSpread.Sheets.Range(0,0,10,1)];
sheet.getConditionalFormats().addRule(rule);
sheet.setValue(0, 0, 1);
sheet.setValue(1, 0, 50);
sheet.setValue(2, 0, 11);
sheet.setValue(3, 0, 5);

Inheritance Hierarchy

Object
GcSpread.Sheets.ConditionRuleBase
GcSpread.Sheets.Top10Rule

Constructors

	Name	Description
	Top10Rule Constructor	Represents a top 10 condition rule.

Top

Fields

	Name	Description
	ranges	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	rank	Gets the rank of the Top10Rule.
	style	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	type	The comparison operator for the text rule.

Top

Methods

	Name	Description
	contains	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	evaluate	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	getExpected	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	intersects	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	priority	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	reset	Resets this instance.
	stopIfTrue	(Inherited from GcSpread.Sheets.ConditionRuleBase)

Top

Reference

GcSpread.Sheets Namespace
Using the Top 10 Rule