Class $.wijmo.wijspread.FormulaRule
Extends
$.wijmo.wijspread.ConditionRuleBase.
| Constructor Attributes | Constructor Name and Description |
|---|---|
|
$.wijmo.wijspread.FormulaRule(formula, style)
Creates a new formula rule with the specified formula and style.
|
- Fields borrowed from class $.wijmo.wijspread.ConditionRuleBase:
- condition, ranges, style
| Method Attributes | Method Name and Description |
|---|---|
|
Creates conditions for the rule.
|
|
|
Resets the rule.
|
- Methods borrowed from class $.wijmo.wijspread.ConditionRuleBase:
- contains, createCondition, evaluate, getExpected, initCondition, reset
Class Detail
$.wijmo.wijspread.FormulaRule(formula, style)
Creates a new formula rule with the specified formula and style.
var style = new $.wijmo.wijspread.Style();
style.backColor = "red";
var rule =new $.wijmo.wijspread.FormulaRule("=A1=B1+C1", style);
rule.ranges = [new $.wijmo.wijspread.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);
- Parameters:
- formula
- The formula.
- style
- The cell style.
Method Detail
FormulaRule#createCondition()
Creates conditions for the rule.
FormulaRule#reset()
Resets the rule.