removeRuleByRange Method

Removes the rules from a specified cell range.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.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.

Javascript

var style = new GcSpread.Sheets.Style();
style.backColor = "red";
var rule = new GcSpread.Sheets.CellValueRule(GcSpread.Sheets.ComparisonOperator.Between,2,100,style);
rule.ranges=[new GcSpread.Sheets.Range(0,0,5,1)];
activeSheet.getConditionalFormats().addRule(rule);
activeSheet.setValue(0,0,1,3);
activeSheet.setValue(1,0,45,3);
activeSheet.getConditionalFormats().removeRuleByRange(0, 0, 5, 1);

Reference

ConditionalFormats type