2.1.809 Part 1 Section 18.11.1.8, raf (Revision AutoFormat)

  • Article

For additional notes that apply to this portion of the standard, please see the notes for pivotTableDefinition, §18.10.1.79(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.