See: Description
Interface | Description |
---|---|
BiffHeaderInput | |
CellValueRecordInterface |
The cell value record interface is implemented by all classes of type Record that
contain cell values.
|
Margin |
The margin interface is a parent used to define left, right, top and bottom margins.
|
Class | Description |
---|---|
AbstractEscherHolderRecord |
The escher container record is used to hold escher records.
|
ArrayRecord |
ARRAY (0x0221)
Treated in a similar way to SharedFormulaRecord
|
AutoFilter12Record | Deprecated
by dennischen@zkoss.org, 2013/8/13, this class doesn't implement well and cause ZSS-408 Cannot save 2003 format if the file contains auto filter configuration.
|
AutoFilterInfoRecord |
The AutoFilterInfo record specifies the number of columns that have AutoFilter enabled
and indicates the beginning of the collection of AutoFilter records.
|
AutoFilterRecord | Deprecated
by dennischen@zkoss.org, 2013/8/13, this class doesn't implement well and cause ZSS-408 Cannot save 2003 format if the file contains auto filter configuration.
|
BackupRecord |
Title: Backup Record
Description: Boolean specifying whether
the GUI should store a backup of the file.
|
BlankRecord |
Title: Blank cell record (0x0201)
Description: Represents a column in a row with no value but with styling.
|
BOFRecord |
Title: Beginning Of File (0x0809)
Description: Somewhat of a misnomer, its used for the beginning of a set of
records that have a particular purpose or subject.
|
BookBoolRecord |
Title: Save External Links record (BookBool)
Description: Contains a flag specifying whether the Gui should save externally
linked values from other workbooks.
|
BookExtRecord |
[MS-XLS].pdf 2.4.23 BookExt page 203
properties of a workbook file
|
BoolErrRecord |
Creates new BoolErrRecord. (0x0205)
REFERENCE: PG ???
|
BottomMarginRecord |
Record for the bottom margin.
|
BoundSheetRecord |
Title: Bound Sheet Record (aka BundleSheet) (0x0085)
Description: Defines a sheet within a workbook.
|
CalcCountRecord |
Title: Calc Count Record
Description: Specifies the maximum times the gui should perform a formula
recalculation.
|
CalcModeRecord |
Title: Calc Mode Record
Description: Tells the gui whether to calculate formulas
automatically, manually or automatically
except for tables.
|
CellRecord |
Base class for all cell value records (implementors of
CellValueRecordInterface ). |
CFHeaderRecord |
Conditional Formatting Header record CFHEADER (0x01B0)
|
CFRuleRecord |
Conditional Formatting Rule Record (0x01B1).
|
CFRuleRecord.ComparisonOperator | |
CodepageRecord |
Title: Codepage Record
Description: the default characterset. for the workbook
REFERENCE: PG 293 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
ColumnInfoRecord |
Title: COLINFO Record (0x007D)
Description: Defines with width and formatting for a range of columns
REFERENCE: PG 293 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
CommonObjectDataSubRecord |
The common object data record is used to store all common preferences for an excel object.
|
Compat12Record |
[MS-XLS].pdf 2.4.54 Compat12 page 231
whether to check for compatibility with earlier application versions when
saving the workbook.
|
CompressPicturesRecord |
[MS-XLS].pdf 2.4.55 CompressPictures page 231
Recomendation for picture compression when saving.
|
ContinueFrt12Record | Deprecated
by dennischen@zkoss.org, 2013/8/13, this class doesn't implement well and cause ZSS-408 Cannot save 2003 format if the file contains auto filter configuration.
|
ContinueRecord |
Title: Continue Record(0x003C) - Helper class used primarily for SST Records
Description: handles overflow for prior record in the input
stream; content is tailored to that prior record
|
CountryRecord |
Title: Country Record (aka WIN.INI country)
Description: used for localization.
|
CRNCountRecord |
XCT - CRN Count
REFERENCE: 5.114
|
CRNRecord |
Title: CRN(0x005A)
Description: This record stores the contents of an external cell or cell range
REFERENCE: OOO 5.23
|
DateWindow1904Record |
Title: Date Window 1904 Flag record
Description: Flag specifying whether 1904 date windowing is used.
|
DBCellRecord |
Title: DBCell Record (0x00D7)
Description: Used by Excel and other MS apps to quickly find rows in the sheets.
|
DBCellRecord.Builder | |
DConRefRecord |
DConRef records specify a range in a workbook (internal or external) that serves as a data source
for pivot tables or data consolidation.
|
DefaultColWidthRecord |
Title: Default Column Width Record (0x0055)
Description: Specifies the default width for columns that have no specific
width set.
|
DefaultRowHeightRecord |
Title: Default Row Height Record per sheet
Description: Row height for rows with undefined or not explicitly defined
heights.
|
DeltaRecord |
Title: Delta Record (0x0010)
Description: controls the accuracy of the calculations
REFERENCE: PG 303 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
DimensionsRecord |
Title: Dimensions Record
Description: provides the minumum and maximum bounds
of a sheet.
|
DrawingGroupRecord | |
DrawingRecord |
DrawingRecord (0x00EC)
|
DrawingRecordForBiffViewer |
This is purely for the biff viewer.
|
DrawingSelectionRecord |
MsoDrawingSelection (0x00ED)
Reference:
[MS-OGRAPH].pdf sec 2.4.69
|
DSFRecord |
Title: Double Stream Flag Record (0x0161)
Description: tells if this is a double stream file.
|
DVALRecord |
Title: DATAVALIDATIONS Record (0x01B2)
Description: used in data validation ;
This record is the list header of all data validation records (0x01BE) in the current sheet.
|
DVRecord |
Title: DATAVALIDATION Record (0x01BE)
Description: This record stores data validation settings and a list of cell ranges
which contain these settings.
|
EmbeddedObjectRefSubRecord |
ftPictFmla (0x0009)
A sub-record within the OBJ record which stores a reference to an object stored in a separate entry within the OLE2 compound file. |
EndSubRecord |
ftEnd (0x0000)
The end data record is used to denote the end of the subrecords.
|
EnhancedProtection | |
EOFRecord |
End Of File record.
|
EscherAggregate |
This class is used to aggregate the MSODRAWING and OBJ record
combinations.
|
ExtendedFormatRecord |
Title: Extended Format Record
Description: Probably one of the more complex records.
|
ExternalNameRecord |
EXTERNALNAME (0x0023)
|
ExternSheetRecord |
EXTERNSHEET (0x0017)
A List of Indexes to EXTERNALBOOK (supplemental book) Records |
ExtSSTRecord |
Title: Extended Static String Table (0x00FF)
Description: This record is used for a quick lookup into the SST record.
|
ExtSSTRecord.InfoSubRecord | |
FeatHdrRecord |
Title: FeatHdr (Feature Header) Record
This record specifies common information for Shared Features, and
specifies the beginning of a collection of records to define them.
|
FeatRecord |
Title: Feat (Feature) Record
This record specifies Shared Features data.
|
FilePassRecord |
Title: File Pass Record (0x002F)
Description: Indicates that the record after this record are encrypted.
|
FileSharingRecord |
Title: FILESHARING (0x005B)
Description: stores the encrypted readonly for a workbook (write protect)
This functionality is accessed from the options dialog box available when performing 'Save As'.
|
FnGroupCountRecord |
Title: Function Group Count Record
Description: Number of built in function groups in the current version of the
Spreadsheet (probably only used on Windoze)
REFERENCE: PG 315 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
FontRecord |
Title: Font Record (0x0031)
- describes a font in the workbook (index = 0-3,5-infinity - skip 4)
Description: An element in the Font Table
REFERENCE: PG 315 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
FooterRecord |
Title: Footer Record (0x0015)
Description: Specifies the footer for a sheet
REFERENCE: PG 317 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
ForceFullCalculationRecord |
[MS-XLS].pdf 2.4.125 ForceFullCalculation page 298
Value of the forced calculation mode for this workbook.
|
FormatRecord |
Title: Format Record (0x041E)
Description: describes a number format -- those goofy strings like $(#,###)
REFERENCE: PG 317 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
FormulaRecord |
Formula Record (0x0006).
|
FtCblsSubRecord |
This structure appears as part of an Obj record that represents a checkbox or radio button.
|
FtCfSubRecord |
ftCf (0x0007)
The clipboard picture format.
|
FtPioGrbitSubRecord |
Properties for picture obj.
|
FullColorExt |
2.5.155 FullColorExt.
|
GridsetRecord |
Title: Gridset Record.
|
GroupMarkerSubRecord |
ftGmo (0x0006)
The group marker record is used as a position holder for groups.
|
GutsRecord |
Title: Guts Record
Description: Row/column gutter sizes
REFERENCE: PG 320 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
HCenterRecord |
Title: HCenter record (0x0083)
Description: whether to center between horizontal margins
REFERENCE: PG 320 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
HeaderFooterBase |
Common header/footer base class
|
HeaderFooterRecord |
The HEADERFOOTER record stores information added in Office Excel 2007 for headers/footers.
|
HeaderRecord |
Title: Header Record
Description: Specifies a header for a sheet
REFERENCE: PG 321 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
HideObjRecord |
Title: Hide Object Record
Description: flag defines whether to hide placeholders and object
REFERENCE: PG 321 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
HorizontalPageBreakRecord |
HorizontalPageBreak (0x001B) record that stores page breaks at rows
|
HyperlinkRecord |
The
HyperlinkRecord (0x01B8) wraps an HLINK-record
from the Excel-97 format. |
IndexRecord |
Title: Index Record (0x020B)
Description: Occurs right after BOF, tells you where the DBCELL records are for a sheet
Important for locating cells
NOT USED IN THIS RELEASE
REFERENCE: PG 323 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
InterfaceEndRecord |
Title: Interface End Record (0x00E2)
Description: Shows where the Interface Records end (MMS)
(has no fields)
REFERENCE: PG 324 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
InterfaceHdrRecord |
Title: Interface Header Record (0x00E1)
Description: Defines the beginning of Interface records (MMS)
REFERENCE: PG 324 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
IterationRecord |
Title: Iteration Record (0x0011)
Description: Tells whether to iterate over forumla calculations or not
(if a formula is dependant upon another formula's result)
(odd feature for something that can only have 32 elements in
a formula!)
|
LabelRecord |
Label Record (0x0204) - read only support for strings stored directly in the cell..
|
LabelSSTRecord |
Title: Label SST Record
Description: Refers to a string in the shared string table and is a column
value.
|
LbsDataSubRecord |
This structure specifies the properties of a list or drop-down list embedded object in a sheet.
|
LbsDataSubRecord.LbsDropData |
This structure specifies properties of the dropdown list control
|
LeftMarginRecord |
Record for the left margin.
|
MergeCellsRecord |
Title: Merged Cells Record (0x00E5)
Description: Optional record defining a square area of cells to "merged" into one cell. |
MMSRecord |
Title: MMS Record
Description: defines how many add menu and del menu options are stored
in the file.
|
MTRSettingsRecord |
[MS-XLS].pdf 2.4.173 MTRSettings page 343
Multithreaded calculation settings.
|
MulBlankRecord |
Title: Multiple Blank cell record(0x00BE)
Description: Represents a set of columns in a row with no value but with styling.
|
MulRKRecord |
MULRK (0x00BD)
Used to store multiple RK numbers on a row. 1 MulRk = Multiple Cell values.
|
NameCommentRecord |
Title: NAMECMT Record (0x0894)
Description: Defines a comment associated with a specified name.
|
NameRecord |
Title: DEFINEDNAME Record (0x0018)
Description: Defines a named range within a workbook.
|
NoteRecord |
NOTE: Comment Associated with a Cell (0x001C)
|
NoteStructureSubRecord |
ftNts (0x000D)
Represents a NoteStructure sub record.
|
NumberRecord |
NUMBER (0x0203) Contains a numeric cell value.
|
ObjectProtectRecord |
Title: Object Protect Record
Description: Protect embedded object with the lamest "security" ever invented.
|
ObjRecord |
OBJRECORD (0x005D)
The obj record is used to hold various graphic objects and controls.
|
PageBreakRecord |
Record that contains the functionality page breaks (horizontal and vertical)
The other two classes just specifically set the SIDS for record creation.
|
PageBreakRecord.Break |
Since both records store 2byte integers (short), no point in
differentiating it in the records.
|
PaletteRecord |
PaletteRecord (0x0092) - Supports custom palettes.
|
PaneRecord |
Describes the frozen and unfozen panes.
|
PasswordRecord |
Title: Password Record (0x0013)
Description: stores the encrypted password for a sheet or workbook (HSSF doesn't support encryption)
REFERENCE: PG 371 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
PasswordRev4Record |
Title: Protection Revision 4 password Record (0x01BC)
Description: Stores the (2 byte??!!)
|
PLVRecord |
[MS-XLS].pdf 2.4.200 PLV page 360
Page Layout View for a sheet.
|
PrecisionRecord |
Title: Precision Record
Description: defines whether to store with full precision or what's displayed by the gui
(meaning have really screwed up and skewed figures or only think you do!)
|
PrintGridlinesRecord |
Title: Print Gridlines Record
Description: whether to print the gridlines when you enjoy you spreadsheet on paper.
|
PrintHeadersRecord |
Title: Print Headers Record
Description: Whether or not to print the row/column headers when you
enjoy your spreadsheet in the physical form.
|
PrintSetupRecord |
Title: PAGESETUP (0x00A1)
Description: Stores print setup options -- bogus for HSSF (and marked as such)
REFERENCE: PG 385 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
REFERENCE: PG 412 Microsoft Excel Binary File Format Structure v20091214
|
ProtectionRev4Record |
Title: Protection Revision 4 Record (0x01AF)
Description: describes whether this is a protected shared/tracked workbook
REFERENCE: PG 373 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
ProtectRecord |
Title: Protect Record (0x0012)
Description: defines whether a sheet or workbook is protected (HSSF DOES NOT SUPPORT ENCRYPTION)
HSSF now supports the simple "protected" sheets (where they are not encrypted and open office et al
ignore the password record entirely).
|
RecalcIdRecord |
Title: Recalc Id Record (0x01C1)
Description: This record contains an ID that marks when a worksheet was last
recalculated.
|
Record |
Title: Record
Description: All HSSF Records inherit from this class.
|
RecordBase |
Common base class of
Record and RecordAggregate |
RecordFactory |
Title: Record Factory
Description: Takes a stream and outputs an array of Record objects.
|
RecordFactoryInputStream |
A stream based way to get at complete records, with
as low a memory footprint as possible.
|
RecordInputStream |
Title: Record Input Stream
Description: Wraps a stream and provides helper methods for the construction of records.
|
RefModeRecord |
Title: RefMode Record
Description: Describes which reference mode to use
REFERENCE: PG 376 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
RefreshAllRecord |
Title: Refresh All Record (0x01B7)
Description: Flag whether to refresh all external data when loading a sheet.
|
RightMarginRecord |
Record for the right margin.
|
RKRecord |
Title: RK Record (0x027E)
Description: An internal 32 bit number with the two most significant bits
storing the type.
|
RowRecord |
Title: Row Record (0x0208)
Description: stores the row information for the sheet.
|
SaveRecalcRecord |
Title: Save Recalc Record
Description: defines whether to recalculate before saving (set to true)
REFERENCE: PG 381 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
ScenarioProtectRecord |
Title: Scenario Protect Record
Description: I have no idea what a Scenario is or why on would want to
protect it with the lamest "security" ever invented.
|
SCLRecord |
Specifies the window's zoom magnification.
|
SelectionRecord |
Title: Selection Record (0x001D)
Description: shows the user's selection on the sheet
for write set num refs to 0
REFERENCE: PG 291 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
SharedFormulaRecord |
Title: SHAREDFMLA (0x04BC) SharedFormulaRecord
Description: Primarily used as an excel optimization so that multiple similar formulas
are not written out too many times.
|
SharedValueRecordBase | |
SSTRecord |
Title: Static String Table Record (0x00FC)
Description: This holds all the strings for LabelSSTRecords.
|
StandardRecord |
Subclasses of this class (the majority of BIFF records) are non-continuable.
|
StringRecord |
STRING (0x0207)
Stores the cached result of a text formula
|
StyleExtRecord |
The StyleExt record follow the Style record
|
StyleRecord |
Title: Style Record (0x0293)
Description: Describes a builtin to the gui or user defined style
REFERENCE: PG 390 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
SubRecord |
Subrecords are part of the OBJ class.
|
SupBookRecord |
Title: Sup Book - EXTERNALBOOK (0x01AE)
Description: A External Workbook Description (Supplemental Book)
Its only a dummy record for making new ExternSheet Record
REFERENCE: 5.38
|
TabIdRecord |
Title: Sheet Tab Index Array Record (0x013D)
Description: Contains an array of sheet id's.
|
TableRecord |
DATATABLE (0x0236)
TableRecord - The record specifies a data table.
|
TableStylesRecord |
TABLESTYLES (0x088E)
|
TextObjectRecord |
The TXO record (0x01B6) is used to define the properties of a text box.
|
ThemeRecord |
The theme used in this workbook.
|
TopMarginRecord |
Record for the top margin.
|
UncalcedRecord |
Title: Uncalced Record
If this record occurs in the Worksheet Substream, it indicates that the formulas have not
been recalculated before the document was saved.
|
UnicodeString | Deprecated
Use
UnicodeString instead |
UnknownRecord |
Title: Unknown Record (for debugging)
Description: Unknown record just tells you the sid so you can figure out
what records you are missing.
|
UserSViewBegin |
The UserSViewBegin record specifies settings for a custom view associated with the sheet.
|
UserSViewEnd |
The UserSViewEnd record marks the end of the settings for a custom view associated with the sheet
|
UseSelFSRecord |
Title: USESELFS (0x0160) - Use Natural Language Formulas Flag
Description: Tells the GUI if this was written by something that can use
"natural language" formulas.
|
VCenterRecord |
Title: VCenter record
Description: tells whether to center the sheet between vertical margins
REFERENCE: PG 420 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
VerticalPageBreakRecord |
VerticalPageBreak (0x001A) record that stores page breaks at columns
|
WindowOneRecord |
Title: Window1 Record
Description: Stores the attributes of the workbook window.
|
WindowProtectRecord |
Title: Window Protect Record (0x0019)
Description: flags whether workbook windows are protected
REFERENCE: PG 424 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
WindowTwoRecord |
Title: Window Two Record
Description: sheet window settings
REFERENCE: PG 422 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
WriteAccessRecord |
Title: Write Access Record (0x005C)
Description: Stores the username of that who owns the spreadsheet generator (on unix the user's
login, on Windoze its the name you typed when you installed the thing)
REFERENCE: PG 424 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
WriteProtectRecord |
Title: Write Protect Record
Description: Indicated that the sheet/workbook is write protected.
|
WSBoolRecord |
Title: WSBOOL (0x0081) (called SHEETPR in OOO doc)
Description: stores workbook settings (aka its a big "everything we didn't
put somewhere else")
REFERENCE: PG 425 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
XFCrcRecord |
Title: XFCRC Record
|
XFExtRecord |
2.4.355 XFEXT [MS-XLS].pdf, page 609.
|
Exception | Description |
---|---|
RecordFormatException |
Title: Record Format Exception
Description: Used by records to indicate invalid format/data.
|
RecordInputStream.LeftoverDataException |
For use in
BiffViewer which may construct Record s that don't completely
read all available data. |
org.apache.poi.hssf.eventmodel
,
org.apache.poi.hssf.record.RecordFactory
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.