menu

UWP

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class DataValidationArray - UWP API Reference | Syncfusion

    Show / Hide Table of Contents

    Class DataValidationArray

    Contains a condition and the formatting attributes applied to the cell, if the condition is met. Used for multiple-cells range.

    Inheritance
    System.Object
    CommonWrapper
    DataValidationArray
    Implements
    ICloneParent
    IDataValidation
    IParentApplication
    IOptimizedUpdate
    Inherited Members
    CommonWrapper.BeginCallsCount
    CommonWrapper.Clone(Object)
    Namespace: Syncfusion.XlsIO.Implementation
    Assembly: Syncfusion.XlsIO.UWP.dll
    Syntax
    public class DataValidationArray : CommonWrapper, ICloneParent, IInternalDataValidation, IDataValidation, IParentApplication, IOptimizedUpdate

    Constructors

    DataValidationArray(IRange)

    Initializes a new instance of DataValidationArray class with specified parent range.

    Declaration
    public DataValidationArray(IRange parent)
    Parameters
    Type Name Description
    IRange parent

    Parent object for the format.

    Properties

    AllowType

    Gets or sets the data type validation for a range.

    Declaration
    public ExcelDataType AllowType { get; set; }
    Property Value
    Type
    ExcelDataType

    Application

    Application object for this object.

    Declaration
    public IApplication Application { get; }
    Property Value
    Type
    IApplication

    CompareOperator

    Gets or sets the comparison operation to perform.

    Declaration
    public ExcelDataValidationComparisonOperator CompareOperator { get; set; }
    Property Value
    Type
    ExcelDataValidationComparisonOperator

    DataRange

    Gets or sets the Range of possible values.

    Declaration
    public IRange DataRange { get; set; }
    Property Value
    Type
    IRange

    ErrorBoxText

    Gets or sets the error message in the error dialog .

    Declaration
    public string ErrorBoxText { get; set; }
    Property Value
    Type
    System.String

    ErrorBoxTitle

    Gets or sets the title of the error dialog.

    Declaration
    public string ErrorBoxTitle { get; set; }
    Property Value
    Type
    System.String

    ErrorStyle

    Gets or sets the type of error.

    Declaration
    public ExcelErrorStyle ErrorStyle { get; set; }
    Property Value
    Type
    ExcelErrorStyle

    FirstDateTime

    Gets or sets the first formula's DateTime value.

    Declaration
    public DateTime FirstDateTime { get; set; }
    Property Value
    Type
    System.DateTime

    FirstFormula

    Gets or sets the value or expression associated with the data validation.

    Declaration
    public string FirstFormula { get; set; }
    Property Value
    Type
    System.String

    FirstFormulaTokens

    Declaration
    public Ptg[] FirstFormulaTokens { get; set; }
    Property Value
    Type
    Ptg[]

    IsEmptyCellAllowed

    True if empty values are permitted by the range data validation. otherwise False.

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

    IsListInFormula

    True if formula contains list of values. otherwise False.

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

    IsPromptBoxPositionFixed

    True if prompt box position is fixed. otherwise False.

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

    IsPromptBoxVisible

    True if prompt box is visible. otherwise False.

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

    IsSuppressDropDownArrow

    True if the drop down arrow is invisible. otherwise False.

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

    ListOfValues

    Gets or sets Array of possible values.

    Declaration
    public string[] ListOfValues { get; set; }
    Property Value
    Type
    System.String[]
    Remarks

    This property should be used when the values in the Data Validation list are entered manually.

    Parent

    Parent object for this object.

    Declaration
    public object Parent { get; }
    Property Value
    Type
    System.Object

    PromptBoxHPosition

    Gets or sets Horizontal position of the prompt box.

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

    PromptBoxText

    Gets or sets the text in the prompt box.

    Declaration
    public string PromptBoxText { get; set; }
    Property Value
    Type
    System.String

    PromptBoxTitle

    Gets or sets the title of the prompt box.

    Declaration
    public string PromptBoxTitle { get; set; }
    Property Value
    Type
    System.String

    PromptBoxVPosition

    Gets or sets Vertical position of the prompt box.

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

    SecondDateTime

    Gets or sets second formula's DateTime value.

    Declaration
    public DateTime SecondDateTime { get; set; }
    Property Value
    Type
    System.DateTime

    SecondFormula

    Gets or sets the value or expression associated with the second part of the data validation.

    Declaration
    public string SecondFormula { get; set; }
    Property Value
    Type
    System.String

    SecondFormulaTokens

    Declaration
    public Ptg[] SecondFormulaTokens { get; set; }
    Property Value
    Type
    Ptg[]

    ShowErrorBox

    True if error dialog is shown. otherwise False. Default value is True.

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

    ShowPromptBox

    True if prompt box is shown. otherwise False. Default value is True.

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

    Methods

    BeginUpdate()

    This method should be called before several updates to the object will take place.

    Declaration
    public override void BeginUpdate()
    Overrides
    CommonWrapper.BeginUpdate()

    EndUpdate()

    This method should be called after several updates to the object took place.

    Declaration
    public override void EndUpdate()
    Overrides
    CommonWrapper.EndUpdate()

    Implements

    ICloneParent
    IDataValidation
    IParentApplication
    IOptimizedUpdate

    Extension Methods

    DateTimeExtension.ToDateTime(Object)
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved