Defines the properties of a cell in a worksheet.
<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]"
/>
Element type | Anonymous |
Namespace | urn:schemas-microsoft-com:office:spreadsheet |
Schema name | XML Spreadsheet 2002 |
None.
Attribute | Type | Required | Description | Possible Values |
---|---|---|---|---|
ArrayRange | xsd:string | optional | Specifies the range of cells to which an array formula applies. | See external namespace. |
Formula | xsd:string | optional | Specifies a formula for a cell. | See external namespace. |
HRef | xsd:string | optional | Specifies a URL to which to which a cell is linked. | See external namespace. |
Index | xsd:nonNegativeInteger | optional | Specifies the column index of a cell. | See external namespace. |
MergeAcross | xsd:long | optional | 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. | See external namespace. |
MergeDown | xsd:long | optional | Specifies the number of adjacent cells below the current cell that are to be merged with the current cell. | See external namespace. |
StyleID | xsd:IDREF | optional | Contains a reference to an ID attribute previously defined in a Style element. Used to apply that defined style to a cell. | See external namespace. |
c:PasteFormula | external ref | optional | See external namespace. | See external namespace. |
<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>