Name | Description | |
---|---|---|
![]() | add | Overloaded. Adds data validation to the specified range. |
![]() | delete | Deletes the object. |
![]() | fromJson | Generates the data validation from the json string. |
![]() | getAlertStyle | Gets the validation alert style. |
![]() | getErrorMessage | Gets the data validation error message. |
![]() | getErrorTitle | Gets the title of the data-validation error dialog box. |
![]() | getFormula1 | Gets the value or expression associated with the conditional format or data validation. Can be a constant value, a string value, a cell reference, or a formula. |
![]() | getFormula2 | Gets the value or expression associated with the second part of a conditional format or data validation. |
![]() | getIgnoreBlank | Gets whether blank values are permitted by the data range validation. |
![]() | getIMEMode | Gets the description of the Japanese input rules. |
![]() | getInCellDropdown | Gets whether data validation displays a drop-down list that contains acceptable values. |
![]() | getInputMessage | Gets the data validation input message. |
![]() | getInputTitle | Gets the title of the data-validation input dialog box. |
![]() | getOperator | Gets the operator for the conditional format or data validation. |
![]() | getShowError | Gets whether the data validation error message will be displayed whenever the user enters invalid data. |
![]() | getShowInputMessage | Gets whether the data validation input message is displayed whenever the user selects a cell in the data validation range. |
![]() | getType | Gets the data type validation for a range. |
![]() | getValue | Gets whether all the validation criteria are met (that is, if the range contains valid data). |
![]() | setAlertStyle | Sets the validation alert style. |
![]() | setErrorMessage | Sets the data validation error message. |
![]() | setErrorTitle | Sets the title of the data-validation error dialog box. |
![]() | setFormula1 | Sets the value or expression associated with the conditional format or data validation. Can be a constant value, a string value, a cell reference, or a formula. |
![]() | setFormula2 | Sets the value or expression associated with the second part of a conditional format or data validation. |
![]() | setIgnoreBlank | Sets whether blank values are permitted by the data range validation. |
![]() | setIMEMode | Sets the description of the Japanese input rules. |
![]() | setInCellDropdown | Sets whether data validation displays a drop-down list that contains acceptable values. |
![]() | setInputMessage | Sets the data validation input message. |
![]() | setInputTitle | Sets the title of the data-validation input dialog box. |
![]() | setOperator | Sets the operator for the conditional format or data validation. |
![]() | setShowError | Sets whether the data validation error message will be displayed whenever the user enters invalid data. |
![]() | setShowInputMessage | Sets whether the data validation input message is displayed whenever the user selects a cell in the data validation range. |
![]() | setType | Sets the data type validation for a range. |
![]() | toJson | Generates a json string from the data validation. |