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.