2.1.1609 Part 1 Section 21.3.2.22, sp (Shape)

  • Article

a.   The standard states that textlink is a formula linking to spreadsheet cell data.

Excel requires that the value of the textlink attribute be a string referencing a cell or a cell range. This reference should be to a unique cell. Excel accepts a cell range but only considers the first cell in the range.

b.   The standard states that that the minOccurs of child element txBody is 0.

Office requires txBody if textlink is specified. Chart drawing content will not load if txBody is not provided and textlink is valid.

c.   The standard allows attribute fLocksText on a shape in a chart drawing.

Office does not support attribute fLocksText on a shape within a chart drawing.

d.   The standard states that the values of the macro attribute are defined by the XML Schema string datatype.

Office requires that the macro attribute value follow the same grammar as name-references ("[ISO/IEC-29500-1] §18.17.2.5") with a minimum length of 0 characters and a maximum length of 256 characters.