CrnType complexType

Contains a description of formula operands located in another workbook.

Type Information

Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Child Elements

Element Description
Row Specifies the row being referenced.
ColFirst Specifies the column in the referenced row that the referenced area begins with.
ColLast Specifies the column in the referenced row that the referenced area ends with.
Number Contains the data in the referenced cell if the data is numeric.
Text Contains the data in the referenced cell if the data is text.
Boolean Contains a Boolean operand.
Error Contains the data in the referenced cell if the data is an Error data type.

Attributes

None.

Definition

      
<xsd:complexType name="CrnType" >
  <xsd:sequence>
    <xsd:element name="Row" type="RowType">
    </xsd:element>
    <xsd:element name="ColFirst" type="xsd:int">
    </xsd:element>
    <xsd:element name="ColLast" type="xsd:int">
    </xsd:element>
    <xsd:element name="Number" type="xsd:double" minOccurs="0" maxOccurs="unbounded">
    </xsd:element>
    <xsd:element name="Text" type="xsd:string" minOccurs="0">
    </xsd:element>
    <xsd:element name="Boolean" default="False" minOccurs="0">
      <xsd:simpleType>
        <xsd:restriction base="TrueFalseType" />
      </xsd:simpleType>
    </xsd:element>
    <xsd:element name="Error" type="ErrorType" minOccurs="0">
    </xsd:element>
  </xsd:sequence>
</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