# GC.Spread.Sheets.DataValidation.DataValidationResult

## Content

# Enumeration: DataValidationResult

[Sheets](../modules/GC.Spread.Sheets).[DataValidation](../modules/GC.Spread.Sheets.DataValidation).DataValidationResult

Indicates the data validation result.

**`example`**
```javascript
//This example uses the DataValidationResult enumeration.
spread.options.highlightInvalidData = true;
//The formula validator is valid if the formula condition returns true.
var dv = GC.Spread.Sheets.DataValidation.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");
var activeSheet = spread.getActiveSheet();
activeSheet.setDataValidator(0, 0, 1, 1, dv, GC.Spread.Sheets.SheetArea.viewport);
// bind event
activeSheet.bind(GC.Spread.Sheets.Events.ValidationError, function (sender, args) {
    if (args.validator.showErrorMessage()) {
        if (confirm(args.validator.errorMessage())) {
            args.validationResult = GC.Spread.Sheets.DataValidation.DataValidationResult.retry;
        } else {
            args.validationResult = GC.Spread.Sheets.DataValidation.DataValidationResult.forceApply;
        }
    }
});
```

## Table of contents

### Enumeration members

- [discard](GC.Spread.Sheets.DataValidation.DataValidationResult#discard)
- [forceApply](GC.Spread.Sheets.DataValidation.DataValidationResult#forceapply)
- [retry](GC.Spread.Sheets.DataValidation.DataValidationResult#retry)

## Enumeration members

### <a id="discard" name="discard"></a> discard

• **discard** = `1`

Indicates to discard the value and not apply it to the cell for a validation error.

___

### <a id="forceapply" name="forceapply"></a> forceApply

• **forceApply** = `0`

Indicates to apply the value to a cell for a validation error.

___

### <a id="retry" name="retry"></a> retry

• **retry** = `2`

Indicates to retry multiple times to apply the value to the cell for a validation error.