SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / DateOccurringType Enumeration
In This Topic
    DateOccurringType Enumeration
    In This Topic
    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