TDataValidationInfo Class

Contains the information to define a data validation in a range of cells.

Syntax

Namespace: FlexCel.Core

public class TDataValidationInfo: IComparable

Constructors

Name Description
TDataValidationInfo Overloaded
 TDataValidationInfo
TDataValidationInfo(TDataValidationDataType, TDataValidationConditionType, String, String, Boolean, Boolean, Boolean, Boolean, String, String, Boolean, String, String, TDataValidationIcon)

Methods

Name Description
CompareTo Compares the object with other.
Equals Returns true if both objects are equal.
GetHashCode Returns a hashcode for the object.

Operators

Name Description
Equality Returns true if both objects are equal.
Note this is for backwards compatibility, this is a class and not immutable, so this method should return true if references are different. But that would break old code.
Inequality Returns true if both objects are not equal.
Note this is for backwards compatibility, this is a class and not immutable, so this method should return true if references are different. But that would break old code.
GreaterThan Returns true if o1 is bigger than o2.
LessThan Returns true if o1 is less than o2.

Properties

Name Description
ValidationType Type of validation we will be doing.
Condition Condition used to apply the data validation.
FirstFormula Formula for the first condition of the data validation. The text of the formula is limited to 255 characters.
If ExplicitList is true, this formula can contain a list of values.

Note that with relative references, we always consider "A1" to be the cell where the data validation is. This means that the formula: "=$A$1 + A1" when evaluated in Cell B8, will read "=$A$1 + B8". To provide a negative offset, you need to wrap the formula.
For example "=A1048575" will evaluate to B7 when evaluated in B8.
SecondFormula Formula for the second condition of the data validation, if it has two conditions. The text of the formula is limited to 255 characters.

Note that with relative references, we always consider "A1" to be the cell where the data validation is. This means that the formula: "=$A$1 + A1" when evaluated in Cell B8, will read "=$A$1 + B8". To provide a negative offset, you need to wrap the formula.
For example "=A1048575" will evaluate to B7 when evaluated in B8.
IgnoreEmptyCells If true Empty cells will not trigger data validation errors.
InCellDropDown When the ValidationType parameter is a list, this property indicates whether to display a drop down box or not.
ExplicitList If true, FirstFormula contains a list of values.
In this case, Formula1 must be a formula of the type: ="string", where string is a list of values separated by Character(0).
For example, in C# Formula1 could be: ="​Apples\0Lemmons\0Melons In Delphi.NET, Formula1 could be: '="Apples' + #0 + 'Lemmons' + #0 + 'Melons'
ShowErrorBox If true, an error box dialog will be shown when the user enters an invalid value.
ErrorBoxCaption Caption of the Error Alert box. Note that this text cannot be longer than 32 characters.
Extra characters will be truncated. If this parameter is null, the default Error alert will be displayed.
If ShowErrorBox is false, this parameter does nothing.
ErrorBoxText Text on the Error Alert box. Note that this text cannot be longer than 225 characters.
Extra characters will be truncated. If this parameter is null, the default Error alert will be displayed.
If ShowErrorBox is false, this parameter does nothing.
ShowInputBox If true, a box showing a message will be shown when the user selecte the cell.
InputBoxCaption Caption of the Input Message box. Note that this text cannot be longer than 32 characters.
Extra characters will be truncated. If this parameter is null, the Input box will display the default message.
if ShowInputBox is false, this parameter does nothing.
InputBoxText Text on the Input Message box. Note that this text cannot be longer than 255 characters.
Extra characters will be truncated. If this parameter is null, the Input box will display the default message.
if ShowInputBox is false, this parameter does nothing.
ErrorIcon Icon to display in the error box.
ImeMode The IME (input method editor) mode enforced by this data validation.