This element specifies data associated with objects attached to a spreadsheet. While this element may contain any of the child elements below, only certain combinations are meaningful. The ObjectType attribute determines the type of object the element represents and which subset of child elements is appropriate. Relevant groups are identified for each child element.

[Example: The following defines additional information for a comment. Its edges are anchored to the first and fourth rows and the second and fourth columns. It points to the cell in the first row, first column.

<x:ClientData ObjectType="Note">
<x:MoveWithCells/>
<x:SizeWithCells/>
<x:Anchor>1, 15, 0, 2, 3, 15, 3, 16</x:Anchor>
<x:AutoFill>False</x:AutoFill>
<x:Row>0</x:Row>
<x:Column>0</x:Column>
<x:Visible/>
</x:ClientData>

end example]

[Example: The following defines additional information for a radio button. It is the first in a series of radio buttons and selected by default. The accelerator key is 'A' (65 is the ASCII decimal value for 'A') and it is linked to the cell at column A, row 1 of the first sheet.

<x:ClientData ObjectType=3D"Radio">
<x:SizeWithCells/>
<x:AutoFill>False</x:AutoFill>
<x:AutoLine>False</x:AutoLine>
<x:TextVAlign>Center</x:TextVAlign>
<x:Checked>1</x:Checked>
<x:Accel>65</x:Accel>
<x:FmlaLink>Sheet1!$A$1</x:FmlaLink>
<x:FirstButton/>
</x:ClientData>

end example]

Parent Elements

arc (§6.1.2.1); curve (§6.1.2.3); group (§6.1.2.7); image (§6.1.2.10); line (§6.1.2.12); oval (§6.1.2.13); polyline (§6.1.2.15); rect (§6.1.2.16); roundrect (§6.1.2.17); shape (§6.1.2.19); shapetype (§6.1.2.20)

Child Elements	Subclause
Accel (Primary Keyboard Accelerator)	§6.4.2.1
Accel2 (Secondary Keyboard Accelerator)	§6.4.2.2
Anchor (Anchor)	§6.4.2.3
AutoFill (AutoFill)	§6.4.2.4
AutoLine (AutoLine)	§6.4.2.5
AutoPict (Automatically Size)	§6.4.2.6
AutoScale (Font AutoScale)	§6.4.2.7
Camera (Camera Tool)	§6.4.2.8
Cancel (Cancel Button)	§6.4.2.9
CF (Clipboard Format)	§6.4.2.10
Checked (Checked)	§6.4.2.11
ColHidden (Comment's Column is Hidden)	§6.4.2.13
Colored (Dropdown Color Toggle)	§6.4.2.14
Column (Comment Column Target)	§6.4.2.15
DDE (Dynamic Data Exchange)	§6.4.2.16
Default (Default Button)	§6.4.2.17
DefaultSize (Default Size Toggle)	§6.4.2.18
Disabled (Macro Disable Toggle)	§6.4.2.19
Dismiss (Dismiss Button)	§6.4.2.20
DropLines (Dropdown Maximum Lines)	§6.4.2.21
DropStyle (Dropdown Style)	§6.4.2.22
Dx (Scroll Bar Width)	§6.4.2.23
FirstButton (First Radio Button)	§6.4.2.24
FmlaGroup (Linked Formula - Group Box)	§6.4.2.25
FmlaLink (Linked Formula)	§6.4.2.26
FmlaMacro (Reference to Custom Function)	§6.4.2.27
FmlaPict (Camera Source Range)	§6.4.2.28
FmlaRange (List Items Source Range)	§6.4.2.29
FmlaTxbx (Text Formula)	§6.4.2.30
Help (Help Button)	§6.4.2.31
Horiz (Scroll Bar Orientation)	§6.4.2.32
Inc (Scroll Bar Increment)	§6.4.2.33
JustLastX (Far East Alignment Toggle)	§6.4.2.34
LCT (Callback Type)	§6.4.2.35
ListItem (Non-linked List Item)	§6.4.2.36
Locked (Lock Toggle)	§6.4.2.37
LockText (Text Lock)	§6.4.2.38
MapOCX (Embedded Control)	§6.4.2.39
Max (Scroll Bar Maximum)	§6.4.2.40
Min (Scroll Bar Minimum)	§6.4.2.41
MoveWithCells (Move with Cells)	§6.4.2.42
MultiLine (Multi-line)	§6.4.2.43
MultiSel (Multiple Selections)	§6.4.2.44
NoThreeD (Disable 3D)	§6.4.2.45
NoThreeD2 (Disable 3D)	§6.4.2.46
Page (Scroll Bar Page Increment)	§6.4.2.47
PrintObject (Print Toggle)	§6.4.2.48
RecalcAlways (Recalculation Toggle)	§6.4.2.49
Row (Comment Row Target)	§6.4.2.50
RowHidden (Comment's Row is Hidden)	§6.4.2.51
ScriptExtended (HTML Script Attributes)	§6.4.2.52
ScriptLanguage (HTML Script Language)	§6.4.2.53
ScriptLocation (HTML Script Location)	§6.4.2.54
ScriptText (HTML Script Text)	§6.4.2.55
SecretEdit (Password Edit)	§6.4.2.56
Sel (Selected Entry)	§6.4.2.57
SelType (Selection Type)	§6.4.2.58
SizeWithCells (Resize with Cells)	§6.4.2.59
TextHAlign (Horizontal Text Alignment)	§6.4.2.60
TextVAlign (Vertical Text Alignment)	§6.4.2.61
UIObj (UI Object Toggle)	§6.4.2.62
Val (Scroll bar position)	§6.4.2.63
ValidIds (Valid ID)	§6.4.2.64
Visible (Comment Visibility Toggle)	§6.4.2.65
VScroll (Vertical Scroll)	§6.4.2.66
VTEdit (Validation Type)	§6.4.2.67
WidthMin (Minimum Width)	§6.4.2.68

Attributes

Description

ObjectType (Object type)

Specifies the type of the object. Different sets of child elements are appropriate for different types of objects.

The possible values for this attribute are defined by the ST_ObjectType simple type (§6.4.3.2).

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

</choice>

</complexType>