Class DataValidationTable
Table of all data validation in the worksheet.
Inheritance
Implements
Inherited Members
Namespace: Syncfusion.XlsIO.Implementation.Collections
Assembly: Syncfusion.XlsIO.NET.dll
Syntax
public class DataValidationTable : CollectionBaseEx<DataValidationCollection>, IList<DataValidationCollection>, ICollection<DataValidationCollection>, IEnumerable<DataValidationCollection>, IEnumerable, IParentApplication, ICloneParentConstructors
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
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
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. |