Class DataValidationWrapper
Wrapper over DataValidationImpl class.
Namespace: Syncfusion.XlsIO.Implementation
Assembly: Syncfusion.XlsIO.UWP.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.