DateExCondition Constructor

SpreadJS Documentation

Collapse All

GcSpread.Sheets Namespace > DateExCondition type : DateExCondition Constructor

The rule type.

The cell style.

Represents a date condition with the specified comparison type, expected date condition, and formula.

Syntax

Javascript (Usage)
Javascript (Specification)

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

function DateExCondition( 
   type : DateOccurringType,
   style : Style
) : DateExCondition;

Parameters

type: The rule type.
style: The cell style.

Example

This example creates a date condition.

Javascript

var nCondition = new GcSpread.Sheets.DateExCondition();
nCondition.formula = "$C$1";
var validator = new GcSpread.Sheets.DefaultDataValidator(nCondition)
activeSheet.getCell(0, 0, GcSpread.Sheets.SheetArea.viewport).dataValidator(validator);
spread.highlightInvalidData(true);
activeSheet.setValue(0, 0, new Date(2012, 12, 12));
activeSheet.setValue(0, 2, new Date(2012, 11, 31));

Reference

DateExCondition type

Send comments on this topic.