Class DataValidationCollection
Incapsulates one DValRecord and multiple DVRecords from xls file.
Inheritance
DataValidationCollection
Assembly: Syncfusion.XlsIO.NET.dll
Syntax
public class DataValidationCollection : CollectionBaseEx<DataValidationImpl>, IList<DataValidationImpl>, ICollection<DataValidationImpl>, IEnumerable<DataValidationImpl>, IEnumerable, IParentApplication, ICloneParent
Constructors
DataValidationCollection(IApplication, object)
Declaration
public DataValidationCollection(IApplication application, object parent)
Parameters
DataValidationCollection(IApplication, object, DValRecord)
Declaration
[CLSCompliant(false)]
public DataValidationCollection(IApplication application, object parent, DValRecord dval)
Parameters
DataValidationCollection(IApplication, object, List<BiffRecordRaw>, ref int)
Declaration
public DataValidationCollection(IApplication application, object parent, List<BiffRecordRaw> arrRecords, ref int iOffset)
Parameters
Properties
DataValidations
Returns data validation records.
Declaration
public List<BiffRecordRaw> DataValidations { get; }
Property Value
IsPromptBoxPositionFixed
Declaration
public bool IsPromptBoxPositionFixed { get; set; }
Property Value
IsPromptBoxVisible
Declaration
public bool IsPromptBoxVisible { get; set; }
Property Value
this[int]
Returns single entry from the collection. Read-only.
Declaration
public DataValidationImpl this[int index] { get; }
Parameters
| Type |
Name |
Description |
| int |
index |
|
Property Value
ParentTable
Gets parent table. Read-only.
Declaration
public DataValidationTable ParentTable { get; }
Property Value
PromptBoxHPosition
Declaration
public int PromptBoxHPosition { get; set; }
Property Value
PromptBoxVPosition
Declaration
public int PromptBoxVPosition { get; set; }
Property Value
Record
Gets DValRecord representing this collection. Read-only.
Declaration
[CLSCompliant(false)]
public DValRecord Record { get; }
Property Value
ShapesCount
Gets number of required shapes objects.
Declaration
public int ShapesCount { get; }
Property Value
Workbook
Declaration
public WorkbookImpl Workbook { get; }
Property Value
Worksheet
Declaration
public WorksheetImpl Worksheet { get; }
Property Value
Methods
Add(DataValidationImpl)
Adds data validation to the collection.
Checks if same data validation exists in the collection,
updates and returns it (if found).
Declaration
public DataValidationImpl Add(DataValidationImpl dv)
Parameters
Returns
AddDVRecord(DVRecord)
Adds new DVRecord to the collection.
Declaration
[CLSCompliant(false)]
public DataValidationImpl AddDVRecord(DVRecord dv)
Parameters
| Type |
Name |
Description |
| DVRecord |
dv |
DVRecord to add.
|
Returns
Exceptions
Clone(object)
Declaration
public override object Clone(object parent)
Parameters
| Type |
Name |
Description |
| object |
parent |
Parent object.
|
Returns
| Type |
Description |
| object |
Returns new object.
|
Overrides
FindByCellIndex(long)
Returns data validation for specified cell.
Declaration
public DataValidationImpl FindByCellIndex(long cellIndex)
Parameters
| Type |
Name |
Description |
| long |
cellIndex |
Cell index.
|
Returns
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.
|
Remove(Rectangle[])
Declaration
public void Remove(Rectangle[] rectangles)
Parameters
Remove(DataValidationImpl)
Declaration
public void Remove(DataValidationImpl dv)
Parameters
Serialize(OffsetArrayList)
Saves collection into list of BiffRecords.
Declaration
[CLSCompliant(false)]
public void Serialize(OffsetArrayList records)
Parameters
| Type |
Name |
Description |
| OffsetArrayList |
records |
OffsetArrayList with BiffRecords.
|
Exceptions
UpdateNamedRangeIndexes(IDictionary<int, int>)
Updates indexes to named ranges.
Declaration
public void UpdateNamedRangeIndexes(IDictionary<int, int> dicNewIndex)
Parameters
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.
|
Implements
Extension Methods