SpreadJS Documentation
DataValidationResult Enumeration
Indicates the data validation result.
Members
MemberDescription
DiscardIndicates to discard the value and not apply it to the cell for a validation error.
ForceApplyIndicates to apply the value to a cell for a validation error.
RetryIndicates to retry multiple times to apply the value to the cell for a validation error.
Example
This example shows an error message.
spread.highlightInvalidData(true); 
//The formula validator is valid if the formula condition returns true.
var dv = GcSpread.Sheets.DefaultDataValidator.createFormulaValidator("A1>0");
dv.showInputMessage = true;
dv.inputMessage = "Enter a value greater than 0 in A1.";
dv.inputTitle = "Tip";
dv.showErrorMessage = true;
dv.errorMessage = "Incorrect Value";
activeSheet.setDataValidator(0, 0, dv);

activeSheet.bind(GcSpread.Sheets.Events.ValidationError, function (sender, args) {
    if(args.validator.showErrorMessage){
        if (confirm(args.validator.errorMessage)) {
            args.validationResult = GcSpread.Sheets.DataValidationResult.Retry; 
        } else {
            args.validationResult = GcSpread.Sheets.DataValidationResult.ForceApply;
        }
    }    
});
Inheritance Hierarchy

Object
   GcSpread.Sheets.DataValidationResult

See Also

Reference

GcSpread.Sheets Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.