1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01105206"><META NAME="lcid" CONTENT="1033"><title>Cell element</title><link rel="stylesheet" type="text/css" href="office10.css"><script type="text/javascript" language="Javascript" src="ExpCollapse.js"></script><script type="text/javascript" language="JavaScript" src="inline.js"></script></head><body><h1>Cell element</h1><p>Defines the properties of a cell in a worksheet.</p><h2>Usage</h2><pre>
<code>
<Cell
ArrayRange="xsd:string"
Formula="xsd:string"
HRef="xsd:string"
Index="xsd:nonNegativeInteger"
MergeAcross="xsd:long"
MergeDown="xsd:long"
StyleID="xsd:IDREF"
c:PasteFormula="[external type]"
/>
</code>
</pre><h2>Element Information</h2><table>
<tr>
<td>
<b class="bterm">Element type</b>
</td>
<td>Anonymous</td>
</tr>
<tr>
<td>
<b class="bterm">Namespace</b>
</td>
<td>urn:schemas-microsoft-com:office:spreadsheet</td>
</tr>
<tr>
<td>
<b class="bterm">Schema name</b>
</td>
<td>XML Spreadsheet 2002</td>
</tr>
</table><h2>Elements and Attributes</h2><h3>Child Elements</h3><p>None.</p><h3>Attributes</h3><table>
<tr>
<th>Attribute</th>
<th>Type</th>
<th>Required</th>
<th>Description</th>
<th>Possible Values</th>
</tr>
<tr>
<td>ArrayRange</td>
<td>xsd:string</td>
<td>optional</td>
<td>Specifies the range of cells to which an array formula applies.</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>Formula</td>
<td>xsd:string</td>
<td>optional</td>
<td>Specifies a formula for a cell.</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>HRef</td>
<td>xsd:string</td>
<td>optional</td>
<td>Specifies a URL to which to which a cell is linked.</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>Index</td>
<td>xsd:nonNegativeInteger</td>
<td>optional</td>
<td>Specifies the column index of a cell.</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>MergeAcross</td>
<td>xsd:long</td>
<td>optional</td>
<td>Specifies the number of adjacent cells to merge with the current cell. The cells to merge will be to the right of the current cell unless the worksheet is set to display left-to-right.</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>MergeDown</td>
<td>xsd:long</td>
<td>optional</td>
<td>Specifies the number of adjacent cells below the current cell that are to be merged with the current cell.</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>StyleID</td>
<td>xsd:IDREF</td>
<td>optional</td>
<td>Contains a reference to an ID attribute previously defined in a Style element. Used to apply that defined style to a cell.</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>c:PasteFormula</td>
<td>external ref</td>
<td>optional</td>
<td>See external namespace.</td>
<td>See external namespace.</td>
</tr>
</table><h2>Definition</h2><pre>
<code>
<xsd:element name="Cell" >
<xsd:complexType mixed="true">
<xsd:sequence>
<xsd:group ref="CellType" />
</xsd:sequence>
<xsd:attribute form="qualified" name="ArrayRange" type="xsd:string" use="optional">
</xsd:attribute>
<xsd:attribute form="qualified" name="Formula" type="xsd:string" use="optional">
</xsd:attribute>
<xsd:attribute form="qualified" name="HRef" type="xsd:string" use="optional">
</xsd:attribute>
<xsd:attribute form="qualified" name="Index" type="xsd:nonNegativeInteger" use="optional">
</xsd:attribute>
<xsd:attribute form="qualified" name="MergeAcross" type="xsd:long" use="optional" default="0">
</xsd:attribute>
<xsd:attribute form="qualified" name="MergeDown" type="xsd:long" use="optional" default="0">
</xsd:attribute>
<xsd:attribute form="qualified" name="StyleID" type="xsd:IDREF" use="optional">
</xsd:attribute>
<xsd:attributeGroup ref="x:XHRefScreenTipGroup" />
<xsd:attribute ref="c:PasteFormula" use="optional" />
</xsd:complexType>
</xsd:element>
</code>
</pre><center><a href="XMLSchemaCopyright_HV01147162.htm">©2003-2004 Microsoft Corporation. All rights reserved.</a>
Permission to copy, display and distribute this document is available at: <a
href="http://r.office.microsoft.com/r/rlidAWSContentRedir?AssetID=XT010988631033&CTT=11&Origin=HV011232471033"
target="_new">http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp</a></center></body></html>
|
