SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / ConditionalFormats type / containsRule Method
The rule for which to check.
The row index.
The column index.
In This Topic
    containsRule Method
    In This Topic
    Determines whether the specified cell contains a specified rule.
    Syntax
    var instance = new GC.Spread.Sheets.ConditionalFormatting.ConditionalFormats(worksheet);
    var value; // Type: boolean
    value = instance.containsRule(rule, row, column);
    function containsRule( 
       rule : ConditionRuleBase,
       row : number,
       column : number
    ) : boolean;

    Parameters

    rule
    The rule for which to check.
    row
    The row index.
    column
    The column index.

    Return Value

    true if the specified cell contains a specified rule; otherwise, false.
    Example
    This example checks to see if a cell has a specified rule.
    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.cellValueRule);
    rule.ranges([new GC.Spread.Sheets.Range(0,0,5,1)]);
    rule.operator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.between);
    rule.style(style);
    rule.value1(2);
    rule.value2(100);
    activeSheet.conditionalFormats.addRule(rule);
    activeSheet.setValue(0,0,1,3);
    activeSheet.setValue(1,0,45,3);
    var ruletest = activeSheet.conditionalFormats.containsRule(rule, 0, 0);
    alert(ruletest);
    See Also