VERTICALPAGEBREAKS: Explicit Column Page Breaks (1Ah)

The VERTICALPAGEBREAKS record contains a list of explicit column 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 column of the break, the second specifies the starting row, and the third specifies the ending row 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 column, and then by starting/ending row. No two page breaks may overlap.

Record Data — BIFF7 and earlier

Offset

Name

Size

Contents

4

cbrk

2

Number of page breaks

6

rgcol

var

Array of columns


The cbrk field contains the number of page breaks. The rgcol field is an array of 2-byte integers that specifies columns. Microsoft Excel sets a page break before each column contained in the list of columns in the rgcol field. The columns must be sorted in ascending order.