DataValidationArray Class

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
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: Syncfusion.XlsIO.Implementation
Assembly: Syncfusion.XlsIO.Base.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
Syncfusion.XlsIO.Parser.Biff_Records.Formula.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
Syncfusion.XlsIO.Parser.Biff_Records.Formula.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

EndUpdate()

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

Declaration
public override void EndUpdate()
Overrides

Implements