Share via

2.6.157 CT_Array

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2017/richdata2

Referenced by: CT_ArrayData

This element specifies the properties of a single rich array.

Child Elements:

v: A CT_ArrayValue element that specifies a data type and value in the rich array. If the c attribute is not present, then the total number of CT_ArrayValue elements MUST be equal to the r attribute. If the c attribute is present, then the total number of CT_ArrayValue elements MUST be equal to the r attribute multiplied by the c attribute.

Certain data types indicate that the value represents an index as described in the table below.

Value

Meaning

"a"

The CT_ArrayValue identifies a rich array. This is a zero-based index. This index MUST reference a CT_Array that comes before the current CT_Array in the list specified in CT_ArrayData (section 2.6.158).

"r"

The CT_ArrayValue identifies a CT_RichValue specified in section 2.6.175. This is a zero-based index. This index MUST reference a CT_RichValue that comes before the CT_RichValue that contains the current CT_Array in the list specified in CT_RichValueData (section 2.6.177).

Attributes:

r: An unsignedInt ([XMLSCHEMA2/2] section 3.3.22) attribute that specifies the number of rows for the rich array. This number MUST be less than or equal to 1048576.

c: An unsignedInt ([XMLSCHEMA2/2] section 3.3.22) attribute that specifies the number of columns for the array. This number MUST be less than or equal to 16384.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_Array">
   <xsd:sequence>
     <xsd:element name="v" minOccurs="1" maxOccurs="unbounded" type="CT_ArrayValue"/>
   </xsd:sequence>
   <xsd:attribute name="r" type="xsd:unsignedInt" use="required"/>
   <xsd:attribute name="c" type="xsd:unsignedInt" use="optional" default="1"/>
 </xsd:complexType>

See section 5.20 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).