SUB: Subscriber (91h)

The SUB record contains information about the publisher/subscriber feature. This record can be created only by Microsoft Excel for the Macintosh. However, if Microsoft Excel for any other platform encounters the SUB record in a BIFF file, it leaves the record in the file, unchanged, when the file is saved.

Record Data

Offset

Name

Size

Contents

4

ref

6

Reference structure describing the subscribed area on the worksheet.

10

drwReal

2

Actual number of rows in the subscribed area.

12

dcolReal

2

Actual number of columns in the subscribed area.

14

grbit

2

Option flags.

16

cbAlias

2

Size of rgbAlias.

18

sec

36

Section record associated with the subscribed area.

54

rgbAlias

var

Contents of the alias pointed to by the section record.

var

stz

var

Null-terminated string containing the path of publisher. The first byte is a length byte, which does not count the terminating null byte.


The grbit field contains the option flags listed in the following table.

Offset

Bits

Mask

Name

Contents

0

0

01h

(Reserved)

1

02h

fObj

= 1 if subscribed in the object layer

7–2

FCh

(Reserved)

1

7–0

FFh

(Reserved)