SpreadJS 13
SpreadJS Documentation / Developer's Guide / Features / Manage Data Visualization and Objects / Conditional Formatting / Date Occurring Rule
In This Topic
    Date Occurring Rule
    In This Topic

    The date occurring rule compares dates.

    Using Code

    This example creates a date occurring rule.

    JavaScript
    Copy Code
    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)));
    // OR
    var style = new GC.Spread.Sheets.Style();
    style.backColor = "red";
    activeSheet.conditionalFormats.addDateOccurringRule(GC.Spread.Sheets.ConditionalFormatting.DateOccurringType.NextWeek, style, [new GC.Spread.Sheets.Range(0,0,10,1)]);
    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)));
    
    See Also