DataValidationCollection.Clear() Method

Removes all entries from the collection.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void Clear()

VB.NET

Sub Clear

Remarks

To delete an individual entry from the collection, use the DataValidationCollection.Remove or DataValidationCollection.RemoveAt method.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Clear() method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

wpf-spreadsheetcontrol-api-part-3/CS/SpreadsheetControl_WPF_API_Part03/CodeExamples/DataValidationActions.cs#L203

// Remove all data validations.
worksheet.DataValidations.Clear();

winforms-spreadsheetcontrol-api-part-3/CS/SpreadsheetControl_API_Part03/CodeExamples/DataValidationActions.cs#L215

// Remove all data validations.
worksheet.DataValidations.Clear();

spreadsheet-document-api-examples-part3/CS/Spreadsheet_Document_Api_Part_3/CodeExamples/DataValidationActions.cs#L251

// Remove all data validations.
worksheet.DataValidations.Clear();

VB.NET

wpf-spreadsheetcontrol-api-part-3/VB/SpreadsheetControl_WPF_API_Part03/CodeExamples/DataValidationActions.vb#L199

' Remove all data validations.
worksheet.DataValidations.Clear()

winforms-spreadsheetcontrol-api-part-3/VB/SpreadsheetControl_API_Part03/CodeExamples/DataValidationActions.vb#L179

' Remove all data validations.
worksheet.DataValidations.Clear()
' Highlight data validation ranges.

spreadsheet-document-api-examples-part3/VB/Spreadsheet_Document_Api_Part_3/CodeExamples/DataValidationActions.vb#L248

' Remove all data validations.
worksheet.DataValidations.Clear()