Share via

2.3.57 CT_RowAxisItem

  • Article

Referenced by: CT_Table

Represents a single row or multiple contiguous hidden rows from the range defined in the parent CT_Table element (section 2.3.35).

Child Elements:

Cell: A worksheet cell that has data or that has formatting applied to it. This element MUST NOT be present if the Hidden attribute is true. If the Hidden attribute is not true, there MUST be an element for every worksheet cell in the row that has data or that has formatting applied to it.

Attributes:

Span: If the element represents more than one row, this attribute denotes the additional number of rows represented by the element. This attribute MUST be present if the Hidden attribute is true and there are more than one contiguous hidden rows. It MUST NOT be present otherwise.

Hidden: Specifies whether the rows are hidden. This attribute MUST be present and set to true if the rows represented by the element are hidden.

NextHidden: Specifies whether the next row is hidden. This attribute MUST be present and set to true if the row immediately following the rows represented by the current CT_RowAxisItem element is hidden.

PrevHidden: Specifies whether the previous row is hidden. This attribute MUST be present and set to true if the row immediately preceding the row(s) represented by the current CT_RowAxisItem element is hidden.

collapsed: If the row represented by this element is part of a group, this attribute denotes whether the outlining at the current outline level is collapsed. This attribute MUST be present and set to true if the Hidden attribute is not true and the row is part of a group and outlining for the outline level of the row is collapsed. It MUST NOT be present otherwise.

outlineLevel: The outline level of the row represented by the current element. This attribute MUST be present if the Hidden attribute is not true and the row is part of a group. It MUST NOT be present otherwise.

adjacentOutlineLevel: The outline level of a row adjacent to the row represented by the current element. This attribute MUST be present and set to the outline level of the previous row if all of the following conditions are met:

  • The current element is the first CT_RowAxisItem (section 2.3.57) element in the parent CT_Table (section 2.3.35) element.

  • The row is not the first row in the worksheet.

  • The Hidden attribute is false and the row is part of a group.

This attribute MUST be present and set to the outlining level of the next row if all of the following conditions are met:

  • The current element is the last CT_RowAxisItem element in the parent CT_Table element.

  • The row is not the last row in the worksheet.

  • The Hidden attribute is false and the row is part of a group.

It MUST NOT be present otherwise.

Index: Index of the row represented by the element. This attribute MUST NOT be present for the first CT_RowAxisItem element in the parent CT_Table element. If it is not the first CT_RowAxisItem element, it MUST be present if the previous CT_RowAxisItem element has a Hidden attribute set to true. It MUST NOT be present otherwise.

Height: Height of the row in points. This attribute MUST be present if the Hidden attribute is not true. It MUST NOT be present otherwise.

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

 <xs:complexType name="CT_RowAxisItem">
   <xs:sequence>
     <xs:element name="Cell" minOccurs="0" maxOccurs="16384" type="CT_Cell"/>
   </xs:sequence>
   <xs:attribute name="Span" use="optional" default="0" type="ST_excelRowNumber"/>
   <xs:attribute name="Hidden" type="xs:boolean" use="optional" default="false"/>
   <xs:attribute name="NextHidden" type="xs:boolean" use="optional" default="false"/>
   <xs:attribute name="PrevHidden" type="xs:boolean" use="optional" default="false"/>
   <xs:attribute name="collapsed" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="outlineLevel" type="ST_excelOutlineLevels" use="optional" default="0"/>
   <xs:attribute name="adjacentOutlineLevel" type="ST_excelOutlineLevels" use="optional" default="0"/>
   <xs:attribute name="Index" type="ST_excelRowNumber1Based" use="optional"/>
   <xs:attribute name="Height" type="ST_rowHeight" use="optional"/>
 </xs:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).