Class XlsDataValidationCollection

Namespace

Spire.Xls.Core.Spreadsheet.Collections

Assembly

Spire.XLS.dll

public class XlsDataValidationCollection : CollectionExtended<XlsValidation>, IList<XlsValidation>, ICollection<XlsValidation>, IEnumerable<XlsValidation>, IEnumerable, IExcelApplication, ICloneParent, IDataValidationCollection

Inheritance

object

CollectionBase<XlsValidation>

CollectionExtended<XlsValidation>

XlsDataValidationCollection

Implements

IList<XlsValidation>

ICollection<XlsValidation>

IEnumerable<XlsValidation>

IEnumerable

IExcelApplication

ICloneParent

IDataValidationCollection

Inherited Members

CollectionExtended<XlsValidation>.OnClear()

CollectionExtended<XlsValidation>.OnClearComplete()

CollectionExtended<XlsValidation>.OnInsert(int, XlsValidation)

CollectionExtended<XlsValidation>.OnInsertComplete(int, XlsValidation)

CollectionExtended<XlsValidation>.OnRemove(int, XlsValidation)

CollectionExtended<XlsValidation>.OnRemoveComplete(int, XlsValidation)

CollectionExtended<XlsValidation>.OnSet(int, XlsValidation, XlsValidation)

CollectionExtended<XlsValidation>.OnSetComplete(int, XlsValidation, XlsValidation)

CollectionExtended<XlsValidation>.FindParent(Type)

CollectionExtended<XlsValidation>.FindParent(Type, bool)

CollectionExtended<XlsValidation>.SetParent(object)

CollectionExtended<XlsValidation>.Clone(object)

CollectionExtended<XlsValidation>.EnsureCapacity(int)

CollectionExtended<XlsValidation>.GenerateDefaultName(ICollection<XlsValidation>, string)

CollectionExtended<XlsValidation>.GenerateDefaultName(ICollection, string)

CollectionExtended<XlsValidation>.GenerateDefaultName(string, params ICollection[])

CollectionExtended<XlsValidation>.ChangeName(IDictionary, XlsEventArgs)

CollectionExtended<XlsValidation>.Parent

CollectionExtended<XlsValidation>.Changed

CollectionBase<XlsValidation>.Clear()

CollectionBase<XlsValidation>.Insert(int, XlsValidation)

CollectionBase<XlsValidation>.GetEnumerator()

CollectionBase<XlsValidation>.RemoveAt(int)

CollectionBase<XlsValidation>.IndexOf(XlsValidation)

CollectionBase<XlsValidation>.Add(XlsValidation)

CollectionBase<XlsValidation>.Contains(XlsValidation)

CollectionBase<XlsValidation>.CopyTo(XlsValidation[], int)

CollectionBase<XlsValidation>.Remove(XlsValidation)

CollectionBase<XlsValidation>.Capacity

CollectionBase<XlsValidation>.Count

CollectionBase<XlsValidation>.InnerList

CollectionBase<XlsValidation>.List

CollectionBase<XlsValidation>.IsReadOnly

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

IsPromptBoxPositionFixed

Indicates whehter prompt box has fixed position..

public bool IsPromptBoxPositionFixed { get; set; }

Property Value

bool

IsPromptBoxVisible

Indicates whehter prompt box is visible..

public bool IsPromptBoxVisible { get; set; }

Property Value

bool

this[int]

public IDataValidation this[int index] { get; }

Parameters

index int

Property Value

IDataValidation

ParentTable

public IDataValidationTable ParentTable { get; }

Property Value

IDataValidationTable

PromptBoxHPosition

Vertical position of the prompt box.

public int PromptBoxHPosition { get; set; }

Property Value

int

PromptBoxVPosition

Vertical position of the prompt box.

public int PromptBoxVPosition { get; set; }

Property Value

int

ShapesCount

public int ShapesCount { get; }

Property Value

int

Workbook

public Workbook Workbook { get; }

Property Value

Workbook

Worksheet

public Worksheet Worksheet { get; }

Property Value

Worksheet

Methods

FindByCellIndex(long)

protected XlsValidation FindByCellIndex(long iCellIndex)

Parameters

iCellIndex long

Returns

XlsValidation

Remove(Rectangle[])

public void Remove(Rectangle[] rectangles)

Parameters

rectangles Rectangle[]