Namespace Syncfusion.XlsIO.Parser.Biff_Records

Classes

ArrayRecord Summary description for ArrayRecord.

AutoFilterInfoRecord Summary description for AutoFilterInfoRecord.

AutoFilterRecord Summary description for AutoFilterInfoRecord.

AutoFilterRecord.DOPER

BackupRecord Boolean specifying whether the GUI should store a backup of the file while saving.

BeginRecord The begin record defines the start of a block of records for a (Graphing) data object. This record is matched with a corresponding EndRecord.

BiffAttribute Attribute provides link information between class and Biff8. record types

BiffContinueRecordRaw BifRecords container.

BiffOffsetOrderAttribute This attribute tells the Excel Writer the order in which order offsets should be calculated.

BiffOffsetsRecordsAttribute Existence of such attribute in class metadata indicates to the Excel writer that the record class contains offset field which can be calculated only after all records are saved into an array and are in place.

BiffRecordPosAttribute Attribute of records class members that provide information about location of the variable in binary data. It also indicates type to which the data must be converted to.

BiffRecordRawWithArray Summary description for BiffRecordRawWithArray.

BiffRecordRawWithDataProvider Summary description for BiffRecordRawWithDataProvider.

BiffRecordWithContinue Summary description for BiffRecordWithContinue.

BiffRecordWithStreamPos Summary description for _BiffRecordRawWithStreamPos.

BitmapRecord This record is part of the Page Settings Block. It stores the background bitmap of a worksheet.

BlankRecord This record represents an empty cell. It contains the cell address and formatting information.

BOFRecord Summary description for BOFRecord. It is used for the beginning of a set of records that have a particular purpose or subject. Used in sheets and workbooks.

BookBoolRecord Summary description for BookBoolRecord. Saves External Links record. Contains a flag specifying whether the GUI should save externally linked values from other workbooks.

BoolErrRecord This record represents a Boolean value or error value cell.

ByteArrayDataProvider Summary description for ByteArrayDataProvider.

BytesList Summary description for BytesList.

CalcCountRecord Specifies the maximum number of times the formulas should be iteratively calculated. This is a fail-safe against mutually recursive formulas locking up a spreadsheet application.

CalcModeRecord Specifies whether to calculate formulas manually, automatically, or automatically except for multiple table operations.

CellPositionBase This is parent class for all records that have cell position elements inside.

CF12Record The begin record defines the start of a block of records for a (Graphing) data object. This record is matched with a corresponding EndRecord.

CFExAverageTemplateParameter CFEx Average Template Parameter

CFExDateTemplateParameter CFEx Date Template Parameter

CFExFilterParameter Represents CFEx Filter Parameter

CFExRecord The begin record defines the start of a block of records for a (Graphing) data object. This record is matched with a corresponding EndRecord.

CFExTextTemplateParameter CFEx Text Template Parameter

CFGradientItem Specifies one control point in the gradient curve.

CFIconMultiState Specifies the threshold value associated with an icon.

CFIconSet Icon set.

CFInterpolationCurve Specifies one control point in the interpolation curve.

CFRecord The begin record defines the start of a block of records for a (Graphing) data object. This record is matched with a corresponding EndRecord.

CFVO Conditional Formatting Value Object (CFVO).

ChartUnitsRecord Microsoft Excel writes this record, but its value is always zero. Applications writing BIFF do not need to write this record. If the application writes this record, the wUnits field must be zero.

CodeNameRecord Summary description for CodeNameRecord.

CodepageRecord Stores the text encoding (code page) used to encode byte strings. In BIFF8, it always contains the Unicode code page 1200.

ColorScale Color scale.

ColumnInfoRecord Defines the formatting information for a range of columns including width, outline, and collapsed options.

CondFmt12Record The begin record defines the start of a block of records for a (Graphing) data object. This record is matched with a corresponding EndRecord.

CondFMTRecord The begin record defines the start of a block of records for a (Graphing) data object. This record is matched with a corresponding EndRecord.

ContinueRecord Whenever the content of the record exceeds the given limits, the record must be split. Several Continue Records containing the additional data are added after the parent record.

ContinueRecordExtractor Helper class which allows extract continue records from stream.

CountryRecord This record stores two Windows country identifiers. The first represents the user interface language of the Excel version that saved this file, and second represents the system regional settings at the time the file was saved.

CRNRecord This record stores the contents of an external cell or cell range. An external cell range has only one row. If a cell range spans over more than one row, several CRN records will be created.

CustomPropertyRecord Summary description for CustomPropertyRecord.

DataBar Data bar.

DataProvider Summary description for DataProvider.

DateWindow1904Record This record specifies the base date for displaying date values. All dates are stored as count of days past this base date.

DBCellRecord Contains relative offsets to calculate the stream position of the first cell record for each row. This record is written once in a row block.

DConBinRecord This record stores a data consolidation reference. DConBin is identical to DConName, except that DConBin is used when the data consolidation reference refers to a built-in name (as described by a Name record).

DConNameRecord The DConName record contains the complete description of a named range of cells for the Consolidate command (Data menu).

DCONRecord Summary description for DCON.

DConRefRecord Summary description for DConRefRecord.

DefaultColWidthRecord Specifies the default width for columns that have no specific width set.

DefaultRowHeightRecord Row height for rows with undefined or inexplicitly defined heights.

DeltaRecord Stores the maximum change of the result to the exit of an iteration.

DimensionsRecord Contains the range address of the used area in the current sheet.

DSFRecord Double Stream Flag Record indicating if this is a double stream file. Double Stream files contain both BIFF8 and BIFF7 workbooks.

DValRecord This record is the list header of the Data Validity Table in the current sheet.

DVRecord This record is part of the Data Validity Table. It stores data validity settings and a list of cell ranges which contain these settings. The "prompt box" appears while editing such a cell. The "error box" appears if the entered value does not fit the conditions. The data validity settings of a sheet are stored in a sequential list of DV records. This list is preluded by a DVAL record. If a string is empty and the default text should appear in the prompt box or error box, the string must contain a single zero character (string length will be 1).

DXFN Represents DXFN

DxGCol Specifies the default width for columns that have no specific width set.

EndRecord The end record defines the end of a block of records for a (Graphing) data object. This record is matched with a corresponding BeginRecord.

EOFRecord It indicates the end of a record block with leading BOF record. This could be the end of the workbook globals, a worksheet, a chart, etc.

ExtendedFormatCRC This record specifies the number of XF records contained in this file and that contains a checksum of the data in those records. This record MUST exist if and only if there are XFExt records in the file.

ExtendedFormatRecord One of the most complex records. There are two types: Style and Cell. It should be noted that fields in the extended format record are somewhat arbitrary. Almost all of the fields are bit-level, but we name them as best as possible by functional group. In some places, this is more conducive than others.

ExtendedProperty Represents Extended Property

ExtendedXFRecord Represents Extended XF Record

ExternCountRecord This record contains the number of additional EXTERNSHEET records. In BIFF8, this is omitted because there is only one EXTERNSHEET record.

ExternNameRecord

ExternSheetRecord The record stores a list with indexes to SUPBOOK records.

ExternSheetRecord.TREF Stores index to SUPBOOK record.

ExtSSTInfoSubRecord Extended SST table info subrecord contains the elements of "info" in the SST's array field.

FilePassRecord This record is part of the file protection. It contains information about the read/write password of the file. All record contents following this record will be encrypted.

FilePassStandardBlock Summary description for FilePassStandardBlock.

FilePassStrongBlock Summary description for FilePassStrongBlock.

FileSharingRecord The record represents an empty cell. It contains the cell address and formatting information.

FilterModeRecord If the sheet contains a filtered list, the file will contain FilterModeRecord. This record has no record data field.

FnGroupCountRecord Function Group Count Record Number of built in function groups in the current version of the spreadsheet (probably only used in Windows).

FontRecord Font Record describes a font in the workbook (index = 0-3,5-infinity - skip 4) An element in the Font Table contains information about a used font, including character formatting.

FormatRecord Record contains information about a number format.

FormulaRecord Contains the token array and the result of a formula cell.

GradStops Represenst Gradient Stops

GridsetRecord This record specifies if the option to print sheet grid lines (PrintGridlinesRecord) has ever been changed.

GutsRecord Contains information about the layout of outline symbols.

HasBasicRecord If this record exists in the stream, then Excel contains Visual Basic macros.

HeaderAndFooterRecord Represents the Header Footer Record

HeaderContinueRecordBuilder Special class for building Continue Records.

HeaderFooterImageRecord Summary description for HeaderFooterImageRecord.

HeaderFooterRecord Specifies a header for a sheet.

HideObjRecord Flag defines whether to hide placeholders and object.

HLinkRecord The record represents an empty cell. It contains the cell address and formatting information.

HorizontalPageBreaksRecord Contains a list of explicit column page breaks.

HorizontalPageBreaksRecord.THPageBreak This class contains information about single page break.

InterfaceEndRecord Shows where the Interface Records end (MMS) (has no fields).

InterfaceHdrRecord Defines the beginning of Interface records (MMS).

IntPtrContinueRecordBuilder Summary description for IntPtrContinueRecordBuilder.

IntPtrDataProvider Summary description for IntPtrDataProvider.

IterationRecord Tells whether to iterate over formula calculations or not (if a formula is dependent upon another formula's result) (odd feature for something that can only have 32 elements in a formula).

LabelRangesRecord This record contains the addresses of all row and column label ranges in the current sheet.

LabelRecord This record represents a cell that contains a string. In BIFF8, it is replaced by the LABELSST record. Nevertheless, Excel can import a LABEL record contained in a BIFF8 file.

LabelSSTRecord Represents a cell that contains a string. Refers to a string in the shared string table and is a column value.

MarginRecord This record is part of the Page Settings block. It contains the margin of the current worksheet.

MergeCellsRecord Contains all merged cell ranges of the current sheet. Optional record defining a square area of cells to "merge" into one cell.

MergeCellsRecord.MergedRegion This class contains information about the region of merged cells.

MMSRecord Defines how many add menu and delete menu options are stored in the file.

MSODrawingGroupRecord This record contains a drawing object provided by the Drawing tool.

MSODrawingRecord This record contains a drawing object provided by the Microsoft Office Drawing tool.

MulBlankRecord Represents a range of empty cells. All cells are located in the same row.

MulRKRecord Represents a cell range containing RK value cells. All cells are located in the same row.

MulRKRecord.RkRec Contains information about single RK entry in MulRKRecord.

NameRecord The begin record defines the start of a block of records for a (Graphing) data object. This record is matched with a corresponding EndRecord.

NoteRecord The NOTE record specifies a comment associated with a particular cell.

NumberRecord Represents a cell that contains a floating-point value.

ObjectProtectRecord This record is part of the worksheet / workbook protection. It determines whether the objects of the current sheet are protected. Object protection is not active if this record is omitted.

OBJRecord The OBJ record contains a partial description of a drawing object and the MSODRAWING, MSODRAWINGGROUP, and MSODRAWINGSELECTION records contain the remaining drawing object data.

OffsetArrayList

OleSizeRecord This record stores the size of an embedded OLE object (when Microsoft Excel is a server).

PaletteRecord This record contains the definition of all user-defined colors available for cell and object formatting.

PaneRecord

PasswordRecord Stores the encrypted password for a sheet or workbook.

PasswordRev4Record Stores the (2 byte) encrypted password for a shared workbook.

PrecisionRecord Defines whether to store with full precision or what is displayed the GUI.

PrinterSettingsRecord This record saves printer settings and printer driver information.

PrintGridlinesRecord Defines whether or not to print the gridlines when you print your spreadsheet on paper.

PrintHeadersRecord Whether or not to print the row / column headers of the spreadsheet in the physical form.

PrintSetupRecord Stores print setup options.

ProtectionRev4Record Describes whether this is a protected shared / tracked workbook.

ProtectRecord Whether a worksheet or a workbook is protected against modification. Protection is not active if this record is omitted.

QuickTipRecord This record contains the cell range and text for a ToolTip. It occurs in conjunction with the HLINK record for hyperlinks in the Hyperlink Table.

RangeProtectionRecord Represents range protection and error indicators.

RecalcIdRecord This record stores RecalcId identifiers.

RefModeRecord Describes which reference mode to use.

RefreshAllRecord Flag whether to refresh all external data when loading a sheet.

RKRecord Represents a cell that contains an RK value (encoded integer or floating-point value).

RowRecord Stores the row information for the sheet.

RStringRecord This record stores a formatted text cell (Rich-Text). In BIFF8 it is replaced by the LABELSST record. Nevertheless, Excel uses this record if it copies formatted text cells to the clipboard.

SaveRecalcRecord Defines whether to recalculate before saving (set to 1).

ScenProtectRecord This record is part of the worksheet / workbook protection. It determines whether the scenarios of the current sheet are protected. Scenario protection is not active if this record is omitted.

SelectionRecord Shows the user's selection on the sheet for write set num refs to 0.

SharedFormulaRecord This record stores the token array of a shared formula. Shared formulas are similar to array formulas in that they store a formula used in a range of cells. The SharedFormula record is not a real cell record but follows the first FORMULA record of the cell range.

SheetCenterRecord Whether to center between horizontal margins.

SheetLayoutRecord This record stores the colour of the tab below the sheet containing the sheet name.

SheetProtectionRecord Summary description for SheetProtection.

SortRecord This record stores the last settings from the "Sort" dialog for each sheet. These settings are not attached to a cell range in the sheet, so it is not possible to determine the cell range sorted with the settings of this record.

SSTRecord Static String Table Record: This holds all the strings for LabelSSTRecords.

StringRecord This record stores the result of a string formula. It occurs directly after a string formula.

StyleRecord Style Record: Describes a built-in style in the GUI or user defined style.

SupBookRecord This record stores the URL of an external document and a list of sheet names inside this document. Furthermore, it is used to store DDE and OLE object links or to indicate an internal 3D reference or an add-in function.

TabIdRecord Sheet Tab Index Array Record: Contains an array of sheet ID's. Sheets always keep their ID regardless of what their name is.

TableRecord This record stores information about a multiple operation table in the sheet. It follows the first FORMULA record of the cell range containing the operation table.

TemplateRecord

TextObjectRecord This record stores a text object. The TXO record is followed by two CONTINUE records. The first CONTINUE record contains the text data and the second CONTINUE contains the formatting runs. If the text box contains no text, these CONTINUE records are not written to the file.

TextWithFormat Summary description for TextFormat.

UnkMacrosDisable Summary description for UnkMacrosDisable.

UnknownBeginRecord

UnknownEndRecord Represents UnknowEndRecord

UnknownMarkerRecord

UnknownRecord This record describes all unknown information in records.

UnsafeDataProvider Summary description for UnsafeDataProvider.

UseSelFSRecord Informs the GUI if this was written by something that can use "natural language" formulas.

VerticalPageBreaksRecord Contains a list of explicit column page breaks.

VerticalPageBreaksRecord.TVPageBreak Structure that contains information about a vertical page break.

WindowOneRecord Stores the attributes of the workbook window. This is basically so that the GUI is aware of the size of the window holding the spreadsheet document.

WindowProtectRecord Flags indicating whether workbook windows are protected.

WindowTwoRecord Sheet window settings.

WindowZoomRecord This record stores the magnification of the active view of the current worksheet. In BIFF8 this can be either the normal view or the page break preview. This is determined in the WINDOW2 record. The magnification is stored as reduced fraction. The magnification results from nscl / dscl.

WriteAccessRecord Stores the Username of the owner of the spreadsheet generator (on UNIX, it's the user's login; on Windows, it is the name you typed during installation).

WriteProtection This record indicates that write protection is used and read-only mode is recommended.

WSBoolRecord This record stores a 16-bit value with Boolean options for the current sheet.

XCTRecord XCT � CRN Count: This record stores the number of immediately following CRN records. These records are used to store the cell contents of external references.

Structs

PaletteRecord.TColor Structure describing color entry.

RStringRecord.TFormattingRun Rich text formatting run.

SelectionRecord.TAddr Each cell range address (called an ADDR structure) contains 4 16-bit values. Cell range address, BIFF8.

TAddr Each cell range address (called an ADDR structure) contains 4 16-bit values. Cell range address, BIFF8:

Interfaces

IBiffStorage Summary description for IBiffStorage.

ICellPositionFormat

IChartType Contains information about chart type.

IDoubleValue This interface supports DoubleValue property.

IFormulaRecord Summary description for IFormulaRecord.

ILengthSetter Summary description for ILengthSetter.

IMultiCellRecord

IOutline Contains outline information about.

IOutlineWrapper Contains outline information about.

ISharedFormula Interface for shared formula and array formula.

IStringValue This interface supports StringValue property.

IValueHolder Interface for records that have Value property.

Enums

AutoFilterRecord.DOPER.DOPERComparisonSign DOPER comparison sign types.

AutoFilterRecord.DOPER.DOPERDataType DOPER data type.

BOFRecord.TType This enum that describes all possible data after this BOF record.

ExtendedFormatRecord.TXFType Type of extended format.

TBIFFRecord Enum that defines constants for all known Biff records.

TextWithFormat.StringType Possible string flags.

TFieldType Known field types to parser.