ApiValidation

Represents the ApiValidation class.

Properties

Name	Type	Description
AlertStyle	ValidationAlertStyle	Returns the validation alert style.
ErrorMessage	string	Returns or sets the data validation error message.
ErrorTitle	string	Returns or sets the title of the data-validation error dialog box.
Formula1	string	Returns the value or expression associated with the conditional format or data validation.
Formula2	string	Returns the value or expression associated with the second part of a conditional format or data validation.
IgnoreBlank	boolean	Returns or sets a Boolean value that specifies whether blank values are permitted by the range data validation.
InCellDropdown	boolean	Returns or sets a Boolean value indicating whether data validation displays a drop-down list that contains acceptable values.
InputMessage	string	Returns or sets the data validation input message.
InputTitle	string	Returns or sets the title of the data-validation input dialog box.
Operator	ValidationOperator	Returns the data validation operator.
Parent	ApiRange	Returns the parent range object.
ShowError	boolean	Returns or sets a Boolean value indicating whether the data validation error message will be displayed whenever the user enters invalid data.
ShowInput	boolean	Returns or sets a Boolean value indicating whether the data validation input message will be displayed whenever the user selects a cell in the data validation range.
Type	ValidationType	Returns the validation type.
Value	string	Returns the validation value.

Methods

Method	Returns	Description
Add	ApiValidation | null	Adds data validation to the specified range.
Delete	None	Deletes the object.
GetAlertStyle	ValidationAlertStyle	Returns the validation alert style.
GetErrorMessage	string	Returns the data validation error message.
GetErrorTitle	string	Returns the title of the data-validation error dialog box.
GetFormula1	string	Returns the first formula in the data validation.
GetFormula2	string	Returns the second formula in the data validation.
GetIgnoreBlank	boolean	Returns whether blank values are permitted by the range data validation.
GetInCellDropdown	boolean	Returns whether data validation displays a drop-down list that contains acceptable values.
GetInputMessage	string	Returns the data validation input message.
GetInputTitle	string	Returns the title of the data-validation input dialog box.
GetOperator	ValidationOperator	Returns the data validation operator.
GetParent	ApiRange	Returns the parent range object.
GetShowError	boolean	Returns whether the data validation error message will be displayed.
GetShowInput	boolean	Returns whether the data validation input message will be displayed.
GetType	ValidationType	Returns the validation type.
Modify	ApiValidation | null	Modifies data validation for a range.
SetErrorMessage	None	Sets the data validation error message.
SetErrorTitle	None	Sets the title of the data-validation error dialog box.
SetIgnoreBlank	None	Sets whether blank values are permitted by the range data validation.
SetInCellDropdown	None	Sets whether data validation displays a drop-down list that contains acceptable values.
SetInputMessage	None	Sets the data validation input message.
SetInputTitle	None	Sets the title of the data-validation input dialog box.
SetShowError	None	Sets whether the data validation error message will be displayed.
SetShowInput	None	Sets whether the data validation input message will be displayed.