[Table of Contents] [docx version]

Error! No text of specified style in document.

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

absSizeAnchor5.8.2.1); grpSp5.8.2.13); relSizeAnchor5.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: Consider the following shape that does not have locked text on.

<cdr:relSizeAnchor>

..

<cdr:sp fLocksText="0">

..

</cdr:sp>

..

</cdr:relSizeAnchor>

end example]

 

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: Consider the following shape that will not be published with the worksheet when it is published back on the spreadsheet server.

<cdr:relSizeAnchor>

..

<cdr:sp fPublished="0">

..

</cdr:sp>

..

</cdr:relSizeAnchor>

end example]

 

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. end example]

 

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

 

[Example:

 

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

 

end example]

 

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: Consider the following shape with text linked to cell A1.

<cdr:relSizeAnchor>

..

<cdr:sp macro="" textlink="A1">

..

</cdr:sp>

..

</cdr:relSizeAnchor>

end example]

 

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>