'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.

Note that in this case, if the lowest level were expanded, the middle level would remain collapsed due to collapsed being true on row 9.

end example]

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

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

customFormat (Custom Format)

'1' if the row style should be applied.

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

customHeight (Custom Height)

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

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

hidden (Hidden)

'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 W3C XML Schema boolean datatype.

ht (Row Height)

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

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

outlineLevel (Outline Level)

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 W3C XML Schema unsignedByte datatype.

ph (Show Phonetic)

'1' if the row should show phonetic.

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

r (Row Index)

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

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

s (Style Index)

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

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

spans (Spans)

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. end note]

Blank rows are not required to write out span values.

[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":

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

thickBot (Thick Bottom)

'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 W3C XML Schema boolean datatype.

thickTop (Thick Top Border)

True if the row has a medium or thick top border, or if any cell in the row directly above the current row has a thick bottom 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 thickBot.

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 W3C XML Schema boolean datatype.

[Note: The W3C XML Schema definition of this element’s content model (CT_Row) is located in §A.2. end note]