ValidationError Event

Occurs when the applied cell value is invalid.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance; // Type: Events
instance.ValidationError = function(sheet, sheetName, row, col, validator, validationResult) { };

ValidationError = function ( 
   sheet : Sheet,
   sheetName : string,
   row : number,
   col : number,
   validator : DefaultDataValidator,
   validationResult : DataValidationResult
) { };

Parameters

sheet: The sheet that triggered the event.
sheetName: The sheet's name.
row: The cell's row index.
col: The cell's column index.
validator: The data validator that caused the error.
validationResult: The policy that the user can set to determine how to process the error.

Example

This example uses the ValidationError event.

Javascript

var nCondition = new GcSpread.Sheets.CellValueCondition();
nCondition.compareType = GcSpread.Sheets.GeneralCompareType.EqualsTo;
nCondition.expected = 0;
//When the option is false, the validation fails and the red alert is displayed.
//When the option is true, the blank cell is treated as zero and the validation is successful.
nCondition.treatNullValueAsZero = false;
var validator = new GcSpread.Sheets.DefaultDataValidator(nCondition)
validator.IgnoreBlank(false);
activeSheet.getCell(0, 0, GcSpread.Sheets.SheetArea.viewport).dataValidator(validator);
spread.highlightInvalidData(true);
activeSheet.setValue(0, 0, null);

//Type different values in cell (0,0). This event fires if the user types an invalid value.
activeSheet.bind("ValidationError", vError);
 function vError(sender, args) {
alert("error");
            }

Reference

Events type