Spread.Sheets Documentation
removeRuleByRange Method
GC.Spread.Sheets.ConditionalFormatting Namespace > ConditionalFormats type : removeRuleByRange Method
The row index of the first cell in the range.
The column index of the first cell in the range.
The number of rows in the range.
The number of columns in the range.
Removes the rules from a specified cell range.
Syntax
var instance = new GC.Spread.Sheets.ConditionalFormatting.ConditionalFormats(worksheet);
var value; // Type: any
value = instance.removeRuleByRange(row, column, rowCount, columnCount);
function removeRuleByRange( 
   row : number,
   column : number,
   rowCount : number,
   columnCount : number
) : any;

Parameters

row
The row index of the first cell in the range.
column
The column index of the first cell in the range.
rowCount
The number of rows in the range.
columnCount
The number of columns in the range.
Example
This example uses the removeRuleByRange method.
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);
activeSheet.conditionalFormats.removeRuleByRange(0, 0, 5, 1);
See Also

Reference

ConditionalFormats type