-
Notifications
You must be signed in to change notification settings - Fork 64
/
excel.autofilltype.yml
135 lines (111 loc) · 4.84 KB
/
excel.autofilltype.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
123
124
125
126
127
128
129
130
131
132
133
134
135
### YamlMime:TSEnum
name: Excel.AutoFillType
uid: 'excel!Excel.AutoFillType:enum'
package: excel!
fullName: Excel.AutoFillType
summary: The behavior types when AutoFill is used on a range in the workbook.
remarks: >-
\[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
#### Examples
```TypeScript
// Link to full sample:
https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/42-range/range-auto-fill.yaml
await Excel.run(async (context) => {
const sheet = context.workbook.worksheets.getActiveWorksheet();
const sumCell = sheet.getRange("K4");
// Copy only the formatting, not the values and formulas.
sumCell.autoFill("K4:K7", Excel.AutoFillType.fillFormats);
sumCell.format.autofitColumns();
await context.sync();
});
```
isPreview: false
isDeprecated: false
fields:
- name: fillCopy
uid: 'excel!Excel.AutoFillType.fillCopy:member'
package: excel!
summary: |-
Populates the adjacent cells with data based on the selected data.
* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"FillCopy"'
- name: fillDays
uid: 'excel!Excel.AutoFillType.fillDays:member'
package: excel!
summary: >-
A version of "FillSeries" for dates that bases the pattern on either the day of the month or the day of the week,
depending on the context.
* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"FillDays"'
- name: fillDefault
uid: 'excel!Excel.AutoFillType.fillDefault:member'
package: excel!
summary: |-
Populates the adjacent cells based on the surrounding data (the standard AutoFill behavior).
* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"FillDefault"'
- name: fillFormats
uid: 'excel!Excel.AutoFillType.fillFormats:member'
package: excel!
summary: |-
Populates the adjacent cells with the selected formats.
* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"FillFormats"'
- name: fillMonths
uid: 'excel!Excel.AutoFillType.fillMonths:member'
package: excel!
summary: |-
A version of "FillSeries" for dates that bases the pattern on the month.
* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"FillMonths"'
- name: fillSeries
uid: 'excel!Excel.AutoFillType.fillSeries:member'
package: excel!
summary: |-
Populates the adjacent cells with data that follows a pattern in the copied cells.
* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"FillSeries"'
- name: fillValues
uid: 'excel!Excel.AutoFillType.fillValues:member'
package: excel!
summary: |-
Populates the adjacent cells with the selected values.
* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"FillValues"'
- name: fillWeekdays
uid: 'excel!Excel.AutoFillType.fillWeekdays:member'
package: excel!
summary: |-
A version of "FillSeries" for dates that bases the pattern on the day of the week and only includes weekdays.
* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"FillWeekdays"'
- name: fillYears
uid: 'excel!Excel.AutoFillType.fillYears:member'
package: excel!
summary: |-
A version of "FillSeries" for dates that bases the pattern on the year.
* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"FillYears"'
- name: flashFill
uid: 'excel!Excel.AutoFillType.flashFill:member'
package: excel!
summary: |-
Populates the adjacent cells by using Excel's Flash Fill feature.
* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"FlashFill"'
- name: growthTrend
uid: 'excel!Excel.AutoFillType.growthTrend:member'
package: excel!
summary: >-
A version of "FillSeries" for numbers that fills out the values in the adjacent cells according to a growth trend
model.
* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"GrowthTrend"'
- name: linearTrend
uid: 'excel!Excel.AutoFillType.linearTrend:member'
package: excel!
summary: >-
A version of "FillSeries" for numbers that fills out the values in the adjacent cells according to a linear trend
model.
* \[ [API set: ExcelApi 1.9](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"LinearTrend"'