StyleType complexType
Defines a single style in the current workbook. This element is required for custom formatting; otherwise, it is optional.
Type Information
Namespace
|
urn:schemas-microsoft-com:office:spreadsheet |
Schema name
|
XML Spreadsheet 2002 |
Elements and Attributes
Child Elements
Element |
Description |
Alignment |
Specifies the font alignment attributes to use for cells to which the defined style is applied. |
Borders |
Defines the border properties to use for cells to which the defined style is applied. |
Font |
Defines the font characteristics to use for cells to which the defined style is applied. |
Interior |
Defines the fill properties to use for cells to which the defined style is applied. |
NumberFormat |
Defines the number format to use for cells to which the defined style is applied. |
Protection |
Defines the protection properties of cells to which the defined style is applied. |
Attributes
Attribute |
Type |
Required |
Description |
Possible Values |
ID |
xsd:ID |
required |
Defines a name that identifies a particular style. The special value of "Default" indicates that this style represents the default formatting in the workbook. |
See external namespace. |
Name |
xsd:string |
optional |
Specifies the name for a defined style. Duplicate names for different styles are not permitted. |
See external namespace. |
Parent |
xsd:IDREF |
optional |
Specifies a parent style from which the defined style should inherit format settings. |
See external namespace. |
Definition
<xsd:complexType name="StyleType" >
<xsd:sequence>
<xsd:element name="Alignment" type="AlignmentType" minOccurs="0">
</xsd:element>
<xsd:element name="Borders" type="BordersType" minOccurs="0">
</xsd:element>
<xsd:element name="Font" type="FontType" minOccurs="0">
</xsd:element>
<xsd:element name="Interior" type="InteriorType" minOccurs="0">
</xsd:element>
<xsd:element name="NumberFormat" type="NumberFormatType" minOccurs="0">
</xsd:element>
<xsd:element name="Protection" type="ProtectionType" minOccurs="0">
</xsd:element>
</xsd:sequence>
<xsd:attribute form="qualified" name="ID" type="xsd:ID" use="required">
</xsd:attribute>
<xsd:attribute form="qualified" name="Name" type="xsd:string" use="optional">
</xsd:attribute>
<xsd:attribute form="qualified" name="Parent" type="xsd:IDREF" use="optional">
</xsd:attribute>
</xsd:complexType>
©2003-2004 Microsoft Corporation. All rights reserved.
Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp