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
133
134
135
136
137
138
139
140
141
142
143
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01105219"><META NAME="lcid" CONTENT="1033"><title>Row 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>Row element</h1><p>Defines the formatting and properties for one or more adjacent rows.</p><h2>Usage</h2><pre>
<code>
<Row
AutoFitHeight="TrueFalseType"
Height="xsd:double"
Index="xsd:positiveInteger"
Span="xsd:nonNegativeInteger"
StyleID="xsd:IDREF"
Hidden="See attribute definition. c:caption="[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>Parent Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="sseleTable_HV01105222.htm" id="HV01105222" lcid="">Table</a></td>
<td>Defines the table to contain the cells of the current worksheet. Only one instance of a Table element is valid for a single worksheet.</td>
</tr>
</table><h3>Child Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="sseleCell_HV01105206.htm" id="HV01105206" lcid="">Cell</a></td>
<td>Defines the properties of a cell in a worksheet.</td>
</tr>
</table><h3>Attributes</h3><table>
<tr>
<th>Attribute</th>
<th>Type</th>
<th>Required</th>
<th>Description</th>
<th>Possible Values</th>
</tr>
<tr>
<td>AutoFitHeight</td>
<td><a href="sstsiTrueFalseType_HV01105240.htm" id="HV01105240" lcid="">TrueFalseType</a></td>
<td>optional</td>
<td>Specifies whether the height of a row is automatically resized to fit the contents of cells.</td>
<td><ul><li>0</li><li>1</li></ul></td>
</tr>
<tr>
<td>Height</td>
<td>Anonymous</td>
<td>optional</td>
<td>Specifies the height of a row in points. This value must be greater than or equal to zero.</td>
<td><p>minInclusive = 0</p></td>
</tr>
<tr>
<td>Index</td>
<td>xsd:positiveInteger</td>
<td>optional</td>
<td>Specifies the position of a row within a table.</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>Span</td>
<td>xsd:nonNegativeInteger</td>
<td>optional</td>
<td>Specifies the number of adjacent rows with the same formatting as the defined row.</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 row.</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>Hidden</td>
<td>None</td>
<td>optional</td>
<td>Specifies whether an element is visible. The Hidden attribute can be applied to the NamedRange, Column, and Row elements.</td>
<td>n/a</td>
</tr>
<tr>
<td>c:caption</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="Row" minOccurs="0" maxOccurs="unbounded" >
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="Cell" minOccurs="0" maxOccurs="unbounded" />
</xsd:sequence>
<xsd:attribute form="qualified" name="AutoFitHeight" type="TrueFalseType" use="optional" default="1">
</xsd:attribute>
<xsd:attribute form="qualified" name="Height" use="optional">
<xsd:simpleType>
<xsd:restriction base="xsd:double">
<xsd:minInclusive value="0" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute ref="Hidden" default="0">
</xsd:attribute>
<xsd:attribute form="qualified" name="Index" type="xsd:positiveInteger" use="optional">
</xsd:attribute>
<xsd:attribute form="qualified" name="Span" type="xsd:nonNegativeInteger" use="optional" default="0">
</xsd:attribute>
<xsd:attribute form="qualified" name="StyleID" type="xsd:IDREF" use="optional">
</xsd:attribute>
<xsd:attribute ref="c:caption" 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>
|
