Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
2.1.800 Part 1 Section 18.11.1.8, raf (Revision AutoFormat)
Collapse the table of content
Expand the table of content

2.1.800 Part 1 Section 18.11.1.8, raf (Revision AutoFormat)

For additional notes that apply to this portion of the standard, please see the notes for pivotTableDefinition, §18.10.1.73(s-y) .

a. The standard states that the values of the sheetId attribute are defined by the XML Schema unsignedInt datatype.

Excel restricts the value of this attribute to be at most 32767.

b. In the standard, @autoformatid is defined to be of type unsignedInt with no restrictions.

Office specifies that when in the context of raf and queryTable elements, the value shall be less than 21. In the context of the pivotTableDefinition element, the value shall be less than 21 or greater than 4096 and less than or equal to 4117.

Show:
© 2015 Microsoft