Namespace Syncfusion.XlsIO.Parser.Biff_Records
Classes
ArrayRecord
Summary description for ArrayRecord.
AutoFilterInfoRecord
Summary description for AutoFilterInfoRecord.
AutoFilterRecord
Summary description for AutoFilterInfoRecord.
AutoFilterRecord.DOPER
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.
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.
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.
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).
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.
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.
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.
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.
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.
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.
CustomPropertyRecord
Summary description for CustomPropertyRecord.
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.
DCONRecord
Summary description for DCON.
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).
DConRefRecord
Summary description for DConRefRecord.
DSFRecord
Double Stream Flag Record indicating if this is a double stream file. Double Stream files contain both BIFF8 and BIFF7 workbooks.
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).
DValRecord
This record is the list header of the Data Validity Table in the current sheet.
DXFN
Represents DXFN
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.
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.
DxGCol
Specifies the default width for columns that have no specific width set.
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.
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.
ExtSSTInfoSubRecord
Extended SST table info subrecord contains the elements of "info" in the SST's array field.
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.
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.
HLinkRecord
The record represents an empty cell. It contains the cell address and formatting information.
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.
HorizontalPageBreaksRecord
Contains a list of explicit column page breaks.
HorizontalPageBreaksRecord.THPageBreak
This class contains information about single page break.
IntPtrContinueRecordBuilder
Summary description for IntPtrContinueRecordBuilder.
InterfaceEndRecord
Shows where the Interface Records end (MMS) (has no fields).
InterfaceHdrRecord
Defines the beginning of Interface records (MMS).
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.
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.
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.
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.
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.
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.
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.
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.
PrinterSettingsRecord
This record saves printer settings and printer driver information.
ProtectRecord
Whether a worksheet or a workbook is protected against modification. Protection is not active if this record is omitted.
ProtectionRev4Record
Describes whether this is a protected shared / tracked workbook.
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.
RKRecord
Represents a cell that contains an RK value (encoded integer or floating-point value).
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.
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.
RowRecord
Stores the row information for the sheet.
SSTRecord
Static String Table Record: This holds all the strings for LabelSSTRecords.
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.
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.
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.
WSBoolRecord
This record stores a 16-bit value with Boolean options for the current sheet.
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.
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.
TFieldType
Known field types to parser.
TextWithFormat.StringType
Possible string flags.