SpreadJS Documentation
DateOccurringType Enumeration
GC.Spread.Sheets.ConditionalFormatting Namespace : DateOccurringType Enumeration
Specifies the date occurring type.
Members
MemberDescription
last7DaysSpecifies the last seven days.
lastMonthSpecifies last month.
lastQuarterSpecifies last Quarter.
lastWeekSpecifies last week.
lastYearSpecifies last Year.
nextMonthSpecifies next month.
nextQuarterSpecifies next Quarter.
nextWeekSpecifies next week.
nextYearSpecifies next Year.
thisMonthSpecifies this month.
thisQuarterSpecifies this Quarter.
thisWeekSpecifies this week.
thisYearSpecifies this Year.
todaySpecifies today.
tomorrowSpecifies tomorrow.
yesterdaySpecifies yesterday.
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)));
Inheritance Hierarchy

Object
   GC.Spread.Sheets.ConditionalFormatting.DateOccurringType

See Also

Reference

GC.Spread.Sheets.ConditionalFormatting Namespace