SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / DateCompareType Enumeration
In This Topic
    DateCompareType Enumeration
    In This Topic
    Specifies the date compare type.
    Members
    MemberDescription
    afterIndicates whether the date time is after a certain time.
    afterEqualsToIndicates whether the date time is after or equal to a certain time.
    beforeIndicates whether the date time is before a certain time.
    beforeEqualsToIndicates whether the date time is before or equal to a certain time.
    equalsToIndicates whether the date time is equal to a certain time.
    notEqualsToIndicates whether the date time is not equal to a certain time.
    Example
    This example validates cell data.
    var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.dateCondition, {compareType: GC.Spread.Sheets.ConditionalFormatting.DateCompareType.before, expected: new Date(2012, 11, 31)});
    var validator = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(nCondition);
    validator.type(GC.Spread.Sheets.DataValidation.CriteriaType.custom);
    activeSheet.getCell(0, 0, GC.Spread.Sheets.SheetArea.viewport).validator(validator);
    spread.options.highlightInvalidData = true;
    activeSheet.setValue(0, 0, new Date(2012, 12, 12));
    Inheritance Hierarchy

    Object
       GC.Spread.Sheets.ConditionalFormatting.DateCompareType

    See Also