Xl97: BIFF Records Documentation Error in MS Excel 97 Developer's Kit (184647)


The information in this article applies to:

  • Microsoft Office XP Developer
  • Microsoft Office 2000 Developer
  • MSPRESS Microsoft Excel 97 Developer's Kit ISBN 1-57231-498-2
This article was previously published under Q184647

SUMMARY

In the "BIFF Records: Record Number Order" table on pages 275-280 of the "Microsoft Excel 97 Developer's Kit," the record type number designations for several record types are not correct. In addition, other records are missing, and the last entries for the table are incomplete.

This article contains the known errors and the correct values for these record types.

MORE INFORMATION

The correct record number and names are listed in the following table 

   Record    Correct   Record
   number    number    name
   ----------------------------------------------------------------------

    85h       85h      BOUNDSHEET is shown in BiffView.exe as BUNDLESHEET.
   218h       18h      NAME: Defined Name
   231h       31h      FONT: Font Description
   223h       23h      EXTERNNAME: Externally referenced name
   406h        6h      FORMULA: Cell Format
The record numbers that are missing are listed in the following table. 
   Record    Record
   number    name
   ------------------

   1Bh   rtEntExU
   E5h   rtMergeCells
The last six entries in the table that is ordered alphabetically by record name at the top of page 275 do not list the record number. The correct numbers are listed in the following table: 
   Record                                           Record
   name                                             number
   -------------------------------------------------------

   WRITEACCESS: Write Access User Name                 5Ch
   WRITEPROT: Workbook is Write-Protected              86h
   WSBOOL: Additional Workspace Information            81h
   XCT: CRN Record Count                               59h
   XF: Extended Format                                 E0h
   XL5MODIFY: Flag for DSF                            162h

REFERENCES

Microsoft Excel 97 Developer's Kit, Microsoft Press, ISBN 1-57231-498-2
Modification Type:MinorLast Reviewed:2/21/2005
Keywords:kbprb KB184647
©2004 Microsoft Corporation. All rights reserved.