FormulaRule class

Represents a formula rule with the specified formula and style.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.FormulaRule(formula, style);

function FormulaRule;

Example

This example creates a formula rule.

Javascript

var style = new GcSpread.Sheets.Style();
style.backColor = "red";
var rule =new GcSpread.Sheets.FormulaRule("=A1=B1+C1", style);
rule.ranges = [new GcSpread.Sheets.Range(0, 0, 5, 1) ];
sheet.getConditionalFormats().addRule(rule);
sheet.setValue(0, 0, 2, 3);
sheet.setValue(0, 1, 1, 3);
sheet.setValue(0, 2, 1, 3);
sheet.setValue(1, 0, 1, 3);

Inheritance Hierarchy

Object
GcSpread.Sheets.ConditionRuleBase
GcSpread.Sheets.FormulaRule

Constructors

	Name	Description
	FormulaRule Constructor	Represents a formula rule with the specified formula and style.

Top

Fields

	Name	Description
	formula	Gets the comparison formula of the text rule.
	ranges	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	style	(Inherited from GcSpread.Sheets.ConditionRuleBase)

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