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;
}
}
});