

'DeclarationPublic Class DataValidationError Inherits DataValidationMessage
'UsageDim instance As DataValidationError
public class DataValidationError : DataValidationMessage
using( var workbook = Workbook.Create( "AddDataValidation.xlsx" ) ) { // Gets the first Worksheet; a Workbook always contains at least 1 Worksheet. var worksheet = workbook.Worksheets[ 0 ]; // Creates a new DataValidation and assigns it to Cells A1 to A3. var dataValidation = new DataValidation( ValidationType.Decimal, DataComparisonType.LessThanOrEqual ) { Value = 10 }; dataValidation.Error = new DataValidationError( "My Error", "Value must under 10", DataValidationErrorStyle.Warning ); worksheet.Cells[ "A1", "A3" ].DataValidation = dataValidation; // Saves Workbook to disk; workbook.Save(); }
System.Object
Xceed.Workbooks.NET.DataValidationMessage
Xceed.Workbooks.NET.DataValidationError
| Name | Description | |
|---|---|---|
![]() | DataValidationError Constructor | Overloaded. |
| Name | Description | |
|---|---|---|
![]() | Show | Gets or sets if the input message is displayed when the user selects the target Cell(s) or hovers over them. (Inherited from Xceed.Workbooks.NET.DataValidationMessage) |
![]() | Style | Gets or sets the DataValidationErrorStyle. |
![]() | Text | Gets or sets the input message's text. (Inherited from Xceed.Workbooks.NET.DataValidationMessage) |
![]() | Title | Gets or sets the input message's title. (Inherited from Xceed.Workbooks.NET.DataValidationMessage) |
| Name | Description | |
|---|---|---|
![]() | Clone | Overridden. |
![]() | Equals | Overloaded. |
![]() | GetHashCode | Overridden. |
.NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.
.NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.