TwoScaleRule class

Represents a two-color conditional scale rule with the specified parameters.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.TwoScaleRule(minType, minValue, minColor, maxType, maxValue, maxColor);

function TwoScaleRule;

Example

This example creates a rule.

Javascript

var style = new GcSpread.Sheets.Style();
style.backColor = "red";
var rule = new GcSpread.Sheets.TwoScaleRule(GcSpread.Sheets.ScaleValueType.Number,1,"Yellow",GcSpread.Sheets.ScaleValueType.Number,50,"Blue");
rule.ranges=[new GcSpread.Sheets.Range(0,0,20,1)];
sheet.getConditionalFormats().addRule(rule);
sheet.setValue(0,0,1,3);
sheet.setValue(1,0,45,3);

Inheritance Hierarchy

Object
GcSpread.Sheets.ScaleRule
GcSpread.Sheets.TwoScaleRule

Constructors

	Name	Description
	TwoScaleRule Constructor	Represents a two-color conditional scale rule with the specified parameters.

Top

Fields

	Name	Description
	ranges	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	style	(Inherited from GcSpread.Sheets.ConditionRuleBase)

Top

Methods

	Name	Description
	contains	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	evaluate	Returns a specified value of the rule if the cell satisfies the condition.
	getExpected	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	getMaximumColor	Gets the maximum color scale.
	getMaximumType	Gets the maximum scale type.
	getMaximumValue	Gets the maximum scale value.
	getMinimumColor	Gets the minimum scale color.
	getMinimumType	Gets the type of minimum scale.
	getMinimumValue	Gets the minimum scale value.
	intersects	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	priority	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	reset	Resets the rule.
	setMaximumColor	Sets the maximum color scale.
	setMaximumType	Sets the maximum scale type.
	setMaximumValue	Sets the maximum scale value.
	setMinimumColor	Sets the minimum scale color.
	setMinimumType	Sets the type of minimum scale.
	setMinimumValue	Sets the minimum scale value.
	stopIfTrue	(Inherited from GcSpread.Sheets.ScaleRule)

Top

Reference

GcSpread.Sheets Namespace
Using the Scale Rule