Syncfusion.XlsIO.Base
Properties 

Syncfusion.XlsIO Namespace : IDataValidation Interface

IDataValidation Interface Members

The following tables list the members exposed by IDataValidation.

Public Properties
 NameDescription
 PropertyGets or sets the data type validation for a range. AllowType is allows the data with restricted Datatypes or Rules using ExcelDataType enumeration.  
 Property Gets the application object. (Inherited from Syncfusion.XlsIO.IParentApplication)
 PropertyGets or sets the comparison operation to perform. CompareOperator for Data Validation works with ExcelDataValidationComparisonOperator enumeration and two formula values.  
 Property Gets or sets the Range of possible values. The list of DataRange cell values are set as dropdown list of DataValidation Range.  
 Property Gets or sets the error message in the error dialog. The user being alerted whenever enters an invalid data. The errorbox text can be edit based on the validation.  
 Property Gets or sets the title of the error dialog. The errorbox title can be edit based on validation or user's needs.  
 PropertyGets or sets the type of error. Using ExcelDataValidationComparisonOperator enumeration we can change the Style/Type of an ErrorBox in ErrorStyle property.  
 Property Gets or sets the first formula's DateTime value. FirstDateTime must important to validate data in CompareOperator property.  
 Property Gets or sets the value or expression associated with the data validation. Firstformula must important to validate data in CompareOperator property.  
 Property True if empty values are permitted by the range data validation. otherwise False.  
 Property True if formula contains list of values. otherwise False.  
 Property True if prompt box position is fixed. otherwise False.  
 Property True if prompt box is visible. otherwise False.  
 Property True if the drop down arrow is invisible. otherwise False.  
 Property Gets or sets Array of possible values. The values of ListOfValues property must be in string format.  
 Property Gets the parent object. (Inherited from Syncfusion.XlsIO.IParentApplication)
 Property Gets or sets Horizontal position of the prompt box.  
 Property Gets or sets the text in the prompt box. The prompt box text can be edit based on the validation.  
 Property Gets or sets the title of the prompt box. The prompt box title can be edit based on the validation.  
 Property Gets or sets Vertical position of the prompt box.  
 Property Gets or sets second formula's DateTime value. SecondDateTime must important to validate data in CompareOperator property.  
 Property Gets or sets the value or expression associated with the second part of the data validation. Second formula used only when CompareOperator have a value "Between"/"NotBetween";  
 Property True if error dialog is shown. otherwise False. Default value is True.  
 Property True if prompt box is shown. otherwise False. Default value is True.  
Top
See Also