Cell element

Defines the properties of a cell in a worksheet.

Usage

      
<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 Information

Element type Anonymous
Namespace urn:schemas-microsoft-com:office:spreadsheet
Schema name XML Spreadsheet 2002

Elements and Attributes

Child Elements

None.

Attributes

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.

Definition

      
<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>


    
©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