<sp> (Shape)

This element specifies the existence of a single shape. A shape can either be a preset or a custom geometry, defined using the DrawingML framework. In addition to geometry, each shape can have both visual and non-visual properties attached. Text and corresponding styling information can also be attached to a shape. This shape is specified along with all other shapes within either the shape tree or group shape elements.

Parent Elements

<absSizeAnchor> (§5.8.2.1); <grpSp> (§5.8.2.13); <relSizeAnchor> (§5.8.2.21)

Child Elements

Subclause

<nvSpPr> (Non-Visual Shape Properties)

§5.8.2.19

<spPr> (Shape Properties)

§5.8.2.23

<style> (Shape Style)

§5.8.2.24

<txBody> (Shape Text Body)

§5.8.2.26

Attributes

Description

<fLocksText> (Lock Text)

Specifies whether to allow for the editing of text within this shape when the worksheet on which the shape resides has been protected as defined by SpreadsheetML. This allows for the specifying of locked or "protected" text on a per-shape basis within a spreadsheet document. If this attribute is not specified then a value of 0, or false will be assumed.

example: 
<cdr:relSizeAnchor>
  ..
  <cdr:sp fLocksText="0">
  ..
  </cdr:sp>
  ..
</cdr:relSizeAnchor>

The possible values for this attribute are defined by the XML Schema boolean datatype.

<fPublished> (Publish to Server)

Specifies whether the shape shall be published with the worksheet when sent to the spreadsheet server. This is for use when interfacing with a document server.

example: 
<cdr:relSizeAnchor>
  ..
  <cdr:sp fPublished="0">
  ..
  </cdr:sp>
  ..
</cdr:relSizeAnchor>

The possible values for this attribute are defined by the XML Schema boolean datatype.

<macro> (Reference to Custom Function)
This element specifies the custom function associated with the chart.
example: : A macro script, add-in function, and so on.

The format of this string shall be application-defined, and should be ignored if not understood.

example: 
<cdr:... macro="DoWork()" >

The possible values for this attribute are defined by the XML Schema string datatype.

<textlink> (Text Link)

Specifies whether the text contained within this shape is linked to a cell within the spreadsheet. That is the text within the shape will have the value defined in the referenced spreadsheet cell.

example: 
<cdr:relSizeAnchor>
  ..
  <cdr:sp macro="" textlink="A1">
  ..
  </cdr:sp>
  ..
</cdr:relSizeAnchor>

The possible values for this attribute are defined by the XML Schema string datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Shape">
	<sequence>
	<element name="nvSpPr" type="CT_ShapeNonVisual" minOccurs="1" maxOccurs="1"/>
	<element name="spPr" type="a:CT_ShapeProperties" minOccurs="1" maxOccurs="1"/>
	<element name="style" type="a:CT_ShapeStyle" minOccurs="0" maxOccurs="1"/>
	<element name="txBody" type="a:CT_TextBody" minOccurs="0" maxOccurs="1"/>
	</sequence>
	<attribute name="macro" type="xsd:string" use="optional"/>
	<attribute name="textlink" type="xsd:string" use="optional"/>
	<attribute name="fLocksText" type="xsd:boolean" use="optional" default="true"/>
	<attribute name="fPublished" type="xsd:boolean" use="optional" default="false"/>
</complexType>