SpreadJS Documentation
compareType Field
Gets or sets the type of the compare.
Syntax
var instance = new GcSpread.Sheets.DateCondition(compareType, expected, formula);
var value; // Type: DateCompareType
value = instance.compareType;
var compareType : DateCompareType;
Example
This example creates a date condition.
var nCondition = new GcSpread.Sheets.DateCondition();
nCondition.compareType = GcSpread.Sheets.DateCompareType.Before;
nCondition.expected = new Date(2012, 11, 31);
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));
See Also

Reference

DateCondition type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.