Excel.Interfaces.DataValidationData interface
Warning
This API is now deprecated.
An interface describing the data returned by calling dataValidation.toJSON()
.
Properties
error |
Error alert when user enters invalid data. |
ignore |
Specifies if data validation will be performed on blank cells. Default is |
prompt | Prompt when users select a cell. |
rule | Data validation rule that contains different type of data validation criteria. |
type | Type of the data validation, see |
valid | Represents if all cell values are valid according to the data validation rules. Returns |
Property Details
errorAlert
Warning
This API is now deprecated.
Error alert when user enters invalid data.
errorAlert?: Excel.DataValidationErrorAlert;
Property Value
Remarks
ignoreBlanks
Warning
This API is now deprecated.
Specifies if data validation will be performed on blank cells. Default is true
.
ignoreBlanks?: boolean;
Property Value
boolean
Remarks
prompt
Warning
This API is now deprecated.
Prompt when users select a cell.
prompt?: Excel.DataValidationPrompt;
Property Value
Remarks
rule
Warning
This API is now deprecated.
Data validation rule that contains different type of data validation criteria.
rule?: Excel.DataValidationRule;
Property Value
Remarks
type
Warning
This API is now deprecated.
Type of the data validation, see Excel.DataValidationType
for details.
type?: Excel.DataValidationType | "None" | "WholeNumber" | "Decimal" | "List" | "Date" | "Time" | "TextLength" | "Custom" | "Inconsistent" | "MixedCriteria";
Property Value
Excel.DataValidationType | "None" | "WholeNumber" | "Decimal" | "List" | "Date" | "Time" | "TextLength" | "Custom" | "Inconsistent" | "MixedCriteria"
Remarks
valid
Warning
This API is now deprecated.
Represents if all cell values are valid according to the data validation rules. Returns true
if all cell values are valid, or false
if all cell values are invalid. Returns null
if there are both valid and invalid cell values within the range.
valid?: boolean;
Property Value
boolean
Remarks
Office Add-ins