-
Notifications
You must be signed in to change notification settings - Fork 62
/
excel.interfaces.rangeupdatedata.yml
122 lines (122 loc) · 5.2 KB
/
excel.interfaces.rangeupdatedata.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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
### YamlMime:TSType
name: Excel.Interfaces.RangeUpdateData
uid: 'excel!Excel.Interfaces.RangeUpdateData:interface'
package: excel!
fullName: Excel.Interfaces.RangeUpdateData
summary: 'An interface for updating data on the Range object, for use in `range.set({ ... })`<!-- -->.'
remarks: ''
isPreview: false
isDeprecated: false
type: interface
properties:
- name: columnHidden
uid: 'excel!Excel.Interfaces.RangeUpdateData#columnHidden:member'
package: excel!
fullName: columnHidden
summary: >-
Represents if all columns in the current range are hidden. Value is `true` when all columns in a range are hidden.
Value is `false` when no columns in the range are hidden. Value is `null` when some columns in a range are hidden
and other columns in the same range are not hidden.
remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'columnHidden?: boolean;'
return:
type: boolean
- name: format
uid: 'excel!Excel.Interfaces.RangeUpdateData#format:member'
package: excel!
fullName: format
summary: 'Returns a format object, encapsulating the range''s font, fill, borders, alignment, and other properties.'
remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'format?: Excel.Interfaces.RangeFormatUpdateData;'
return:
type: '<xref uid="excel!Excel.Interfaces.RangeFormatUpdateData:interface" />'
- name: formulas
uid: 'excel!Excel.Interfaces.RangeUpdateData#formulas:member'
package: excel!
fullName: formulas
summary: 'Represents the formula in A1-style notation. If a cell has no formula, its value is returned instead.'
remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'formulas?: any[][];'
return:
type: 'any[][]'
- name: formulasLocal
uid: 'excel!Excel.Interfaces.RangeUpdateData#formulasLocal:member'
package: excel!
fullName: formulasLocal
summary: >-
Represents the formula in A1-style notation, in the user's language and number-formatting locale. For example, the
English "=SUM(A1, 1.5)" formula would become "=SUMME(A1; 1,5)" in German. If a cell has no formula, its value is
returned instead.
remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'formulasLocal?: any[][];'
return:
type: 'any[][]'
- name: formulasR1C1
uid: 'excel!Excel.Interfaces.RangeUpdateData#formulasR1C1:member'
package: excel!
fullName: formulasR1C1
summary: 'Represents the formula in R1C1-style notation. If a cell has no formula, its value is returned instead.'
remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'formulasR1C1?: any[][];'
return:
type: 'any[][]'
- name: numberFormat
uid: 'excel!Excel.Interfaces.RangeUpdateData#numberFormat:member'
package: excel!
fullName: numberFormat
summary: >-
Represents Excel's number format code for the given range. For more information about Excel number formatting, see
[Number format
codes](https://support.microsoft.com/office/number-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68)<!-- -->.
remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'numberFormat?: any[][];'
return:
type: 'any[][]'
- name: rowHidden
uid: 'excel!Excel.Interfaces.RangeUpdateData#rowHidden:member'
package: excel!
fullName: rowHidden
summary: >-
Represents if all rows in the current range are hidden. Value is `true` when all rows in a range are hidden. Value
is `false` when no rows in the range are hidden. Value is `null` when some rows in a range are hidden and other
rows in the same range are not hidden.
remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'rowHidden?: boolean;'
return:
type: boolean
- name: values
uid: 'excel!Excel.Interfaces.RangeUpdateData#values:member'
package: excel!
fullName: values
summary: >-
Represents the raw values of the specified range. The data returned could be a string, number, or boolean. Cells
that contain an error will return the error string. If the returned value starts with a plus ("+"), minus ("-"),
or equal sign ("="), Excel interprets this value as a formula.
remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'values?: any[][];'
return:
type: 'any[][]'