DateOccurringType Enumeration

Specifies the date occurring type.

Members

Member	Description
last7Days	Specifies the last seven days.
lastMonth	Specifies last month.
lastWeek	Specifies last week.
nextMonth	Specifies next month.
nextWeek	Specifies next week.
thisMonth	Specifies this month.
thisWeek	Specifies this week.
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