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) | |