Class ValidationCollection

Namespace: Aspose.Cells
Assembly: Aspose.Cells.dll (25.2.0)

Represents data validation collection.

public class ValidationCollection : CollectionBase<validation>, IList<validation>, ICollection<validation>, IEnumerable<validation>, ICollection, IEnumerable

Inheritance

object ← CollectionBase<validation> ← ValidationCollection

Implements

IList<validation>, ICollection<validation>, IEnumerable<validation>, ICollection, IEnumerable

Inherited Members

CollectionBase<validation>.BinarySearch(Validation), CollectionBase<validation>.BinarySearch(Validation, IComparer<validation>), CollectionBase<validation>.BinarySearch(int, int, Validation, IComparer<validation>), CollectionBase<validation>.Contains(Validation), CollectionBase<validation>.CopyTo(Validation[]), CollectionBase<validation>.CopyTo(Validation[], int), CollectionBase<validation>.CopyTo(int, Validation[], int, int), CollectionBase<validation>.Exists(Predicate<validation>), CollectionBase<validation>.Find(Predicate<validation>), CollectionBase<validation>.FindAll(Predicate<validation>), CollectionBase<validation>.FindIndex(Predicate<validation>), CollectionBase<validation>.FindIndex(int, Predicate<validation>), CollectionBase<validation>.FindIndex(int, int, Predicate<validation>), CollectionBase<validation>.FindLast(Predicate<validation>), CollectionBase<validation>.FindLastIndex(Predicate<validation>), CollectionBase<validation>.FindLastIndex(int, Predicate<validation>), CollectionBase<validation>.FindLastIndex(int, int, Predicate<validation>), CollectionBase<validation>.IndexOf(Validation), CollectionBase<validation>.IndexOf(Validation, int), CollectionBase<validation>.IndexOf(Validation, int, int), CollectionBase<validation>.LastIndexOf(Validation), CollectionBase<validation>.LastIndexOf(Validation, int), CollectionBase<validation>.LastIndexOf(Validation, int, int), CollectionBase<validation>.GetEnumerator(), CollectionBase<validation>.Clear(), CollectionBase<validation>.RemoveAt(int), CollectionBase<validation>.OnClearComplete(), CollectionBase<validation>.OnClear(), CollectionBase<validation>.Capacity, CollectionBase<validation>.Count, CollectionBase<validation>.InnerList, CollectionBase<validation>.this[int], object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()

Examples

Workbook workbook = new Workbook();
ValidationCollection validations = workbook.Worksheets[0].Validations;
CellArea area = CellArea.CreateCellArea(0, 0, 1, 1);
Validation validation = validations[validations.Add(area)];
validation.Type = Aspose.Cells.ValidationType.List;
validation.Formula1 = "a,b,c,d";

Dim workbook as Workbook = new Workbook()
Dim validations as ValidationCollection  = workbook.Worksheets(0).Validations
Dim area as CellArea = CellArea.CreateCellArea(0, 0, 1, 1);
Dim validation as Validation = validations(validations.Add(area))
validation.Type = ValidationType.List
validation.Formula1 = "a,b,c,d";

Properties

this[int]

Gets the Aspose.Cells.Validation element at the specified index.

public Validation this[int index] { get; }

Property Value

Validation

Methods

Add(CellArea)

Adds a data validation to the collection.

public int Add(CellArea ca)

Parameters

ca CellArea

The area contains this validation.

Returns

int

Aspose.Cells.Validation object index.

GetValidationInCell(int, int)

Gets the validation applied to given cell.

public Validation GetValidationInCell(int row, int column)

Parameters

row int

The row index.

column int

The column index.

Returns

Validation

Returns a Aspose.Cells.Validation object or null if there is no validation for given cell

RemoveACell(int, int)

Removes all validation setting on the cell.

public void RemoveACell(int row, int column)

Parameters

row int

The row index of the cell.

column int

The column index of the cell.

RemoveArea(CellArea)

Removes all validation setting on the range..

public void RemoveArea(CellArea ca)

Parameters

ca CellArea

The range which contains the validations setting. </validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation></validation>