Share via

2.3.33 CT_Image

  • Article

Referenced by: CT_Images

A worksheet image.

Child Elements:

ChartMetaData: A CT_ChartMetaData element that specifies information about the chart.

This element MUST be present when the Type is chart and MUST NOT be present otherwise.

Attributes:

Id: An identifier for the worksheet image. MUST be unique across all the worksheet images of the workbook.

ImageName: The name of the worksheet image. 

Type: The type of worksheet image.

Version: A unique identifier for the state of the image on the protocol server.

Width: The width of the image in points.

Height: The height of the image in points.

BorderID: A CT_Style describing any borders applied to the worksheet image. If the NamedRange attribute (2) on the CT_Worksheet element is true or if the ChartSheet attribute (2) on the CT_Worksheet element is true, this attribute (2) MUST NOT be present.

ZOrder: The z-order for the worksheet image.

XOriginDelta: The X coordinate in points of the offset of the origin of the worksheet image from the starting column (2) of the requested range.

YOriginDelta: The Y coordinate in points of the offset of the origin of the worksheet image from the starting row of the requested range.

AbsoluteLeft: The X coordinate in points of the offset of the origin of the worksheet image from the origin of the worksheet.

AbsoluteTop:  The Y coordinate in points of the offset of the origin of the worksheet image from the origin of the worksheet.

AbsoluteRight:  The X coordinate in points of the offset of the rightmost edge of the worksheet image from the origin of the worksheet.  In a worksheet with right-to-left reading order, this corresponds to the leftmost edge of the worksheet image.

AbsoluteBottom:  The Y coordinate in points of the offset of the bottom of the worksheet image from the origin of the worksheet.   

ClippedWidth: The width in points of the portion of the image that intersects the requested range.

ClippedHeight: The height in points of the portion of the image that intersects the requested range.

Visible: Specifies whether the worksheet image is a visible worksheet image.

AltText: An alternative text used by the protocol server to provide an error message when the worksheet image is not supported.

LockAspectRatio: Specifies whether the worksheet image ought to maintain the aspect ratio when resized. 

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

 <xs:complexType name="CT_Image">
   <xs:sequence>
     <xs:element name="ChartMetaData" minOccurs="0" maxOccurs="1" type="CT_ChartMetaData"/>
   </xs:sequence>
   <xs:attribute name="Id" type="ST_nonEmptyString" use="required"/>
   <xs:attribute name="ImageName" type="xs:string" use="required"/>
   <xs:attribute name="Type" type="ST_enmImageType" use="optional" default="chart"/>
   <xs:attribute name="Version" type="xs:int" use="required"/>
   <xs:attribute name="Width" type="ST_nonNegativeDouble" use="required"/>
   <xs:attribute name="Height" type="ST_nonNegativeDouble" use="required"/>
   <xs:attribute name="BorderID" type="ST_borderStyleID" use="optional"/>
   <xs:attribute name="ZOrder" type="xs:int" use="required"/>
   <xs:attribute name="XOriginDelta" type="xs:double" default="0" use="optional"/>
   <xs:attribute name="YOriginDelta" type="xs:double" default="0" use="optional"/>
   <xs:attribute name="AbsoluteLeft" type="xs:double" use="required"/>
   <xs:attribute name="AbsoluteTop" type="xs:double" use="required"/>
   <xs:attribute name="AbsoluteRight" type="xs:double" use="required"/>
   <xs:attribute name="AbsoluteBottom" type="xs:double" use="required"/>
   <xs:attribute name="ClippedWidth" type="ST_nonNegativeDouble" default="0" use="optional"/>
   <xs:attribute name="ClippedHeight" type="ST_nonNegativeDouble" default="0" use="optional"/>
   <xs:attribute name="Visible" type="xs:boolean" default="true" use="optional"/>
   <xs:attribute name="AltText" type="xs:string" use="optional"/>
   <xs:attribute name="LockAspectRatio" type="xs:boolean" default="false" use="optional"/>
 </xs:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).