2.4.221 Row

The Row record specifies a single row on a sheet.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

rw

colMic

colMac

miyRw

reserved1

unused1

A

B

C

D

E

F

reserved3

ixfe_val

G

H

I

J

rw (2 bytes):  An Rw structure that specifies the row index.

colMic (2 bytes):  An unsigned integer that specifies the zero-based index of the first column that contains a cell populated with data or formatting in the current row. MUST be less than or equal to 255.

colMac (2 bytes):  An unsigned integer that specifies the one-based index of the last column that contains a cell populated with data or formatting in the current row. MUST be less than or equal to 256. If colMac is equal to colMic, this record specifies a row with no CELL records.

miyRw (2 bytes):  An unsigned integer that specifies the row height in twips. If fDyZero is 1, the row is hidden and the value of miyRw specifies the original row height. MUST be greater than or equal to 2 and MUST be less than or equal to 8192.

reserved1 (2 bytes): MUST be zero, and MUST be ignored.

unused1 (2 bytes): Undefined and MUST be ignored.

A - iOutLevel (3 bits):  An unsigned integer that specifies the outline level of the row.

B - reserved2 (1 bit): MUST be zero, and MUST be ignored.

C - fCollapsed (1 bit):  A bit that specifies whether the rows that are one level of outlining deeper than the current row are included in the collapsed outline state.

D - fDyZero (1 bit):  A bit that specifies whether the row is hidden.

E - fUnsynced (1 bit):  A bit that specifies whether the row height was manually set.

F - fGhostDirty (1 bit):  A bit that specifies whether the row was formatted.

reserved3 (1 byte): MUST be 1, and MUST be ignored.

ixfe_val (12 bits):  An unsigned integer that specifies an XF record for the row formatting. See IXFCell for more information. If fGhostDirty is 0, ixfe_val is undefined and MUST be ignored.

G - fExAsc (1 bit):  A bit that specifies whether any cell in the row has a thick top border, or any cell in the row directly above the current row has a thick bottom border. Thick borders are specified by the following enumeration values from BorderStyle: THICK and DOUBLE.

H - fExDes (1 bit):  A bit that specifies whether any cell in the row has a medium or thick bottom border, or any cell in the row directly below the current row has a medium or thick top border. Thick borders are previously specified. Medium borders are specified by the following enumeration values from BorderStyle: MEDIUM, MEDIUMDASHED, MEDIUMDASHDOT, MEDIUMDASHDOTDOT, and SLANTDASHDOT.

I - fPhonetic (1 bit):  A bit that specifies whether the phonetic guide feature is enabled for any cell in this row.

J - unused2 (1 bit): Undefined and MUST be ignored.