Spread.Sheets Documentation
containsRule Method
GC.Spread.Sheets.ConditionalFormatting Namespace > ConditionalFormats type : containsRule Method
The rule for which to check.
The row index.
The column index.
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 : object,
   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

Reference

ConditionalFormats type