alexa
menu

MAUI

  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Search Results for

    Show / Hide Table of Contents

    Class DataValidationTable

    Table of all data validation in the worksheet.

    Inheritance
    object
    CollectionBase<DataValidationCollection>
    CollectionBaseEx<DataValidationCollection>
    DataValidationTable
    Implements
    IList<DataValidationCollection>
    ICollection<DataValidationCollection>
    IEnumerable<DataValidationCollection>
    IEnumerable
    IParentApplication
    ICloneParent
    Inherited Members
    CollectionBase<DataValidationCollection>.Capacity
    CollectionBase<DataValidationCollection>.Clear()
    CollectionBase<DataValidationCollection>.Contains(DataValidationCollection)
    CollectionBase<DataValidationCollection>.CopyTo(DataValidationCollection[], int)
    CollectionBase<DataValidationCollection>.Count
    CollectionBase<DataValidationCollection>.GetEnumerator()
    CollectionBase<DataValidationCollection>.IndexOf(DataValidationCollection)
    CollectionBase<DataValidationCollection>.InnerList
    CollectionBase<DataValidationCollection>.Insert(int, DataValidationCollection)
    CollectionBase<DataValidationCollection>.IsReadOnly
    CollectionBase<DataValidationCollection>.List
    CollectionBase<DataValidationCollection>.Remove(DataValidationCollection)
    CollectionBase<DataValidationCollection>.RemoveAt(int)
    CollectionBaseEx<DataValidationCollection>.AppImplementation
    CollectionBaseEx<DataValidationCollection>.Application
    CollectionBaseEx<DataValidationCollection>.Changed
    CollectionBaseEx<DataValidationCollection>.ChangeName(IDictionary, ValueChangedEventArgs)
    CollectionBaseEx<DataValidationCollection>.Cleared
    CollectionBaseEx<DataValidationCollection>.Clearing
    CollectionBaseEx<DataValidationCollection>.ClearMaxValues()
    CollectionBaseEx<DataValidationCollection>.EnsureCapacity(int)
    CollectionBaseEx<DataValidationCollection>.FindParent(Type)
    CollectionBaseEx<DataValidationCollection>.FindParent(Type, bool)
    CollectionBaseEx<DataValidationCollection>.GenerateDefaultName(ICollection<DataValidationCollection>, string)
    CollectionBaseEx<DataValidationCollection>.GenerateDefaultName(ICollection, string)
    CollectionBaseEx<DataValidationCollection>.GenerateDefaultName(string, params ICollection[])
    CollectionBaseEx<DataValidationCollection>.Inserted
    CollectionBaseEx<DataValidationCollection>.Inserting
    CollectionBaseEx<DataValidationCollection>.OnClear()
    CollectionBaseEx<DataValidationCollection>.OnInsert(int, DataValidationCollection)
    CollectionBaseEx<DataValidationCollection>.OnInsertComplete(int, DataValidationCollection)
    CollectionBaseEx<DataValidationCollection>.OnRemove(int, DataValidationCollection)
    CollectionBaseEx<DataValidationCollection>.OnRemoveComplete(int, DataValidationCollection)
    CollectionBaseEx<DataValidationCollection>.OnSet(int, DataValidationCollection, DataValidationCollection)
    CollectionBaseEx<DataValidationCollection>.OnSetComplete(int, DataValidationCollection, DataValidationCollection)
    CollectionBaseEx<DataValidationCollection>.Parent
    CollectionBaseEx<DataValidationCollection>.QuietMode
    CollectionBaseEx<DataValidationCollection>.Removed
    CollectionBaseEx<DataValidationCollection>.Removing
    CollectionBaseEx<DataValidationCollection>.Set
    CollectionBaseEx<DataValidationCollection>.SetParent(object)
    CollectionBaseEx<DataValidationCollection>.Setting
    object.Equals(object)
    object.Equals(object, object)
    object.GetHashCode()
    object.GetType()
    object.MemberwiseClone()
    object.ReferenceEquals(object, object)
    object.ToString()
    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
    CollectionBaseEx<DataValidationCollection>.Clone(object)

    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
    CollectionBaseEx<DataValidationCollection>.OnClearComplete()

    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.

    Implements

    IList<T>
    ICollection<T>
    IEnumerable<T>
    IEnumerable
    IParentApplication
    ICloneParent

    Extension Methods

    CalcEngineHelper.ToArray<T>(IEnumerable<T>)
    In this article
    Back to top Generated by DocFX
    Copyright © 2001 - 2026 Syncfusion Inc. All Rights Reserved