TExportDataValidation

Description

TExportDataValidation stores the information about data validation of a cell.

Properties

NameTypeDescription
DataTypeTExportDataValidationDataTypeType of data validation:
  • edtAnyValue - every value is allowed (no data validation)
  • edtInteger - value must be an integer number.
  • edtDecimal - value must be a number.
  • edtList - only a list of values from cell range specified in Limit1AsFormula is allowed. Also, you can define a string list separated with a colon (,) for valid values instead of cell range.
  • edtDate - value must be a date.
  • edtTime - value must be a time.
  • edtTextLength - the text length of the cell content is used for limit evaluation.
  • edtFormula - use a formula in Limit1AsFormula that returns true for a valid cell or false for an invalid cell.
ErrorStyleTExportDataValidationErrorStyleUsed when ShowErrorBox = true - specify the error message box style: eesStop, eesWarning, eesInfo.
AllowEmptyCellsBooleanDefine if empty cells are valid or not.
ShowListDropDownBooleanOnly for DataType = edtList. If true, a list box with valid values will be shown.
ShowPromptBoxBooleanShow an information message box when cell is selected.
ShowErrorBoxBooleanShow an error message box when an invalid value is typed into the cell.
PromptBoxTitle
PromptBoxText
OWideStringTitle and text of information message box (ShowPromptBox).
ErrorBoxTitle
ErrorBoxText
OWideStringTitle and text of error message box (ShowErrorBox).
ConditionTExportConditionType of condition:
  • ecEqual: cell value is equal to Limit1.
  • ecNotEqual: cell value is not equal to Limit1.
  • ecGreaterThan: cell value is greater than Limit1.
  • ecLessThan: cell value is less than Limit1.
  • ecGreaterEqual: cell value is greater than or equal to Limit1.
  • ecLessEqual: cell value is less than or equal to Limit1.
  • ecBetween: cell value is between Limit1 and Limit2.
  • ecNotBetween: cell value is not between Limit1 and Limit2.
Limit1AsFormulaOWideStringLimit1 as formula string.
Limit2AsFormulaOWideStringLimit2 as formula string.
Limit1AsNumberDoubleLimit1 as number.
Limit2AsNumberDoubleLimit2 as number.
Categories