Add(ListDataValidationRule,WorksheetRegion) Method

Applies an ListDataValidationRule to the cells in a WorksheetRegion.

Syntax

C#

public void Add( 
   ListDataValidationRule rule,
   WorksheetRegion region
)

Parameters

rule

The data validation rule to apply to the region.

region

The region to which the data validation rule should be applied.

Exceptions

Exception	Description
System.ArgumentNullException	Occurs when rule is null.
System.ArgumentNullException	Occurs when region is null.
System.ArgumentException	Occurs when the region is from a worksheet other than this collection.
System.ArgumentException	Occurs when the rule already applied to another worksheet.
System.ArgumentException	Occurs when the rule is invalid based on its rule type's requirements.
System.ArgumentException	Occurs when the one or more of the cells in the region already have a data validation rule applied to it.
System.ArgumentException	Occurs when the one or more of the cells in the region is a total cell of a table.

Requirements

Target Platforms: Android 4.4+, iOS 8+

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