<ClientData> (Attached Object Data)

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:
<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>
example:
<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>

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:

<complexType name="CT_ClientData">
	<choice minOccurs="0" maxOccurs="unbounded">
	<element name="MoveWithCells" type="ST_TrueFalseBlank"/>
	<element name="SizeWithCells" type="ST_TrueFalseBlank"/>
	<element name="Anchor" type="xsd:string"/>
	<element name="Locked" type="ST_TrueFalseBlank"/>
	<element name="DefaultSize" type="ST_TrueFalseBlank"/>
	<element name="PrintObject" type="ST_TrueFalseBlank"/>
	<element name="Disabled" type="ST_TrueFalseBlank"/>
	<element name="AutoFill" type="ST_TrueFalseBlank"/>
	<element name="AutoLine" type="ST_TrueFalseBlank"/>
	<element name="AutoPict" type="ST_TrueFalseBlank"/>
	<element name="FmlaMacro" type="xsd:string"/>
	<element name="TextHAlign" type="xsd:string"/>
	<element name="TextVAlign" type="xsd:string"/>
	<element name="LockText" type="ST_TrueFalseBlank"/>
	<element name="JustLastX" type="ST_TrueFalseBlank"/>
	<element name="SecretEdit" type="ST_TrueFalseBlank"/>
	<element name="Default" type="ST_TrueFalseBlank"/>
	<element name="Help" type="ST_TrueFalseBlank"/>
	<element name="Cancel" type="ST_TrueFalseBlank"/>
	<element name="Dismiss" type="ST_TrueFalseBlank"/>
	<element name="Accel" type="xsd:integer"/>
	<element name="Accel2" type="xsd:integer"/>
	<element name="Row" type="xsd:integer"/>
	<element name="Column" type="xsd:integer"/>
	<element name="Visible" type="ST_TrueFalseBlank"/>
	<element name="RowHidden" type="ST_TrueFalseBlank"/>
	<element name="ColHidden" type="ST_TrueFalseBlank"/>
	<element name="VTEdit" type="xsd:integer"/>
	<element name="MultiLine" type="ST_TrueFalseBlank"/>
	<element name="VScroll" type="ST_TrueFalseBlank"/>
	<element name="ValidIds" type="ST_TrueFalseBlank"/>
	<element name="FmlaRange" type="xsd:string"/>
	<element name="WidthMin" type="xsd:integer"/>
	<element name="Sel" type="xsd:integer"/>
	<element name="NoThreeD2" type="ST_TrueFalseBlank"/>
	<element name="SelType" type="xsd:string"/>
	<element name="MultiSel" type="xsd:string"/>
	<element name="LCT" type="xsd:string"/>
	<element name="ListItem" type="xsd:string"/>
	<element name="DropStyle" type="xsd:string"/>
	<element name="Colored" type="ST_TrueFalseBlank"/>
	<element name="DropLines" type="xsd:integer"/>
	<element name="Checked" type="xsd:integer"/>
	<element name="FmlaLink" type="xsd:string"/>
	<element name="FmlaPict" type="xsd:string"/>
	<element name="NoThreeD" type="ST_TrueFalseBlank"/>
	<element name="FirstButton" type="ST_TrueFalseBlank"/>
	<element name="FmlaGroup" type="xsd:string"/>
	<element name="Val" type="xsd:integer"/>
	<element name="Min" type="xsd:integer"/>
	<element name="Max" type="xsd:integer"/>
	<element name="Inc" type="xsd:integer"/>
	<element name="Page" type="xsd:integer"/>
	<element name="Horiz" type="ST_TrueFalseBlank"/>
	<element name="Dx" type="xsd:integer"/>
	<element name="MapOCX" type="ST_TrueFalseBlank"/>
	<element name="CF" type="ST_CF"/>
	<element name="Camera" type="ST_TrueFalseBlank"/>
	<element name="RecalcAlways" type="ST_TrueFalseBlank"/>
	<element name="AutoScale" type="ST_TrueFalseBlank"/>
	<element name="DDE" type="ST_TrueFalseBlank"/>
	<element name="UIObj" type="ST_TrueFalseBlank"/>
	<element name="ScriptText" type="xsd:string"/>
	<element name="ScriptExtended" type="xsd:string"/>
	<element name="ScriptLanguage" type="xsd:nonNegativeInteger"/>
	<element name="ScriptLocation" type="xsd:nonNegativeInteger"/>
	<element name="FmlaTxbx" type="xsd:string"/>
	</choice>
	<attribute name="ObjectType" type="ST_ObjectType" use="required"/>
</complexType>