Remove(WorksheetReferenceCollection) Method

Removes the data validation rule form all cells in the specified collection.

Syntax

C#

public bool Remove( 
   WorksheetReferenceCollection references
)

Parameters

references

The collection of references which should have its data validation rules cleared.

Return Value

True if the data validation rule was found and removed from any cells in the collection; False if the cells had no data validation rule applied.

Exceptions

Exception	Description
System.ArgumentNullException	Occurs when references is null.
System.ArgumentException	Occurs when the references are from a worksheet other than this collection.

Remarks

If any rules in the collection are not applied to any cells after this operation, they will be removed from the collection.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+