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
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01105203"><META NAME="lcid" CONTENT="1033"><title>Alignment 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>Alignment element</h1><p>Specifies the font alignment attributes to use for cells to which the defined style is applied.</p><h2>Usage</h2><pre>
<code>
<Alignment
Horizontal="xsd:string"
ReadingOrder="xsd:string"
Indent="xsd:unsignedLong"
Rotate="xsd:double"
ShrinkToFit="TrueFalseType"
Vertical="xsd:string"
VerticalText="TrueFalseType"
WrapText="TrueFalseType"
/>
</code>
</pre><h2>Element Information</h2><table>
<tr>
<td>
<b class="bterm">Element type</b>
</td>
<td><a href="sstcoAlignmentType_HV01105225.htm" id="HV01105225" lcid="">AlignmentType</a></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="sseleStyles_HV01105221.htm" id="HV01105221" lcid="">Style</a></td>
<td>Defines a single style in the current workbook. This element is required for custom formatting; otherwise, it is optional.</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>Horizontal</td>
<td>Anonymous</td>
<td>optional</td>
<td>Specifies the left-to-right alignment of text within a cell.</td>
<td><ul><li>CenterAcrossSelection</li><li>Fill</li><li>Left</li><li>Right</li><li>Justify</li><li>Distributed</li><li>Center</li><li>Automatic</li><li>JustifyDistributed</li></ul></td>
</tr>
<tr>
<td>ReadingOrder</td>
<td>Anonymous</td>
<td>optional</td>
<td>Specifies the default right-to-left text entry mode for a cell.</td>
<td><ul><li>RightToLeft</li><li>LeftToRight</li><li>Context</li></ul></td>
</tr>
<tr>
<td>Indent</td>
<td>xsd:unsignedLong</td>
<td>optional</td>
<td>Specifies the number of indents. This attribute is not supported by the Spreadsheet component.</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>Rotate</td>
<td>Anonymous</td>
<td>optional</td>
<td>Specifies the rotation of text within a cell.</td>
<td><p>minInclusive = -90</p><p>maxInclusive = 90</p></td>
</tr>
<tr>
<td>ShrinkToFit</td>
<td><a href="sstsiTrueFalseType_HV01105240.htm" id="HV01105240" lcid="">TrueFalseType</a></td>
<td>optional</td>
<td>Specifies whether text size should be shrunk so that all of the text fits within a cell.</td>
<td><ul><li>0</li><li>1</li></ul></td>
</tr>
<tr>
<td>Vertical</td>
<td>Anonymous</td>
<td>optional</td>
<td>Specifies the top-to-bottom alignment of text within a cell.</td>
<td><ul><li>Automatic</li><li>Top</li><li>Bottom</li><li>Center</li><li>Justify</li><li>Distributed</li><li>JustifyDistributed</li></ul></td>
</tr>
<tr>
<td>VerticalText</td>
<td><a href="sstsiTrueFalseType_HV01105240.htm" id="HV01105240" lcid="">TrueFalseType</a></td>
<td>optional</td>
<td>Specifies whether text characters are positioned to read vertically.</td>
<td><ul><li>0</li><li>1</li></ul></td>
</tr>
<tr>
<td>WrapText</td>
<td><a href="sstsiTrueFalseType_HV01105240.htm" id="HV01105240" lcid="">TrueFalseType</a></td>
<td>optional</td>
<td>Specifies whether the text in a cell should wrap at the cell boundary.</td>
<td><ul><li>0</li><li>1</li></ul></td>
</tr>
</table><h2>Definition</h2><pre>
<code>
<xsd:element name="Alignment" type="AlignmentType" minOccurs="0" >
</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>
|
