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, 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. |
| object | parent | Parent object for the collection. |
DataValidationTable(IApplication, object, List<BiffRecordRaw>, ref int)
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. |
| object | parent | Parent object for the collection. |
| List<BiffRecordRaw> | arrRecords | List with data validation records. |
| int | iOffset | Offset to the first data validation record. |
Properties
this[int]
Returns single entry from the collection. Read-only.
Declaration
public DataValidationCollection this[int index] { get; }
Parameters
| Type | Name | Description |
|---|---|---|
| int | index |
Property Value
| Type |
|---|
| DataValidationCollection |
ShapesCount
Gets number of required shapes objects.
Declaration
public int ShapesCount { get; }
Property Value
| Type |
|---|
| int |
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
[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 |
|---|---|---|
| object | parent | Parent object. |
Returns
| Type | Description |
|---|---|
| object | Returns clone of current object. |
Overrides
FindDataValidation(int, int)
Searches for corresponding data validation.
Declaration
public DataValidationImpl FindDataValidation(int row, int column)
Parameters
| Type | Name | Description |
|---|---|---|
| int | row | One-based row index. |
| int | column | One-based column index. |
Returns
| Type | Description |
|---|---|
| DataValidationImpl | Found data validation or null. |
FindDataValidation(long)
Searches for corresponding data validation.
Declaration
public DataValidationImpl FindDataValidation(long cellIndex)
Parameters
| Type | Name | Description |
|---|---|---|
| long | cellIndex | Cell index. |
Returns
| Type | Description |
|---|---|
| DataValidationImpl | Found data validation or null. |
MarkUsedReferences(bool[])
Sets items with used reference indexes to true.
Declaration
public void MarkUsedReferences(bool[] usedItems)
Parameters
| Type | Name | Description |
|---|---|---|
| bool[] | usedItems | Array to mark used references in. |
OnClearComplete()
Clears all the content.
Declaration
protected override void OnClearComplete()
Overrides
Parse(List<BiffRecordRaw>, ref int)
Extracts data validation table from array of records.
Declaration
public void Parse(List<BiffRecordRaw> arrRecords, ref int iOffset)
Parameters
| Type | Name | Description |
|---|---|---|
| List<BiffRecordRaw> | arrRecords | List with data validation records. |
| int | 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<int, int>)
Updates indexes to named ranges.
Declaration
public void UpdateNamedRangeIndexes(IDictionary<int, int> dicNewIndex)
Parameters
| Type | Name | Description |
|---|---|---|
| IDictionary<int, int> | dicNewIndex | New indexes. |
UpdateNamedRangeIndexes(int[])
Updates indexes to named ranges.
Declaration
public void UpdateNamedRangeIndexes(int[] arrNewIndex)
Parameters
| Type | Name | Description |
|---|---|---|
| int[] | arrNewIndex | New indexes. |
UpdateReferenceIndexes(int[])
Updates reference indexes.
Declaration
public void UpdateReferenceIndexes(int[] arrUpdatedIndexes)
Parameters
| Type | Name | Description |
|---|---|---|
| int[] | arrUpdatedIndexes | Array with updated indexes. |