<row> (Row)

§3.3.1.3

'1' if the rows 1 level of outlining deeper than the current row are in the collapsed outline state. It means that the rows which are 1 outline level deeper (numerically higher value) than the current row are currently hidden due to a collapsed outline state.

It is possible for @collapsed to be false and yet still have the rows in question hidden. This can be achieved by having a lower outline level collapsed, thus hiding all the child rows.

<sheetData>
  <row r="6" outlineLevel="3"/>
  <row r="7" outlineLevel="3"/>
  <row r="8" outlineLevel="2"/>
  <row r="9" outlineLevel="1"/>
</sheetData>

<sheetData>
  <row r="6" hidden="1" outlineLevel="3"/>
  <row r="7" hidden="1" outlineLevel="3"/>
  <row r="8" hidden="1" outlineLevel="2"/>
  <row r="9" outlineLevel="1" collapsed="1"/>
</sheetData>

<sheetData>
  <row r="6" hidden="1" outlineLevel="3"/>
  <row r="7" hidden="1" outlineLevel="3"/>
  <row r="8" hidden="1" outlineLevel="2"/>
  <row r="9" hidden="1" outlineLevel="1" collapsed="1"/>
  <row r="10" collapsed="1"/>
</sheetData>

See description of <outlinePr> element's @summaryBelow and @summaryRight attributes for detailed information.

The possible values for this attribute are defined by the XML Schema boolean datatype.

'1' if the row style should be applied.

The possible values for this attribute are defined by the XML Schema boolean datatype.

'1' if the row height has been manually set.

The possible values for this attribute are defined by the XML Schema boolean datatype.

'1' if the row is hidden, e.g., due to a collapsed outline or by manually selecting and hiding a row.

The possible values for this attribute are defined by the XML Schema boolean datatype.

Row height measured in point size. There is no margin padding on row height.

The possible values for this attribute are defined by the XML Schema double datatype.

Outlining level of the row, when outlining is on. See description of <outlinePr> element's @summaryBelow and @summaryRight attributes for detailed information.

The possible values for this attribute are defined by the XML Schema unsignedByte datatype.

'1' if the row should show phonetic.

The possible values for this attribute are defined by the XML Schema boolean datatype.

Row index. Indicates to which row in the sheet this <row> definition corresponds.

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

Index to style record for the row (only applied if customFormat attribute is '1')

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

Optimization only, and not required. Specifies the range of non-empty columns (in the format X:Y) for the block of rows to which the current row belongs. To achieve the optimization, span attribute values in a single block should be the same.

There are 16 rows per block, beginning with the first row.

Note: this is an optimization, and is purely optional. Different span values within the same row block is allowed. Not writing the span value at all is also allowed.

Blank rows are not required to write out span values.

For example, if cells F8, E9, and D10 have data in them and the rest of the sheet is empty, then for those three rows (8,9, and 10), the spans value should each be "4:6":

<sheetData>
  <row r="8" spans="4:6">
    <c r="F8">
      <v>1</v>
    </c>
  </row>
  <row r="9" spans="4:6">
    <c r="E9">
      <v>2</v>
    </c>
  </row>
  <row r="10" spans="4:6">
    <c r="D10">
      <v>3</v>
    </c>
  </row>
</sheetData>

For example, if cells A1 and J10 have data in them and the rest of the sheet is empty, then the rows should be written like this:

<sheetData>
  <row r="1" spans="1:10">
    <c r="A1">
      <v>1</v>
    </c>
  </row>
  <row r="10" spans="1:10">
    <c r="J10">
      <v>2</v>
    </c>
  </row>
</sheetData>

The possible values for this attribute are defined by the ST_CellSpans simple type (§3.18.10).

'1' if any cell in the row has a medium or thick bottom border, or if any cell in the row directly below the current row has a thick top border. When true and @customHeight is false, this flag means that the row height has been adjusted higher by .75 points of the normal style font height. This also means that if the row no longer contains these borders, then the height is automatically re-adjusted down.

This adjustment is in addition to any adjustment of height due to @thickTop.

Medium borders are these enumeration values from the Styles Part:

• mediumDashDotDot

• slantDashDot

• mediumDashDot

• mediumDashed

• medium

• Thick borders are these enumeration values from the Styles Part:

• thick

• double

The possible values for this attribute are defined by the XML Schema boolean datatype.