FormulaRule Constructor

SpreadJS Documentation

Collapse All

GcSpread.Sheets Namespace > FormulaRule class : FormulaRule Constructor

The formula.

The cell style.

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( 
   formula : string,
   style : Style
) : FormulaRule;

Parameters

formula: The formula.
style: The cell style.

Example

This example creates a 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) ];
activeSheet.getConditionalFormats().addRule(rule);
activeSheet.setValue(0, 0, 2,3);
activeSheet.setValue(0, 1, 1,3);
activeSheet.setValue(0, 2,1,3);
activeSheet.setValue(1, 0, 1,3);

Reference

FormulaRule class

Send comments on this topic.