SpreadJS Documentation
clearRule Method
Removes all rules.
Syntax
var instance = new GcSpread.Sheets.ConditionalFormats(worksheet);
var value; // Type: any
value = instance.clearRule();
function clearRule() : any;
Example
This example uses the clearRule method.
activeSheet.setValue(0,0, 1,3);
activeSheet.setValue(1,0, 50,3);
activeSheet.setValue(2,0, 100,3);
activeSheet.getConditionalFormats().add2ScaleRule(1, 10, "red", 2, 100, "yellow", [new GcSpread.Sheets.Range(0, 0, 10, 3)]);
// Remove comment in front of method to test
//activeSheet.getConditionalFormats().clearRule();
See Also

Reference

ConditionalFormats type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.