DateOccurringRule class

Represents a DateOccurringRule with the specified type and style.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.DateOccurringRule(type, style);

function DateOccurringRule;

Example

This example creates a date occurring rule.

Javascript

var style = new GcSpread.Sheets.Style();
style.backColor = "red";
var rule = new GcSpread.Sheets.DateOccurringRule(GcSpread.Sheets.DateOccurringType.NextWeek,style);
rule.ranges=[new GcSpread.Sheets.Range(0,0,10,1)];
sheet.getConditionalFormats().addRule(rule);
var d = new Date();
sheet.setValue(0, 0, d);
sheet.setValue(1, 0, new Date(d.setDate(d.getDate()+1)));
sheet.setValue(2, 0, new Date(d.setDate(d.getDate()+5)));
sheet.setValue(3, 0,new Date(d.setDate(d.getDate()+6)));
sheet.setValue(4, 0,new Date(d.setDate(d.getDate()+7)));
sheet.setValue(5, 0, new Date(d.setDate(d.getDate()+8)));

Inheritance Hierarchy

Object
GcSpread.Sheets.ConditionRuleBase
GcSpread.Sheets.DateOccurringRule

Constructors

	Name	Description
	DateOccurringRule Constructor	Represents a DateOccurringRule with the specified type and style.

Top

Fields

	Name	Description
	ranges	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	style	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	type	The rule type.

Top

Methods

	Name	Description
	contains	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	evaluate	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	getExpected	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	intersects	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	priority	(Inherited from GcSpread.Sheets.ConditionRuleBase)
	reset	Resets the rule.
	stopIfTrue	(Inherited from GcSpread.Sheets.ConditionRuleBase)

Top

Reference

GcSpread.Sheets Namespace
Using the Date Occurring Rule