SpreadJS 14
Features / Conditional Formatting / Formula Rule
In This Topic
    Formula Rule
    In This Topic

    The formula rule allows you to use formulas when checking the condition.

    Using Code

    This example creates a formula rule.

    JavaScript
    Copy Code
    var style = new GC.Spread.Sheets.Style();
    style.backColor = "red";
    var ranges = [new GC.Spread.Sheets.Range(0, 0, 2, 1)];
    activeSheet.conditionalFormats.addFormulaRule("=A1=B1+C1", style, ranges);
    activeSheet.setValue(0, 0, 2,3);
    activeSheet.setValue(0, 1, 1,3);
    activeSheet.setValue(0, 2,1,3);
    activeSheet.setValue(1, 0, 1,3);
    // OR
    var style = new GC.Spread.Sheets.Style();
    style.backColor = "red";
    var rule = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
    rule.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.FormulaRule);
    rule.formula("=A1=B1+C1");
    rule.ranges([new GC.Spread.Sheets.Range(0, 0, 2, 1)]);
    rule.style(style);
    activeSheet.conditionalFormats.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);
    
    See Also