[Table of Contents] [docx version]
VML Reference Material - VML
It is possible to attach user interface controls, such as comments, combo boxes (dropdowns) and embedded controls, to a SpreadsheetML document. is used to define certain aspects of the control, such as size and visual appearance. Additional information describing the control must also be included. The SpreadsheetML Drawing namespace provides the additional information necessary to define the type, settings and behavior of the control.
[Note: The format is a legacy format originally introduced with Office 2000 and is included and fully defined in this Standard for backwards compatibility reasons. The DrawingML format is a newer and richer format created with the goal of eventually replacing any uses of in the Office Open XML formats. should be considered a deprecated format included in Office Open XML for legacy reasons only and new applications that need a file format for drawings are strongly encouraged to use preferentially DrawingML .end note]
[Example: Assume the comment below exists on a spreadsheet:
The following defines the additional information necessary to describe the comment. The ObjectType attribute describes the object as a comment. The element defines that its edges are anchored to the first and fourth rows and the second and fourth columns. The and elements indicate that it points to the cell in the first row, first column.
<v:shape id="_x0000_s1025" type="#_x0000_t202" style='position:absolute;margin
style:tight' fillcolor="#ffffe1" o:insetmode="auto">
<v: on="t" color="black" obscured="t"/>
<x: ObjectType="Note"> … </x:>