SpreadJS Documentation
removeRule Method
The rule object to remove from the ConditionalFormats object.
Removes a rule object from the ConditionalFormats object.
Syntax
var instance = new GcSpread.Sheets.ConditionalFormats(worksheet);
var value; // Type: any
value = instance.removeRule(rule);
function removeRule( 
   rule : object
) : any;

Parameters

rule
The rule object to remove from the ConditionalFormats object.
Example
This example uses the removeRule 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().removeRule(rule);
See Also

Reference

ConditionalFormats type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.