SpreadJS 13
GC.Spread.Sheets.DataValidation Namespace / DefaultDataValidator type
In This Topic
    DefaultDataValidator type
    In This Topic
    Represents a data validator.
    Syntax
    var instance = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(condition);
    function DefaultDataValidator;
    Example
    //This example validates the cell data.
    spread.options.highlightInvalidData = true;
    var dv = new GC.Spread.Sheets.DataValidation.createTextLengthValidator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.greaterThan, 5);
    activeSheet.setDataValidator(0, 0, 1, 1, dv, GC.Spread.Sheets.SheetArea.viewport);
    activeSheet.setValue(0, 0, "abcf");
    Inheritance Hierarchy

    Object
       GC.Spread.Sheets.DataValidation.DefaultDataValidator

    Constructors
     NameDescription
    public ConstructorRepresents a data validator.  
    Top
    Methods
     NameDescription
    public MethodGets or sets the comparison operator.  
    public MethodGets or sets the condition to validate.  
    public MethodGets or sets the error message.  
    public MethodGets or sets the error style to display.  
    public MethodGets or sets the error title.  
    public MethodReturns the valid data lists if the Data validation type is list; otherwise, returns null.  
    public MethodGet or Sets the invalid data cell highlight style.  
    public MethodGets or sets whether to ignore an empty value.  
    public MethodGets or sets whether to display a drop-down button.  
    public MethodGets or sets the input message.  
    public MethodGets or sets the input title.  
    public MethodDetermines whether the current value is valid.  
    public MethodResets the data validator.  
    public MethodGets or sets whether to display an error message.  
    public MethodGets or sets whether to display the input title and input message.  
    public MethodGets or sets the criteria type of this data validator.  
    public MethodGets the first value of the data validation.  
    public MethodGets the second value of the data validation.  
    Top
    See Also