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

This article was previously published under Q184647
This article has been archived. It is offered "as is" and will no longer be updated.
In the "BIFF Records: Record Number Order" table on pages 275-280 of the"Microsoft Excel 97 Developer's Kit," the record type number designationsfor several record types are not correct. In addition, other records aremissing, and the last entries for the table are incomplete.

This article contains the known errors and the correct values for theserecord types.
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 recordname at the top of page 275 do not list the record number. The correctnumbers 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				
Microsoft Excel 97 Developer's Kit, Microsoft Press, ISBN 1-57231-498-2
file format binary

Article ID: 184647 - Last Review: 02/21/2014 00:29:13 - Revision: 3.3

  • Microsoft Office XP Developer Edition
  • Microsoft Office 2000 Developer Edition
  • MSPRESS Microsoft Excel 97 Developer's Kit ISBN 1-57231-498-2
  • kbnosurvey kbarchive kbprb KB184647