-
Notifications
You must be signed in to change notification settings - Fork 63
/
excel.interfaces.pivotfieldcollectionloadoptions.yml
73 lines (73 loc) · 2.76 KB
/
excel.interfaces.pivotfieldcollectionloadoptions.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
### YamlMime:TSType
name: Excel.Interfaces.PivotFieldCollectionLoadOptions
uid: 'excel!Excel.Interfaces.PivotFieldCollectionLoadOptions:interface'
package: excel!
fullName: Excel.Interfaces.PivotFieldCollectionLoadOptions
summary: Represents a collection of all the PivotFields that are part of a PivotTable's hierarchy.
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
type: interface
properties:
- name: $all
uid: 'excel!Excel.Interfaces.PivotFieldCollectionLoadOptions#$all:member'
package: excel!
fullName: $all
summary: >-
Specifying `$all` for the LoadOptions loads all the scalar properties (e.g.: `Range.address`<!-- -->) but not the
navigational properties (e.g.: `Range.format.fill.color`<!-- -->).
remarks: ''
isPreview: false
isDeprecated: false
syntax:
content: '$all?: boolean;'
return:
type: boolean
- name: id
uid: 'excel!Excel.Interfaces.PivotFieldCollectionLoadOptions#id:member'
package: excel!
fullName: id
summary: 'For EACH ITEM in the collection: ID of the PivotField.'
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'id?: boolean;'
return:
type: boolean
- name: name
uid: 'excel!Excel.Interfaces.PivotFieldCollectionLoadOptions#name:member'
package: excel!
fullName: name
summary: 'For EACH ITEM in the collection: Name of the PivotField.'
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'name?: boolean;'
return:
type: boolean
- name: showAllItems
uid: 'excel!Excel.Interfaces.PivotFieldCollectionLoadOptions#showAllItems:member'
package: excel!
fullName: showAllItems
summary: 'For EACH ITEM in the collection: Determines whether to show all items of the PivotField.'
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'showAllItems?: boolean;'
return:
type: boolean
- name: subtotals
uid: 'excel!Excel.Interfaces.PivotFieldCollectionLoadOptions#subtotals:member'
package: excel!
fullName: subtotals
summary: 'For EACH ITEM in the collection: Subtotals of the PivotField.'
remarks: '\[ [API set: ExcelApi 1.8](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'subtotals?: boolean;'
return:
type: boolean