Static $tStatic nextGets the number of data validation rules applied on the worksheet.
Applies an AnyValueDataValidationRule to a WorksheetCell.
ArgumentNullException Occurs when 'rule' is null.
ArgumentNullException Occurs when 'cell' is null.
ArgumentException Occurs when the 'cell' is from a worksheet other than this collection.
ArgumentException Occurs when the 'rule' already applied to another worksheet.
ArgumentException Occurs when the 'rule' is invalid based on its rule type's requirements.
ArgumentException Occurs when the 'cell' already has a data validation rule applied to it.
ArgumentException Occurs when the 'cell' is a total cell of a table.
The data validation rule to apply to the cell.
The cell to which the data validation rule should be applied.
Applies an AnyValueDataValidationRule to the cells in a WorksheetRegion.
ArgumentNullException Occurs when 'rule' is null.
ArgumentNullException Occurs when 'region' is null.
ArgumentException Occurs when the 'region' is from a worksheet other than this collection.
ArgumentException Occurs when the 'rule' already applied to another worksheet.
ArgumentException Occurs when the 'rule' is invalid based on its rule type's requirements.
ArgumentException Occurs when the one or more of the cells in the 'region' already have a data validation rule applied to it.
ArgumentException Occurs when the one or more of the cells in the 'region' is a total cell of a table.
The data validation rule to apply to the region.
The region to which the data validation rule should be applied.
Applies an CustomDataValidationRule to a WorksheetCell.
ArgumentNullException Occurs when 'rule' is null.
ArgumentNullException Occurs when 'cell' is null.
ArgumentException Occurs when the 'cell' is from a worksheet other than this collection.
ArgumentException Occurs when the 'rule' already applied to another worksheet.
ArgumentException Occurs when the 'rule' is invalid based on its rule type's requirements.
ArgumentException Occurs when the 'cell' already has a data validation rule applied to it.
ArgumentException Occurs when the 'cell' is a total cell of a table.
The data validation rule to apply to the cell.
The cell to which the data validation rule should be applied.
Applies an CustomDataValidationRule to the cells in a WorksheetRegion.
ArgumentNullException Occurs when 'rule' is null.
ArgumentNullException Occurs when 'region' is null.
ArgumentException Occurs when the 'region' is from a worksheet other than this collection.
ArgumentException Occurs when the 'rule' already applied to another worksheet.
ArgumentException Occurs when the 'rule' is invalid based on its rule type's requirements.
ArgumentException Occurs when the one or more of the cells in the 'region' already have a data validation rule applied to it.
ArgumentException Occurs when the one or more of the cells in the 'region' is a total cell of a table.
The data validation rule to apply to the region.
The region to which the data validation rule should be applied.
Applies a data validation rule to the a set of references.
ArgumentNullException Occurs when 'rule' is null.
ArgumentNullException Occurs when 'references' is null.
ArgumentException Occurs when the 'references' are from a worksheet other than this collection.
ArgumentException Occurs when the 'rule' already applied to another worksheet.
ArgumentException Occurs when the 'rule' is invalid based on its rule type's requirements.
ArgumentException Occurs when the one or more of the cells in the 'references' collection are in the totals row of a table.
The data validation rule to apply to the set of references.
The reference to which the data validation rule should be applied.
Applies a data validation rule to the a set of references.
ArgumentNullException Occurs when 'rule' is null.
ArgumentNullException Occurs when 'references' is null.
ArgumentException Occurs when the 'references' are from a worksheet other than this collection.
ArgumentException Occurs when the 'rule' already applied to another worksheet.
ArgumentException Occurs when the 'rule' is invalid based on its rule type's requirements.
ArgumentException Occurs when 'overwriteExistingRules' is False and the one or more of the cells in the 'references' collection already have a data validation rule applied to it.
ArgumentException Occurs when the one or more of the cells in the 'references' collection are in the totals row of a table.
The data validation rule to apply to the set of references.
The reference to which the data validation rule should be applied.
Indicates whether cells in the references collection which already have data validation rules should have the rules overwritten.
Applies an ListDataValidationRule to a WorksheetCell.
ArgumentNullException Occurs when 'rule' is null.
ArgumentNullException Occurs when 'cell' is null.
ArgumentException Occurs when the 'cell' is from a worksheet other than this collection.
ArgumentException Occurs when the 'rule' already applied to another worksheet.
ArgumentException Occurs when the 'rule' is invalid based on its rule type's requirements.
ArgumentException Occurs when the 'cell' already has a data validation rule applied to it.
ArgumentException Occurs when the 'cell' is a total cell of a table.
The data validation rule to apply to the cell.
The cell to which the data validation rule should be applied.
Applies an ListDataValidationRule to the cells in a WorksheetRegion.
ArgumentNullException Occurs when 'rule' is null.
ArgumentNullException Occurs when 'region' is null.
ArgumentException Occurs when the 'region' is from a worksheet other than this collection.
ArgumentException Occurs when the 'rule' already applied to another worksheet.
ArgumentException Occurs when the 'rule' is invalid based on its rule type's requirements.
ArgumentException Occurs when the one or more of the cells in the 'region' already have a data validation rule applied to it.
ArgumentException Occurs when the one or more of the cells in the 'region' is a total cell of a table.
The data validation rule to apply to the region.
The region to which the data validation rule should be applied.
Applies an OneConstraintDataValidationRule to a WorksheetCell.
ArgumentNullException Occurs when 'rule' is null.
ArgumentNullException Occurs when 'cell' is null.
ArgumentException Occurs when the 'cell' is from a worksheet other than this collection.
ArgumentException Occurs when the 'rule' already applied to another worksheet.
ArgumentException Occurs when the 'rule' is invalid based on its rule type's requirements.
ArgumentException Occurs when the 'cell' already has a data validation rule applied to it.
ArgumentException Occurs when the 'cell' is a total cell of a table.
The data validation rule to apply to the cell.
The cell to which the data validation rule should be applied.
Applies an OneConstraintDataValidationRule to the cells in a WorksheetRegion.
ArgumentNullException Occurs when 'rule' is null.
ArgumentNullException Occurs when 'region' is null.
ArgumentException Occurs when the 'region' is from a worksheet other than this collection.
ArgumentException Occurs when the 'rule' already applied to another worksheet.
ArgumentException Occurs when the 'rule' is invalid based on its rule type's requirements.
ArgumentException Occurs when the one or more of the cells in the 'region' already have a data validation rule applied to it.
ArgumentException Occurs when the one or more of the cells in the 'region' is a total cell of a table.
The data validation rule to apply to the region.
The region to which the data validation rule should be applied.
Applies an TwoConstraintDataValidationRule to a WorksheetCell.
ArgumentNullException Occurs when 'rule' is null.
ArgumentNullException Occurs when 'cell' is null.
ArgumentException Occurs when the 'cell' is from a worksheet other than this collection.
ArgumentException Occurs when the 'rule' already applied to another worksheet.
ArgumentException Occurs when the 'rule' is invalid based on its rule type's requirements.
ArgumentException Occurs when the 'cell' already has a data validation rule applied to it.
ArgumentException Occurs when the 'cell' is a total cell of a table.
The data validation rule to apply to the cell.
The cell to which the data validation rule should be applied.
Applies an TwoConstraintDataValidationRule to the cells in a WorksheetRegion.
ArgumentNullException Occurs when 'rule' is null.
ArgumentNullException Occurs when 'region' is null.
ArgumentException Occurs when the 'region' is from a worksheet other than this collection.
ArgumentException Occurs when the 'rule' already applied to another worksheet.
ArgumentException Occurs when the 'rule' is invalid based on its rule type's requirements.
ArgumentException Occurs when the one or more of the cells in the 'region' already have a data validation rule applied to it.
ArgumentException Occurs when the one or more of the cells in the 'region' is a total cell of a table.
The data validation rule to apply to the region.
The region to which the data validation rule should be applied.
Determines whether the specified data validation rule exists on the worksheet.
True if the rule is applied to one or more cells on the Worksheet; False otherwise.
The rule to test.
Determines whether the specified cell has a data validation rule applied to it.
ArgumentNullException Occurs when 'cell' is null.
ArgumentException Occurs when the 'cell' is from a worksheet other than this collection.
True if the cell has a data validation rule applied; False otherwise.
The cell to test.
Determines whether the specified references collection has a data validation rule applied to any of it's cells.
ArgumentNullException Occurs when 'references' is null.
ArgumentException Occurs when the 'references' are from a worksheet other than this collection.
True if the any cell from the references collection has a data validation rule applied; False otherwise.
The references collection to test.
Determines whether the specified region has a data validation rule applied to any of it's cells.
ArgumentNullException Occurs when 'region' is null.
ArgumentException Occurs when the 'region' is from a worksheet other than this collection.
True if the any cell from the region has a data validation rule applied; False otherwise.
The region to test.
Find the data validation rule applied to the specified cell.
ArgumentNullException Occurs when 'cell' is null.
ArgumentException Occurs when the 'cell' is from a worksheet other than this collection.
A DataValidationRule-derived instance or null if the cell has no rule applied.
The cell to test.
Gets a collection of all the references which have the specified or an equivalent rule applied to them.
A collection of references in the worksheet with a rule applied to it that is equivalent to the specified 'rule'.
The rule to test.
Gets or sets the references which have the data validation rule applied to it.
ArgumentNullException Occurs when the 'rule' is null.
KeyNotFoundException Occurs when the property is retrieved and the 'rule' is not applied to the worksheet.
ArgumentException Occurs when the property is set and the value is from a Worksheet other than this collection.
ArgumentException Occurs when the property is set and the 'rule' is invalid based on its rule type's requirements.
Removes the data validation rule form the cell if one is applied.
If the rule is only applied to the specified cell, it will be removed from the collection.
ArgumentNullException Occurs when 'cell' is null.
ArgumentException Occurs when the 'cell' is from a worksheet other than this collection.
True if the data validation rule was found and removed from the cell; False if the cell had no data validation rule applied.
The cell which should have its data validation rule cleared.
Removes the data validation rule form all cells in the specified collection.
If any rules in the collection are not applied to any cells after this operation, they will be removed from the collection.
ArgumentNullException Occurs when 'references' is null.
ArgumentException Occurs when the 'references' are from a worksheet other than this collection.
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.
The collection of references which should have its data validation rules cleared.
Removes the data validation rule form all cells in the specified region.
If any rules in the collection are not applied to any cells after this operation, they will be removed from the collection.
ArgumentNullException Occurs when 'region' is null.
ArgumentException Occurs when the 'region' is from a worksheet other than this collection.
True if the data validation rule was found and removed from any cells in the region; False if the region had no data validation rule applied.
The region which should have its data validation rules cleared.
Removes the specified rule from the worksheet.
ArgumentNullException Occurs when 'rule' is null.
True if the rule was contained on the Worksheet before removal; False otherwise.
The rule which should be removed.
Static compareStatic compareStatic equalsStatic equalsStatic getStatic getStatic getStatic referenceStatic static
A collection of DataValidationRule instances in a worksheet.
See
Worksheet.dataValidationRules