HORIZONTALPAGEBREAKS: Explicit Row Page Breaks (1Bh)
The HORIZONTALPAGEBREAKS record contains a list of explicit row page breaks.
Record Data — BIFF8
Offset | Name | Size | Contents |
|
4 | cbrk | 2 | Number of page breaks |
6 | rgbrk | var | Array of brk structures |
The cbrk field contains the number of page breaks. Each element of the rgbrk structure contains three 2-byte integers: the first specifies the row of the break, the second specifies the starting column, and the third specifies the ending column for the break. All row and column numbers are 1-based, and the breaks occur after the row or column. This array is sorted by row, and then by starting/ending column. No two page breaks may overlap.
Record Data — BIFF7 and earlier
Offset | Name | Size | Contents |
|
4 | cbrk | 2 | Number of page breaks |
6 | rgrw | var | Array of rows |
The cbrk field contains the number of page breaks. The rgrw field is an array of 2-byte integers that specifies rows. Microsoft Excel sets a page break before each row contained in the list of rows in the rgrw field. The rows must be sorted in ascending order.