SpreadJS Documentation
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 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.
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);
See Also

Reference

ConditionalFormats type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.