-
Notifications
You must be signed in to change notification settings - Fork 63
/
excel.interfaces.datavalidationdata.yml
90 lines (90 loc) · 3.71 KB
/
excel.interfaces.datavalidationdata.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
### YamlMime:TSType
name: Excel.Interfaces.DataValidationData
uid: 'excel!Excel.Interfaces.DataValidationData:interface'
package: excel!
fullName: Excel.Interfaces.DataValidationData
summary: An interface describing the data returned by calling `dataValidation.toJSON()`<!-- -->.
remarks: ''
isPreview: false
isDeprecated: false
type: interface
properties:
- name: errorAlert
uid: 'excel!Excel.Interfaces.DataValidationData#errorAlert:member'
package: excel!
fullName: errorAlert
summary: Error alert when user enters invalid data.
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'errorAlert?: Excel.DataValidationErrorAlert;'
return:
type: '<xref uid="excel!Excel.DataValidationErrorAlert:interface" />'
- name: ignoreBlanks
uid: 'excel!Excel.Interfaces.DataValidationData#ignoreBlanks:member'
package: excel!
fullName: ignoreBlanks
summary: Specifies if data validation will be performed on blank cells. Default is `true`<!-- -->.
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'ignoreBlanks?: boolean;'
return:
type: boolean
- name: prompt
uid: 'excel!Excel.Interfaces.DataValidationData#prompt:member'
package: excel!
fullName: prompt
summary: Prompt when users select a cell.
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'prompt?: Excel.DataValidationPrompt;'
return:
type: '<xref uid="excel!Excel.DataValidationPrompt:interface" />'
- name: rule
uid: 'excel!Excel.Interfaces.DataValidationData#rule:member'
package: excel!
fullName: rule
summary: Data validation rule that contains different type of data validation criteria.
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'rule?: Excel.DataValidationRule;'
return:
type: '<xref uid="excel!Excel.DataValidationRule:interface" />'
- name: type
uid: 'excel!Excel.Interfaces.DataValidationData#type:member'
package: excel!
fullName: type
summary: 'Type of the data validation, see `Excel.DataValidationType` for details.'
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: >-
type?: Excel.DataValidationType | "None" | "WholeNumber" | "Decimal" | "List" | "Date" | "Time" | "TextLength" |
"Custom" | "Inconsistent" | "MixedCriteria";
return:
type: >-
<xref uid="excel!Excel.DataValidationType:enum" /> | "None" | "WholeNumber" | "Decimal" | "List" | "Date" |
"Time" | "TextLength" | "Custom" | "Inconsistent" | "MixedCriteria"
- name: valid
uid: 'excel!Excel.Interfaces.DataValidationData#valid:member'
package: excel!
fullName: valid
summary: >-
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.
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'valid?: boolean;'
return:
type: boolean