Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Description

Excerpt

A DataValidation object represents a rule for validating data entered in cells. The rule may be applied to a cell or a set of cells. The Workbook class contains several CreateDataValidation methods for creating DataValidation objects. To apply a DataValidation object to a cell or group of cells, use Area.SetDataValidation or Range.SetDataValidation.

...

Name

Description

AllowedType

Excerpt Include
EW8:DataValidation.AllowedTypeEW8:
DataValidation.AllowedType
nopaneltrue

Comparison

Excerpt Include
EW8:DataValidation.ComparisonEW8:
DataValidation.Comparison
nopaneltrue

ErrorAlert

Excerpt Include
EW8:DataValidation.ErrorAlertEW8:
DataValidation.ErrorAlert
nopaneltrue

ErrorAlertStyle

Excerpt Include
EW8:DataValidation.ErrorAlertStyleEW8:
DataValidation.ErrorAlertStyle
nopaneltrue

ErrorAlertTitle

Excerpt Include
EW8:DataValidation.ErrorAlertTitleEW8:
DataValidation.ErrorAlertTitle
nopaneltrue

IgnoreBlanks

Excerpt Include
EW8:DataValidation.IgnoreBlanksEW8:
DataValidation.IgnoreBlanks
nopaneltrue

InputMessage

Excerpt Include
EW8:DataValidation.InputMessageEW8:
DataValidation.InputMessage
nopaneltrue

MinimumValue

Excerpt Include
EW8:DataValidation.MinimumValueEW8:
DataValidation.MinimumValue
nopaneltrue

MaximumValue

Excerpt Include
EW8:DataValidation.MaximumValueEW8:
DataValidation.MaximumValue
nopaneltrue

ShowErrorAlert

Excerpt Include
EW8:DataValidation.ShowErrorAlertEW8:
DataValidation.ShowErrorAlert
nopaneltrue

ShowInputMessage

Excerpt Include
EW8:DataValidation.ShowInputMessageEW8:
DataValidation.ShowInputMessage
nopaneltrue

Title

Excerpt Include
EW8:DataValidation.TitleEW8:
DataValidation.Title
nopaneltrue

UseListDropdown

Excerpt Include
EW8:DataValidation.UseListDropdownEW8:
DataValidation.UseListDropdown
nopaneltrue

...

Name

Description

Clear()

Excerpt Include
EW8:DataValidation.Clear()EW8:
DataValidation.Clear()
nopaneltrue

SetAllowedType(ValidationType, ComparisonType, Object)

Excerpt Include
EW8:DataValidation.SetAllowedType(DataValidation.ValidationType, DataValidation.ComparisonType, Object)EW8:
DataValidation.SetAllowedType(DataValidation.ValidationType, DataValidation.ComparisonType, Object)
nopaneltrue

SetAllowedType(ValidationType, ComparisonType, Object, Object)

Excerpt Include
EW8:DataValidation.SetAllowedType(DataValidation.ValidationType, DataValidation.ComparisonType, Object, Object)EW8:
DataValidation.SetAllowedType(DataValidation.ValidationType, DataValidation.ComparisonType, Object, Object)
nopaneltrue

SetAllowedType(ValidationType, Object)

Excerpt Include
EW8:DataValidation.SetAllowedType(DataValidation.ValidationType, Object)EW8:
DataValidation.SetAllowedType(DataValidation.ValidationType, Object)
nopaneltrue

...

Name

Description

ComparisonType

Excerpt Include
EW8:DataValidation.ComparisonTypeEW8:
DataValidation.ComparisonType
nopaneltrue

ErrorAlertStyleType

Excerpt Include
EW8:DataValidation.ErrorAlertStyleTypeEW8:
DataValidation.ErrorAlertStyleType
nopaneltrue

ValidationType

Excerpt Include
EW8:DataValidation.ValidationTypeEW8:
DataValidation.ValidationType
nopaneltrue