2.3.35 CT_Table

  • Article

Referenced by: CT_Worksheet

A range represented in tabular format. This element contains information about the following range:

  • If the NamedRange attribute (2) on the parent CT_Worksheet element is false, the range represented is the range specified in [MS-EXSPWS3] CommandParameter VisibleSheetRangeRequest parameter sent by the protocol client.

  • If the NamedRange attribute (2) on the parent CT_Worksheet element is true, the range represented is the intersection of the range specified in [MS-EXSPWS3] CommandParameter VisibleSheetRangeRequest parameter and the range defined on the named object.

Child Elements:

Column: This element represents one or more columns (2) in the range represented by the CT_Table element. There MUST be one element for every column (2) or collection of contiguous columns (2) that have identical hidden status, outline level and width. The entries for this element MUST be ordered according to the column indices.

Row: This element represents one or more rows in the range represented by the CT_Table element. There MUST be one element for every row or collection of contiguous hidden rows. The entries for this element MUST be ordered according to the row (2) indices.

Attributes:

LastNonEmptyRow: The value of this attribute (2) MUST be the greater of the following two values:

  • The last visible row in the worksheet or the named object containing a worksheet cell that has data or formatting.

  • The last visible row in the range specified in [MS-EXSPWS3] CommandParameter VisibleSheetRangeRequest parameter sent by the protocol client.

LastNonEmptyColumn: The value of this attribute (2) MUST be the greater of the following two values:

  • The last visible column (2) in the worksheet or the named object containing a worksheet cell that has data or formatting.

  • The last visible column (2) in the range specified in [MS-EXSPWS3] CommandParameter VisibleSheetRangeRequest parameter sent by the protocol client.

CurrentFirstRow: The value of this attribute (2) MUST be one of the following values:

  • If the NamedRange attribute (2) in the parent CT_Worksheet element is false, this attribute (2) represents the index of the first visible row in the range specified in [MS-EXSPWS3] CommandParameter VisibleSheetRangeRequest parameter sent by the protocol client.

  • If the NamedRange attribute (2) in the parent CT_Worksheet element is true, this attribute (2) represents the index of the first visible row in the intersection of the range specified in [MS-EXSPWS3] CommandParameter VisibleSheetRangeRequest parameter sent by the protocol client and the range defined on the named object.

FirstVisibleRow: The value of this attribute (2) MUST be one of the following values:

§ If the NamedRange attribute (2) in the parent CT_Worksheet element is false, this attribute (2) represents the index of the first visible row in the worksheet.

§ If the NamedRange attribute (2) in the parent CT_Worksheet element is true, this attribute (2) represents the index of the first visible row in the range defined on the named object.

CurrentFirstRowVisibleOffset: The number of visible rows between the first row in the worksheet and CurrentFirstRow, including the first row in the worksheet if it is visible but not including CurrentFirstRow.

LastVisibleRow: The value of this attribute (2) MUST be one of the following values:

§ If the NamedRange attribute (2) in the parent CT_Worksheet element is false, this attribute (2) represents the index of the last visible row in the worksheet.

§ If the NamedRange attribute (2) in the parent CT_Worksheet element is true, this attribute (2) represents the index of the last visible row in the range defined on the named object.

CurrentFirstColumn: The value of this attribute (2) MUST be one of the following values:

§ If the NamedRange attribute (2) in the parent CT_Worksheet element is false, this attribute (2) represents the index of the first visible column (2) in the range specified in [MS-EXSPWS3] CommandParameter VisibleSheetRangeRequest parameter sent by the protocol client.

§ If the NamedRange attribute (2) in the parent CT_Worksheet element is true, this attribute (2) represents the index of the first visible column (2) in the intersection of the range specified in [MS-EXSPWS3] CommandParameter VisibleSheetRangeRequest parameter sent by the protocol client and the range defined on the named object.

FirstVisibleColumn: The value of this attribute (2) MUST be one of the following values:

  • If the NamedRange attribute (2) in the parent CT_Worksheet element is false, this attribute (2) represents the index of the first visible column (2) in the worksheet.

  • If the NamedRange attribute (2) in the parent CT_Worksheet element is true, this attribute (2) represents the index of the first visible column (2) in the range defined on the named object.

CurrentFirstColumnVisibleOffset: The number of visible columns (2) between the first column in the worksheet and CurrentFirstColumn, including the first column (2) in the worksheet if it is visible but not including CurrentFirstColumn.

LastVisibleColumn: The value of this attribute (2) MUST be one of the following values:

  • If the NamedRange attribute (2) in the parent CT_Worksheet element is false, this attribute (2) represents the index of the last visible column (2) in the worksheet.

  • If the NamedRange attribute (2) in the parent CT_Worksheet element is true, this attribute (2) represents the index of the last visible column (2) in the range defined on the named object.

DefaultRowHeight: The default height of a row in points.

DefaultColumnWidth: The default width of a column (2), in points.

DefaultIndentWidth: The default vertical indent or horizontal indent used for rendering cell contents for worksheet cells with vertical text or horizontal text respectively, in points.

SelectionTop: The index of the row that has the active cell. This attribute (2) MUST have a value other than 0 if all the following conditions are true:

  • The NamedRange attribute (2) in CT_Worksheet is false.

  • The worksheet has an active cell.

  • There are one or more visible rows (2) in the worksheet.

  • There are one or more visible columns (2) in the worksheet.

  • The row index of the active cell is greater than or equal to the value of the FirstVisibleRow attribute (2).

  • The row index of the active cell is less than or equal to the value of the LastVisibleRow attribute (2).

  • The column index of the active cell is greater than or equal to the value of the FirstVisibleColumn attribute (2).

  • The column index of the active cell is less than or equal to the value of the LastVisibleColumn attribute (2).

It MUST NOT be present or have a value of 0 otherwise.

SelectionLeft: The index of the column (2) which has the active cell. This attribute (2) MUST have a value other than 0 if all the following conditions are true:

  • The NamedRange attribute (2) in CT_Worksheet is false.

  • The worksheet has an active cell.

  • There are one or more visible rows (2) in the worksheet.

  • There are one or more visible columns (2) in the worksheet.

  • The row index of the active cell is greater than or equal to the value of the FirstVisibleRow attribute (2).

  • The row index of the active cell is less than or equal to the value of the LastVisibleRow attribute (2).

  • The column index of the active cell is greater than or equal to the value of the FirstVisibleColumn attribute (2).

  • The column index of the active cell is less than or equal to the value of the LastVisibleColumn attribute (2).

It MUST NOT be present or have a value of 0 otherwise.

summaryRight: Specifies whether the summary of a set of grouped columns (2) is displayed to the right of the grouped data. When this attribute (2) is set to true, it denotes that the summary of a set of grouped columns (2) is displayed to the right of grouped data. This attribute (2) MUST be present and set to false if outlines are visible on the worksheet and the summary of grouped columns (2) in the worksheet is displayed to the left of the grouped columns (2).

summaryBelow: Specifies whether the summary of a set of grouped rows (2) is displayed below the grouped data. When this attribute (2) is set to true, it denotes that the summary of a set of grouped rows (2) is displayed below the grouped data. This attribute (2) MUST be present and set to false if outlines are visible on the worksheet and the summary of grouped rows (2) in the worksheet is displayed above the grouped rows (2).

outlineLevelCol: The maximum number of outline levels of outlining in a set of grouped columns (2) within the range represented by the Table element. This attribute (2) MUST be present if outlines are visible on the worksheet and there are one or more grouped columns (2) in the range represented by the CT_Table element.

outlineLevelRow: The maximum number of outline levels of outlining in a set of grouped rows within the range represented by the Table element. This attribute (2) MUST be present if outlines are visible on the worksheet and there are one or more grouped rows in the range represented by the CT_Table element.

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

 <xs:complexType name="CT_Table">
   <xs:sequence>
     <xs:element name="Column" minOccurs="0" maxOccurs="16384" type="CT_ColumnAxisItem"/>
     <xs:element name="Row" minOccurs="0" maxOccurs="1048576" type="CT_RowAxisItem"/>
   </xs:sequence>
   <xs:attribute name="LastNonEmptyRow" type="ST_excelRowNumber1Based" use="required"/>
   <xs:attribute name="LastNonEmptyColumn" type="ST_excelColNumber1Based" use="required"/>
   <xs:attribute name="CurrentFirstRow" type="ST_excelRowNumber1Based" use="required"/>
   <xs:attribute name="FirstVisibleRow" type="ST_excelRowNumber1Based" use="required"/>
   <xs:attribute name="CurrentFirstRowVisibleOffset" type="ST_excelRowNumber" default="0" use="optional"/>
   <xs:attribute name="LastVisibleRow" type="ST_excelRowNumber1Based" default="1048576" use="optional"/>
   <xs:attribute name="CurrentFirstColumn" type="ST_excelColNumber1Based" use="required"/>
   <xs:attribute name="FirstVisibleColumn" type="ST_excelColNumber1Based" use="required"/>
   <xs:attribute name="CurrentFirstColumnVisibleOffset" type="ST_excelColNumber" default="0" use="optional"/>
   <xs:attribute name="LastVisibleColumn" type="ST_excelColNumber1Based" default="16384" use="optional"/>
   <xs:attribute name="DefaultRowHeight" default="12.75" use="optional" type="ST_DefaultRowHeight"/>
   <xs:attribute name="DefaultColumnWidth" default="48" use="optional" type="ST_DefaultColumnWidth"/>
   <xs:attribute name="DefaultIndentWidth" type="xs:double" default="9" use="optional"/>
   <xs:attribute name="SelectionTop" default="0" use="optional" type="ST_SelectionTop"/>
   <xs:attribute name="SelectionLeft" default="0" use="optional" type="ST_SelectionLeft"/>
   <xs:attribute name="summaryRight" type="xs:boolean" default="true" use="optional"/>
   <xs:attribute name="summaryBelow" type="xs:boolean" default="true" use="optional"/>
   <xs:attribute name="outlineLevelCol" type="ST_excelOutlineLevels" use="optional" default="0"/>
   <xs:attribute name="outlineLevelRow" type="ST_excelOutlineLevels" use="optional" default="0"/>
 </xs:complexType>

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