Namespace Syncfusion.XlsIO.Parser.Biff_Records
Classes
ArrayRecord
Summary description for ArrayRecord. |
AutoFilterInfoRecord
Summary description for AutoFilterInfoRecord. |
AutoFilterRecord
Summary description for AutoFilterInfoRecord. |
AutoFilterRecord.DOPER |
AutoFilterRecord.DOPER.DOPERComparisonSign
DOPER comparison sign types. |
AutoFilterRecord.DOPER.DOPERDataType
DOPER data type. |
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. |
BOFRecord.TType
This enum that describes all possible data after this BOF record. |
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. |
ExtendedFormatRecord.TXFType
Type of extended format. |
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. |
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. |
PaletteRecord.TColor
Structure describing color entry. |
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. |
RStringRecord.TFormattingRun
Rich text formatting run. |
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. |
SelectionRecord.TAddr
Each cell range address (called an ADDR structure) contains 4 16-bit values. Cell range address, BIFF8. |
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. |
TAddr
Each cell range address (called an ADDR structure) contains 4 16-bit values. Cell range address, BIFF8: |
TBIFFRecord
Enum that defines constants for all known Biff records. |
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. |
TextWithFormat.StringType
Possible string flags. |
TFieldType
Known field types to parser. |
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. |
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. |
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. |