Table of Contents

BiffRecordType Enum

Definition

Namespace
Bodu.IO.Biff
Assembly
Bodu.IO.Biff.dll
Package
Bodu.IO.Biff 1.0.0
Source
BiffRecordType.cs

Identifies the BIFF record types the codec names. Values are the 16-bit record identifiers defined by the Excel binary file format and are shared by BIFF5 and BIFF8 except where a member's documentation says otherwise.

public enum BiffRecordType : ushort
Extension Methods

Fields

None = 0

The value reported when no record is current.

Formula = 6

Formula cell: row, column, format index, the cached result, and the parsed-expression tokens.

Eof = 10

End of a substream.

CalcCount = 12

Iteration count for circular references.

CalcMode = 13

Calculation mode.

Precision = 14

Whether values are calculated with displayed precision.

RefMode = 15

Reference style (A1 or R1C1).

Delta = 16

Iteration convergence delta.

Iteration = 17

Whether iteration is enabled.

Protect = 18

Sheet or workbook protection flag.

Password = 19

Protection password hash.

Header = 20

Print header text.

Print footer text.

ExternSheet = 23

External sheet references.

Name = 24

Defined name (Lbl).

WindowProtect = 25

Window protection flag.

VerticalPageBreaks = 26

Manual vertical page breaks.

HorizontalPageBreaks = 27

Manual horizontal page breaks.

Note = 28

Cell note (comment).

Selection = 29

Current selection.

DateMode = 34

Date system: whether serial dates count from 1904 rather than 1900.

ExternName = 35

External name.

PrintHeaders = 42

Whether row and column headers are printed.

PrintGridlines = 43

Whether gridlines are printed.

FilePass = 47

File-pass record: the workbook is encrypted or obfuscated.

Font = 49

Font description.

Continue = 60

Continuation of the preceding record's payload.

Window1 = 61

Workbook window position and options.

Backup = 64

Whether a backup is written on save.

Pane = 65

Window pane split positions.

CodePage = 66

Code page used by byte strings in the stream.

DefColWidth = 85

Default column width.

Obj = 93

Drawing object.

WriteAccess = 92

Name of the user who last saved the workbook.

SaveRecalc = 95

Whether the workbook is recalculated before saving.

ColInfo = 125

Column width, format, and outline settings for a run of columns.

Guts = 128

Outline guttering.

WsBool = 129

Sheet-level option flags.

GridSet = 130

Whether the print-gridlines option has been changed.

HCenter = 131

Whether the sheet is centered horizontally when printed.

VCenter = 132

Whether the sheet is centered vertically when printed.

BoundSheet = 133

Bound-sheet directory entry: a sheet's name, visibility, type, and substream position.

Country = 140

Locale and default country codes.

HideObj = 141

Object display mode.

Palette = 146

Workbook color palette.

Scl = 160

Sheet zoom level.

Setup = 161

Page setup.

MulRk = 189

A run of adjacent RK-encoded number cells in one row.

MulBlank = 190

A run of adjacent blank (formatted, valueless) cells in one row.

Mms = 193

Add-in manager record count.

RString = 214

Rich-text label cell (BIFF5; superseded by the shared string table in BIFF8).

DbCell = 215

Row-block cell offsets used for random access.

BookBool = 218

Workbook boolean options.

Xf = 224

Extended format (XF): a cell or style format, including its number-format and font indices.

InterfaceHdr = 225

Start of the user-interface header block.

InterfaceEnd = 226

End of the user-interface header block.

MergeCells = 229

Merged cell ranges.

Sst = 252

Shared string table (BIFF8 only): the workbook's pooled, deduplicated text values.

LabelSst = 253

Label cell whose value is an index into the shared string table (BIFF8 only).

ExtSst = 255

Hash table over the shared string table (BIFF8 only).

Dimensions = 512

Sheet dimensions: the used row and column extent.

Blank = 513

Blank cell: a formatted cell carrying no value.

Number = 515

Number cell: an IEEE 754 double-precision value.

Label = 516

Label cell: an inline (non-shared) text value.

BoolErr = 517

Boolean or error cell.

String = 519

The cached string result of the preceding Formula record.

Row = 520

Row properties: extent, height, format, and outline settings.

Biff3Bof = 521

Beginning-of-file record of a BIFF3 stream; not supported, recognized so the failure is reported as a version mismatch rather than malformed data.

Index = 523

Row-block index used for random access.

Array = 545

Array formula.

DefaultRowHeight = 549

Default row height.

Table = 566

Data table (what-if) formula.

Window2 = 574

Sheet window options.

Rk = 638

RK cell: a number in the compact 30-bit RK encoding.

Style = 659

Cell style.

Biff4Bof = 1033

Beginning-of-file record of a BIFF4 stream; not supported, recognized so the failure is reported as a version mismatch rather than malformed data.

Format = 1054

Number format: a format index and its format code string.

ShrFmla = 1212

Shared formula.

Bof = 2057

Beginning of a substream: BIFF version, substream type, and build information.

UsesElfs = 352

Whether the workbook uses natural-language formulas (BIFF8 only).

SupBook = 430

External workbook link (BIFF8 only).

Prot4Rev = 431

Shared-workbook protection flag (BIFF8 only).

Txo = 438

Text object (BIFF8 only).

RefreshAll = 439

Whether external links are refreshed on open (BIFF8 only).

Hyperlink (BIFF8 only).

CodeName = 442

Sheet or workbook code name (BIFF8 only).

Prot4RevPass = 444

Shared-workbook protection password (BIFF8 only).

Biff2Bof = 9

Beginning-of-file record of a BIFF2 stream; not supported, recognized so the failure is reported as a version mismatch rather than malformed data.

Remarks

The enumeration is a curated catalogue, not the full record set: a record whose identifier is not listed here is still readable through RecordId and ValueSpan, and can be written through WriteRecord(ushort, scoped ReadOnlySpan<byte>). Encountering an unlisted identifier is never an error.

Applies to

ProductVersions
.NET8, 10