XlDataValidation.ErrorMessage Property

Gets or sets the error message to display when the entered data is not valid.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public string ErrorMessage { get; set; }

VB.NET

Public Property ErrorMessage As String

Property Value

Type	Description
String	A String text for the error message.

Remarks

Set the XlDataValidation.ShowErrorMessage property to true to show the error message. Use the XlDataValidation.ErrorTitle property to specify the dialog caption. The XlDataValidation.ErrorStyle property specifies the type of the alert window.

The code sample below shows how to show the warning message when the entered data in invalid:

C#

// Display the error message.
validation.ErrorMessage = "The salary amount must be between 600$ and 2000$.";
validation.ErrorTitle = "Warning";
validation.ErrorStyle = XlDataValidationErrorStyle.Warning;
validation.ShowErrorMessage = true;

VB.NET

' Display the error message.
validation.ErrorMessage = "The salary amount must be between 600$ and 2000$."
validation.ErrorTitle = "Warning"
validation.ErrorStyle = XlDataValidationErrorStyle.Warning
validation.ShowErrorMessage = True