public class DataValidationTable : CollectionBaseEx<DataValidationCollection>, IList<DataValidationCollection>, ICollection<DataValidationCollection>, IEnumerable<DataValidationCollection>, IEnumerable, IParentApplication, ICloneParent

Constructors

DataValidationTable(IApplication, Object)

Creates DataValidationTable.

Declaration

public DataValidationTable(IApplication application, object parent)

Parameters

Type	Name	Description
IApplication	application	Application object for the collection.
System.Object	parent	Parent object for the collection.

DataValidationTable(IApplication, Object, List<BiffRecordRaw>, ref Int32)

Creates DataValidationTable.

Declaration

public DataValidationTable(IApplication application, object parent, List<BiffRecordRaw> arrRecords, ref int iOffset)

Parameters

Type	Name	Description
IApplication	application	Application object for the collection.
System.Object	parent	Parent object for the collection.
System.Collections.Generic.List<Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw>	arrRecords	List with data validation records.
System.Int32	iOffset	Offset to the first data validation record.

Properties

Item[Int32]

Returns single entry from the collection. Read-only.

Declaration

public DataValidationCollection this[int index] { get; }

Parameters

Type	Name	Description
System.Int32	index

Property Value

Type	Description
DataValidationCollection

ShapesCount

Gets number of required shapes objects.

Declaration

public int ShapesCount { get; }

Property Value

Type	Description
System.Int32

Workbook

Gets parent workbook. Read-only.

Declaration

public WorkbookImpl Workbook { get; }

Property Value

Type	Description
WorkbookImpl

Worksheet

Gets parent worksheet. Read-only.

Declaration

public WorksheetImpl Worksheet { get; }

Property Value

Type	Description
WorksheetImpl

Methods

Add(DataValidationCollection)

Adds new data validation collection.

Declaration

public DataValidationCollection Add(DataValidationCollection dval)

Parameters

Type	Name	Description
DataValidationCollection	dval	Collection to add.

Returns

Type	Description
DataValidationCollection	Newly added data validation collection

Add(DValRecord)

Adds new data validation to the collection.

Declaration

[CLSCompliant(false)]
public DataValidationCollection Add(DValRecord dval)

Parameters

Type	Name	Description
DValRecord	dval	DValRecord to add.

Returns

Type	Description
DataValidationCollection	Newly added data validation collection.

Clone(Object)

Clones current instance.

Declaration

public override object Clone(object parent)

Parameters

Type	Name	Description
System.Object	parent	Parent object.

Returns

Type	Description
System.Object	Returns clone of current object.

Overrides

Syncfusion.XlsIO.Implementation.Collections.CollectionBaseEx<Syncfusion.XlsIO.Implementation.Collections.DataValidationCollection>.Clone(System.Object)

FindDataValidation(Int32, Int32)

Searches for corresponding data validation.

Declaration

public DataValidationImpl FindDataValidation(int row, int column)

Parameters

Type	Name	Description
System.Int32	row	One-based row index.
System.Int32	column	One-based column index.

Returns

Type	Description
DataValidationImpl	Found data validation or null.

FindDataValidation(Int64)

Searches for corresponding data validation.

Declaration

public DataValidationImpl FindDataValidation(long cellIndex)

Parameters

Type	Name	Description
System.Int64	cellIndex	Cell index.

Returns

Type	Description
DataValidationImpl	Found data validation or null.

MarkUsedReferences(Boolean[])

Sets items with used reference indexes to true.

Declaration

public void MarkUsedReferences(bool[] usedItems)

Parameters

Type	Name	Description
System.Boolean[]	usedItems	Array to mark used references in.

OnClearComplete()

Clears all the content.

Declaration

protected override void OnClearComplete()

Overrides

Syncfusion.XlsIO.Implementation.Collections.CollectionBaseEx<Syncfusion.XlsIO.Implementation.Collections.DataValidationCollection>.OnClearComplete()

Parse(List<BiffRecordRaw>, ref Int32)

Extracts data validation table from array of records.

Declaration

public void Parse(List<BiffRecordRaw> arrRecords, ref int iOffset)

Parameters

Type	Name	Description
System.Collections.Generic.List<Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw>	arrRecords	List with data validation records.
System.Int32	iOffset	Offset to the first data validation record.

Remove(Rectangle[])

Removes specified rectangles from the collection.

Declaration

public void Remove(Rectangle[] rectangles)

Parameters

Type	Name	Description
System.Drawing.Rectangle[]	rectangles	Rectangles to remove.

UpdateNamedRangeIndexes(IDictionary<Int32, Int32>)

Updates indexes to named ranges.

Declaration

public void UpdateNamedRangeIndexes(IDictionary<int, int> dicNewIndex)

Parameters

Type	Name	Description
System.Collections.Generic.IDictionary<System.Int32, System.Int32>	dicNewIndex	New indexes.

UpdateNamedRangeIndexes(Int32[])

Updates indexes to named ranges.

Declaration

public void UpdateNamedRangeIndexes(int[] arrNewIndex)

Parameters

Type	Name	Description
System.Int32[]	arrNewIndex	New indexes.

UpdateReferenceIndexes(Int32[])

Updates reference indexes.

Declaration

public void UpdateReferenceIndexes(int[] arrUpdatedIndexes)

Parameters

Type	Name	Description
System.Int32[]	arrUpdatedIndexes	Array with updated indexes.

Implements

System.Collections.Generic.IList<T>

System.Collections.Generic.ICollection<T>

System.Collections.Generic.IEnumerable<T>

System.Collections.IEnumerable

IParentApplication

ICloneParent