Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
2.1.770 Part 1 Section 18.10.1.62, pageField (Page Field)
Collapse the table of content
Expand the table of content

2.1.770 Part 1 Section 18.10.1.62, pageField (Page Field)

a. The standard does not state the default for the item attribute.

In Office, if the item attribute is not specified it means that all items will be used if non-OLAP and pivotField@multipleItemSelectionAllowed is false.

b. The standard says @index specifies the index of the item in the PivotCache.

In Office, @item specifies the index of an item in the pivotField referred to by @fld. If present, @item shall be a valid index of an item element and shall specify how to filter this field in the PivotTable.

c. The standard does not mention limitations on @hier value.

In Office, if @hier is present and the PivotTable is an OLAP PivotTable then the number of pivotHierarchies shall be greater than 0, and @hier must be >=0 and < the number of pivotHierarchies. For a non-OLAP PivotTable, @hier must be -1.

d. The standard does not specify limits on length of the name attribute.

Office requires that the length of the name attribute be less than or equal to 255 if pivotTableDefinition@createdVersion is less than 3, and less than or equal to 32767 if pivotTableDefinition@createdVersion is greater than or equal to 3.

e. The standard does not state limits on string length of @cap.

Office specifies that the length of @cap shall be less than or equal to 255 if pivotTableDefinition@createdVersion is less than 3, and less than or equal to 32767 if pivotTableDefinition@createdVersion is greater than or equal to 3.

f. The standard does not specify restrictions on @fld.

In Office, @fld must be greater than or equal to 0 and less than the number of pivotField elements on the PivotTable. Additionally, the pivotField referred to must have an axis attribute set to axisPage.

g. The standard does not specify limits on when the item attribute shall be present.

In Office, the item attribute shall not be present for OLAP PivotTables, or if pivotField@multipleItemSelectionAllowed is true. In those cases the filtering will be determined by the settings on the pivotField and/or pivotHierarchy.

h. The standard does not define when the name attribute will be present.

Office requires the name attribute for OLAP PivotTables.

i. The standard describes page fields as allowing filtering to display data for a single item or all the items.

Office additionally assumes that using settings on a pivotField or pivotHierarchy filtering can be done for multiple items in a field used as a page or report filter.

j. The standard does not state that the name attribute is affected by the multipleItemSelectionAllowed attribute.

In Office, if pivotHierarchy@multipleItemSelectionAllowed equals 0, the name attribute specifies the member used for filtering. Otherwise, it is ignored.

k. The standard states that @name specifies the unique name of the hierarchy.

Office assumes that @name specifies the member unique name of the OLAP member being displayed.

Show:
© 2015 Microsoft