-
Notifications
You must be signed in to change notification settings - Fork 63
/
excel.calculationtype.yml
54 lines (42 loc) · 1.66 KB
/
excel.calculationtype.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
### YamlMime:TSEnum
name: Excel.CalculationType
uid: 'excel!Excel.CalculationType:enum'
package: excel!
fullName: Excel.CalculationType
summary: ''
remarks: >-
\[ [API set: ExcelApi 1.1](/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/50-workbook/workbook-calculation.yaml
await Excel.run(async (context) => {
context.application.calculate(Excel.CalculationType.recalculate);
await context.sync();
});
```
isPreview: false
isDeprecated: false
fields:
- name: full
uid: 'excel!Excel.CalculationType.full:member'
package: excel!
summary: |-
This will mark all cells as dirty and then recalculate them.
* \[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Full"'
- name: fullRebuild
uid: 'excel!Excel.CalculationType.fullRebuild:member'
package: excel!
summary: |-
This will rebuild the full dependency chain, mark all cells as dirty and then recalculate them.
* \[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"FullRebuild"'
- name: recalculate
uid: 'excel!Excel.CalculationType.recalculate:member'
package: excel!
summary: >-
Recalculates all cells that Excel has marked as dirty, that is, dependents of volatile or changed data, and cells
programmatically marked as dirty.
* \[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]
value: '"Recalculate"'