Class DataValidationWrapper

Wrapper over DataValidationImpl class.

Inheritance
System.Object
CommonWrapper
DataValidationWrapper
Inherited Members
Namespace: Syncfusion.XlsIO.Implementation
Assembly: Syncfusion.XlsIO.Portable.dll
Syntax
public class DataValidationWrapper : CommonWrapper, ICloneParent, IInternalDataValidation, IDataValidation, IParentApplication, IOptimizedUpdate

Constructors

DataValidationWrapper(RangeImpl, DataValidationImpl)

Initializes a new instance of the DataValidationWrapper class.

Declaration
public DataValidationWrapper(RangeImpl range, DataValidationImpl wrap)
Parameters
Type Name Description
RangeImpl range
DataValidationImpl wrap

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

Holds first formula tokens.

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

Holds second formula tokens.

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 should be called before several updates to the object will take place.

Declaration
public override void BeginUpdate()
Overrides
Remarks

Invoking this method improves the performance for large block of Data Validation.

EndUpdate()

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

Declaration
public override void EndUpdate()
Overrides
Remarks

Invoking this method improves the performance for large block of Data Validation.

Implements