ScaleRule class

Represents a scale conditional rule.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.ConditionalFormatting.ScaleRule();

function ScaleRule;

Example

This example creates a rule.

Javascript

activeSheet.conditionalFormats.add2ScaleRule(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number,1,"Yellow",GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number,50,"Blue", [new GC.Spread.Sheets.Range(0,0,20,1)]);
activeSheet.setValue(0,0,1,3);
activeSheet.setValue(1,0,45,3);
activeSheet.setValue(2,0,75,3);

Inheritance Hierarchy

Object
   GC.Spread.Sheets.ConditionalFormatting.ScaleRule
      GC.Spread.Sheets.ConditionalFormatting.DataBarRule
      GC.Spread.Sheets.ConditionalFormatting.IconSetRule

Constructors

	Name	Description
	ScaleRule Constructor	Represents a scale conditional rule.

Top

Methods

	Name	Description
	createCondition	Creates a condition for the rule.
	evaluate	Returns a specified value of the rule if the cell satisfies the condition.
	maxColor	Gets or sets the maximum color scale.
	maxType	Gets or sets the maximum scale type.
	maxValue	Gets or sets the maximum scale value.
	midColor	Gets or sets the midpoint scale color.
	midType	Gets or sets the midpoint scale type.
	midValue	Gets or sets the midpoint scale value.
	minColor	Gets or sets the minimum scale color.
	minType	Gets or sets the type of minimum scale.
	minValue	Gets or sets the minimum scale value.
	stopIfTrue	Gets whether evaluation should stop if the condition evaluates to `true`.

Top

Reference

GC.Spread.Sheets.ConditionalFormatting Namespace
Using the Scale Rule