DateOccurringType Enumeration

Specifies the date occurring type.

Members

Member	Description
last7Days	Specifies the last seven days.
lastMonth	Specifies last month.
lastQuarter	Specifies last Quarter.
lastWeek	Specifies last week.
lastYear	Specifies last Year.
nextMonth	Specifies next month.
nextQuarter	Specifies next Quarter.
nextWeek	Specifies next week.
nextYear	Specifies next Year.
thisMonth	Specifies this month.
thisQuarter	Specifies this Quarter.
thisWeek	Specifies this week.
thisYear	Specifies this Year.
today	Specifies today.
tomorrow	Specifies tomorrow.
yesterday	Specifies yesterday.

Example

This example creates a rule.

Javascript

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

Reference

GC.Spread.Sheets.ConditionalFormatting Namespace