Using the Date Occurring Rule

The date occurring rule compares dates.

Using Code

This example creates a date occurring rule.

JavaScript	Copy Code
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)));

JavaScript

Copy Code

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)));