SpreadJS Documentation
compareType Field
The number comparison type.
Syntax
var instance = new GcSpread.Sheets.TextLengthCondition(compareType, expected, formula);
var value; // Type: GeneralCompareType
value = instance.compareType;
var compareType : GeneralCompareType;
Example
This example creates a text length condition.
var textLengthCondition = new GcSpread.Sheets.TextLengthCondition();
textLengthCondition.compareType = GcSpread.Sheets.GeneralCompareType.GreaterThan;
textLengthCondition.expected = 5;
var validator = new GcSpread.Sheets.DefaultDataValidator(textLengthCondition)
activeSheet.getCell(0, 0, GcSpread.Sheets.SheetArea.viewport).dataValidator(validator);
spread.highlightInvalidData(true);
activeSheet.setValue(0, 0, "abcf");
See Also

Reference

TextLengthCondition type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.