[]
Sheets.ConditionalFormatting.DateOccurringType
Specifies the date occurring type.
example
//This example creates a rule.
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
var rule = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule(GC.Spread.Sheets.ConditionalFormatting.RuleType.dateOccurringRule, [new GC.Spread.Sheets.Range(0,0,10,1)], style, null, null, null, null, null, GC.Spread.Sheets.ConditionalFormatting.DateOccurringType.nextWeek);
activeSheet.conditionalFormats.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)));
• last7Days = 3
Specifies the last seven days.
• lastMonth = 5
Specifies last month.
• lastQuarter = 12
Specifies last Quarter.
• lastWeek = 8
Specifies last week.
• lastYear = 15
Specifies last Year.
• nextMonth = 6
Specifies next month.
• nextQuarter = 10
Specifies next Quarter.
• nextWeek = 9
Specifies next week.
• nextYear = 13
Specifies next Year.
• thisMonth = 4
Specifies this month.
• thisQuarter = 11
Specifies this Quarter.
• thisWeek = 7
Specifies this week.
• thisYear = 14
Specifies this Year.
• today = 0
Specifies today.
• tomorrow = 2
Specifies tomorrow.
• yesterday = 1
Specifies yesterday.