Class DataValidationTable

Table of all data validation in the worksheet.

Inheritance
System.Object
CollectionBase<DataValidationCollection>
CollectionBaseEx<DataValidationCollection>
DataValidationTable
Implements
System.Collections.Generic.IList<DataValidationCollection>
System.Collections.Generic.ICollection<DataValidationCollection>
System.Collections.Generic.IEnumerable<DataValidationCollection>
System.Collections.IEnumerable
Inherited Members
Namespace: Syncfusion.XlsIO.Implementation.Collections
Assembly: Syncfusion.XlsIO.UWP.dll
Syntax
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
DataValidationCollection

ShapesCount

Gets number of required shapes objects.

Declaration
public int ShapesCount { get; }
Property Value
Type
System.Int32

Workbook

Gets parent workbook. Read-only.

Declaration
public WorkbookImpl Workbook { get; }
Property Value
Type
WorkbookImpl

Worksheet

Gets parent worksheet. Read-only.

Declaration
public WorksheetImpl Worksheet { get; }
Property Value
Type
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
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
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<>
System.Collections.Generic.ICollection<>
System.Collections.Generic.IEnumerable<>
System.Collections.IEnumerable

Extension Methods