showErrorMessage Method

Gets or sets whether to display an error message.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(condition);
var returnValue; // Type: any
returnValue = instance.showErrorMessage(value);

function showErrorMessage( 
   value : boolean
) : any;

Parameters

value: Indicates whether to display an error message.

Return Value

If no value is set, returns whether to display an error message; otherwise, returns the data validator.

Example

This example shows an error message.

Javascript

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");
activeSheet.setDataValidator(0, 0, dv);

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

Reference

DefaultDataValidator type