CellValueRule class

Represents a cell value conditional rule.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.CellValueRule(operator, value1, value2, style);

function CellValueRule;

Example

This example creates a cell value rule.

Javascript

var style = new GcSpread.Sheets.Style();
style.backColor = "red";
var rule = new GcSpread.Sheets.CellValueRule(GcSpread.Sheets.ComparisonOperator.Between,2,100,style);
rule.ranges=[new GcSpread.Sheets.Range(0,0,5,1)];
sheet.getConditionalFormats().addRule(rule);
sheet.setValue(0,0,1,3);
sheet.setValue(1,0,45,3);

Inheritance Hierarchy

Object
GcSpread.Sheets.ConditionRuleBase
GcSpread.Sheets.CellValueRule

Constructors

	Name	Description
	CellValueRule Constructor	Represents a cell value conditional rule.

Top

Fields

	Name	Description
	operator	The comparison operator for the rule.
	ranges	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	style	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	value1	The value of the first object.
	value2	The value of the second object.

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 the rule.
	stopIfTrue	(Inherited from GcSpread.Sheets.ConditionRuleBase)

Top

Reference

GcSpread.Sheets Namespace
Using the Cell Value Rule