Xamarin.Android

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class DataValidationCollection

    Show / Hide Table of Contents

    Class DataValidationCollection

    Incapsulates one DValRecord and multiple DVRecords from xls file.

    Inheritance
    System.Object
    CollectionBase<DataValidationImpl>
    CollectionBaseEx<DataValidationImpl>
    DataValidationCollection
    Implements
    System.Collections.Generic.IList<DataValidationImpl>
    System.Collections.Generic.ICollection<DataValidationImpl>
    System.Collections.Generic.IEnumerable<DataValidationImpl>
    System.Collections.IEnumerable
    IParentApplication
    ICloneParent
    Inherited Members
    CollectionBaseEx<DataValidationImpl>.add_Clearing(CollectionBaseEx.CollectionClear<>)
    CollectionBaseEx<DataValidationImpl>.remove_Clearing(CollectionBaseEx.CollectionClear<>)
    CollectionBaseEx<DataValidationImpl>.add_Cleared(CollectionBaseEx.CollectionClear<>)
    CollectionBaseEx<DataValidationImpl>.remove_Cleared(CollectionBaseEx.CollectionClear<>)
    CollectionBaseEx<DataValidationImpl>.add_Inserting(CollectionBaseEx.CollectionChange<>)
    CollectionBaseEx<DataValidationImpl>.remove_Inserting(CollectionBaseEx.CollectionChange<>)
    CollectionBaseEx<DataValidationImpl>.add_Inserted(CollectionBaseEx.CollectionChange<>)
    CollectionBaseEx<DataValidationImpl>.remove_Inserted(CollectionBaseEx.CollectionChange<>)
    CollectionBaseEx<DataValidationImpl>.add_Removing(CollectionBaseEx.CollectionChange<>)
    CollectionBaseEx<DataValidationImpl>.remove_Removing(CollectionBaseEx.CollectionChange<>)
    CollectionBaseEx<DataValidationImpl>.add_Removed(CollectionBaseEx.CollectionChange<>)
    CollectionBaseEx<DataValidationImpl>.remove_Removed(CollectionBaseEx.CollectionChange<>)
    CollectionBaseEx<DataValidationImpl>.add_Setting(CollectionBaseEx.CollectionSet<>)
    CollectionBaseEx<DataValidationImpl>.remove_Setting(CollectionBaseEx.CollectionSet<>)
    CollectionBaseEx<DataValidationImpl>.add_Set(CollectionBaseEx.CollectionSet<>)
    CollectionBaseEx<DataValidationImpl>.remove_Set(CollectionBaseEx.CollectionSet<>)
    CollectionBaseEx<DataValidationImpl>.OnClear()
    CollectionBaseEx<DataValidationImpl>.OnClearComplete()
    CollectionBaseEx<DataValidationImpl>.OnInsert(Int32, DataValidationImpl)
    CollectionBaseEx<DataValidationImpl>.OnInsertComplete(Int32, DataValidationImpl)
    CollectionBaseEx<DataValidationImpl>.OnRemove(Int32, DataValidationImpl)
    CollectionBaseEx<DataValidationImpl>.OnRemoveComplete(Int32, DataValidationImpl)
    CollectionBaseEx<DataValidationImpl>.OnSet(Int32, DataValidationImpl, DataValidationImpl)
    CollectionBaseEx<DataValidationImpl>.OnSetComplete(Int32, DataValidationImpl, DataValidationImpl)
    CollectionBaseEx<DataValidationImpl>.FindParent(Type)
    CollectionBaseEx<DataValidationImpl>.FindParent(Type, Boolean)
    CollectionBaseEx<DataValidationImpl>.SetParent(Object)
    CollectionBaseEx<DataValidationImpl>.EnsureCapacity(Int32)
    CollectionBaseEx<DataValidationImpl>.ClearMaxValues()
    CollectionBaseEx<DataValidationImpl>.GenerateDefaultName(ICollection<DataValidationImpl>, String)
    CollectionBaseEx<DataValidationImpl>.GenerateDefaultName(ICollection, String)
    CollectionBaseEx<DataValidationImpl>.GenerateDefaultName(String, ICollection[])
    CollectionBaseEx<DataValidationImpl>.ChangeName(IDictionary, ValueChangedEventArgs)
    CollectionBaseEx<DataValidationImpl>.Application
    CollectionBaseEx<DataValidationImpl>.Parent
    CollectionBaseEx<DataValidationImpl>.QuietMode
    CollectionBaseEx<DataValidationImpl>.AppImplementation
    CollectionBaseEx<DataValidationImpl>.Changed
    CollectionBaseEx<DataValidationImpl>.Clearing
    CollectionBaseEx<DataValidationImpl>.Cleared
    CollectionBaseEx<DataValidationImpl>.Inserting
    CollectionBaseEx<DataValidationImpl>.Inserted
    CollectionBaseEx<DataValidationImpl>.Removing
    CollectionBaseEx<DataValidationImpl>.Removed
    CollectionBaseEx<DataValidationImpl>.Setting
    CollectionBaseEx<DataValidationImpl>.Set
    CollectionBase<DataValidationImpl>.Clear()
    CollectionBase<DataValidationImpl>.Insert(Int32, DataValidationImpl)
    CollectionBase<DataValidationImpl>.GetEnumerator()
    CollectionBase<DataValidationImpl>.RemoveAt(Int32)
    CollectionBase<DataValidationImpl>.IndexOf(DataValidationImpl)
    CollectionBase<DataValidationImpl>.Contains(DataValidationImpl)
    CollectionBase<DataValidationImpl>.CopyTo(DataValidationImpl[], Int32)
    CollectionBase<DataValidationImpl>.Capacity
    CollectionBase<DataValidationImpl>.Count
    CollectionBase<DataValidationImpl>.InnerList
    CollectionBase<DataValidationImpl>.List
    CollectionBase<DataValidationImpl>.IsReadOnly
    Namespace: Syncfusion.XlsIO.Implementation.Collections
    Assembly: Syncfusion.XlsIO.Portable.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
    Type Name Description
    IApplication application
    System.Object parent

    DataValidationCollection(IApplication, Object, DValRecord)

    Declaration
    public DataValidationCollection(IApplication application, object parent, DValRecord dval)
    Parameters
    Type Name Description
    IApplication application
    System.Object parent
    DValRecord dval

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

    Declaration
    public DataValidationCollection(IApplication application, object parent, List<BiffRecordRaw> arrRecords, ref int iOffset)
    Parameters
    Type Name Description
    IApplication application
    System.Object parent
    System.Collections.Generic.List<Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw> arrRecords
    System.Int32 iOffset

    Properties

    DataValidations

    Returns data validation records.

    Declaration
    public List<BiffRecordRaw> DataValidations { get; }
    Property Value
    Type Description
    System.Collections.Generic.List<Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw>

    IsPromptBoxPositionFixed

    Declaration
    public bool IsPromptBoxPositionFixed { get; set; }
    Property Value
    Type Description
    System.Boolean

    IsPromptBoxVisible

    Declaration
    public bool IsPromptBoxVisible { get; set; }
    Property Value
    Type Description
    System.Boolean

    Item[Int32]

    Returns single entry from the collection. Read-only.

    Declaration
    public DataValidationImpl this[int index] { get; }
    Parameters
    Type Name Description
    System.Int32 index
    Property Value
    Type Description
    DataValidationImpl

    ParentTable

    Gets parent table. Read-only.

    Declaration
    public DataValidationTable ParentTable { get; }
    Property Value
    Type Description
    DataValidationTable

    PromptBoxHPosition

    Declaration
    public int PromptBoxHPosition { get; set; }
    Property Value
    Type Description
    System.Int32

    PromptBoxVPosition

    Declaration
    public int PromptBoxVPosition { get; set; }
    Property Value
    Type Description
    System.Int32

    Record

    Gets DValRecord representing this collection. Read-only.

    Declaration
    public DValRecord Record { get; }
    Property Value
    Type Description
    DValRecord

    ShapesCount

    Gets number of required shapes objects.

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

    Workbook

    Parent workbook.

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

    Worksheet

    Parent worksheet.

    Declaration
    public WorksheetImpl Worksheet { get; }
    Property Value
    Type Description
    WorksheetImpl

    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
    Type Name Description
    DataValidationImpl dv

    Data validation to add.

    Returns
    Type Description
    DataValidationImpl

    Data validation that was added or that was updated.

    AddDVRecord(DVRecord)

    Adds new DVRecord to the collection.

    Declaration
    public DataValidationImpl AddDVRecord(DVRecord dv)
    Parameters
    Type Name Description
    DVRecord dv

    DVRecord to add.

    Returns
    Type Description
    DataValidationImpl
    Exceptions
    Type Condition
    System.ArgumentNullException

    If dv is NULL.

    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 new object.

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

    FindByCellIndex(Int64)

    Returns data validation for specified cell.

    Declaration
    public DataValidationImpl FindByCellIndex(long cellIndex)
    Parameters
    Type Name Description
    System.Int64 cellIndex

    Cell index.

    Returns
    Type Description
    DataValidationImpl

    Data validation for specified cell.

    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.

    Remove(Rectangle[])

    Declaration
    public void Remove(Rectangle[] rectangles)
    Parameters
    Type Name Description
    Rectangle[] rectangles

    Remove(DataValidationImpl)

    Declaration
    public void Remove(DataValidationImpl dv)
    Parameters
    Type Name Description
    DataValidationImpl dv

    Serialize(OffsetArrayList)

    Saves collection into list of BiffRecords.

    Declaration
    public void Serialize(OffsetArrayList records)
    Parameters
    Type Name Description
    OffsetArrayList records

    OffsetArrayList with BiffRecords.

    Exceptions
    Type Condition
    System.ArgumentNullException

    If records parameter is NULL.

    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
    IParentApplication
    ICloneParent
    Back to top Generated by DocFX
    Copyright © 2001 - 2023 Syncfusion Inc. All Rights Reserved