DIMENSIONS: Cell Table Size (200h)

The DIMENSIONS record contains the minimum and maximum bounds of the sheet. It provides a concise indication of the sheet size.

Note that both the rwMac and colMac fields are greater by 1 than the actual last row and column. For example, a worksheet that exists between cells B3 and D6 would have the following dimensions in the dimensions record (note rows and columns are 0-based in BIFF files in which row 1 and column A are both coded as 0):

rwMic = 2 — indicates that 3 is the first row

colMic = 1 — indicates that B is the first column

rwMac = 6 — indicates that 6 is the last row

colMac = 4 — indicates that D is the last column

Record Data BIFF8

Offset

Name

Size

Contents

4

rwMic

4

First defined row on the sheet

8

rwMac

4

Last defined row on the sheet, plus 1

12

colMic

2

First defined column on the sheet

14

colMac

2

Last defined column on the sheet, plus 1

16

(Reserved)

2

Reserved; must be 0 (zero)


Record Data BIFF7 and earlier

Offset

Name

Size

Contents

4

rwMic

2

First defined row on the sheet

6

rwMac

2

Last defined row on the sheet, plus 1

8

colMic

2

First defined column on the sheet

10

colMac

2

Last defined column on the sheet, plus 1

12

(Reserved)

2

Reserved; must be 0 (zero)