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
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01105207"><META NAME="lcid" CONTENT="1033"><title>Column 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>Column element</h1><p>Defines the formatting and properties for one or more adjacent columns.</p><h2>Usage</h2><pre>
<code>
<Column
AutoFitWidth="TrueFalseType"
Index="xsd:positiveInteger"
Span="xsd:nonNegativeInteger"
StyleID="xsd:IDREF"
Width="xsd:double"
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><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>AutoFitWidth</td>
<td><a href="sstsiTrueFalseType_HV01105240.htm" id="HV01105240" lcid="">TrueFalseType</a></td>
<td>optional</td>
<td>Specifies whether a column is automatically resized to fit numeric and date values. Columns are not resized to fit text data.</td>
<td><ul><li>0</li><li>1</li></ul></td>
</tr>
<tr>
<td>Index</td>
<td>xsd:positiveInteger</td>
<td>optional</td>
<td>Specifies the position of a column in 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 columns with the same formatting as the defined column.</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 column.</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>Width</td>
<td>Anonymous</td>
<td>optional</td>
<td>Specifies the width of a column in points. This value must be greater than or equal to zero.</td>
<td><p>minInclusive = 0</p></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="Column" minOccurs="0" maxOccurs="unbounded" >
<xsd:complexType>
<xsd:attribute form="qualified" name="AutoFitWidth" type="TrueFalseType" use="optional" default="1">
</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 form="qualified" name="Width" use="optional">
<xsd:simpleType>
<xsd:restriction base="xsd:double">
<xsd:minInclusive value="0" />
</xsd:restriction>
</xsd:simpleType>
</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>
|
