SpreadJS Documentation
reset Method
Resets the rule.
Syntax
var instance = new GcSpread.Sheets.DateOccurringRule(type, style);
var value; // Type: any
value = instance.reset();
function reset() : any;
Example
This example resets the rule.
<input type="button" id="button1" value="button1"/>

var style = new GcSpread.Sheets.Style();
style.backColor = "red";
var rule = new GcSpread.Sheets.DateOccurringRule(GcSpread.Sheets.DateOccurringType.NextWeek,style);
rule.ranges=[new GcSpread.Sheets.Range(0,0,10,1)];
activeSheet.getConditionalFormats().addRule(rule);

var d = new Date();
activeSheet.setValue(0, 0, d);
activeSheet.setValue(1, 0, new Date(d.setDate(d.getDate()+1)));
activeSheet.setValue(2, 0, new Date(d.setDate(d.getDate()+5)));
activeSheet.setValue(3, 0,new Date(d.setDate(d.getDate()+6)));
activeSheet.setValue(4, 0,new Date(d.setDate(d.getDate()+7)));
activeSheet.setValue(5, 0, new Date(d.setDate(d.getDate()+8)));

$("#button1").click(function () {
activeSheet.isPaintSuspended(true);
rule.reset();
activeSheet.isPaintSuspended(false);
    });
See Also

Reference

DateOccurringRule class

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.