Package loci.poi.hssf.record
Class NumberRecord
- java.lang.Object
-
- loci.poi.hssf.record.Record
-
- loci.poi.hssf.record.NumberRecord
-
- All Implemented Interfaces:
java.lang.Comparable,CellValueRecordInterface
public class NumberRecord extends Record implements CellValueRecordInterface, java.lang.Comparable
Contains a numeric cell value.REFERENCE: PG 334 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
- Version:
- 2.0-pre
- Author:
- Andrew C. Oliver (acoliver at apache dot org), Jason Height (jheight at chariot dot net dot au)
-
-
Field Summary
Fields Modifier and Type Field Description static shortsid
-
Constructor Summary
Constructors Constructor Description NumberRecord()Creates new NumberRecordNumberRecord(RecordInputStream in)Constructs a Number record and sets its fields appropriately.
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description java.lang.Objectclone()intcompareTo(java.lang.Object obj)booleanequals(java.lang.Object obj)protected voidfillFields(RecordInputStream in)called by the constructor, should set class level fields.shortgetColumn()get the column this cell defines within the rowintgetRecordSize()gives the current serialized size of the record.intgetRow()get the row this cell occurs onshortgetSid()return the non static version of the id for this record.doublegetValue()get the value for the cellshortgetXFIndex()get the index to the ExtendedFormatbooleanisAfter(CellValueRecordInterface i)returns whether this cell is after the passed in cellbooleanisBefore(CellValueRecordInterface i)returns whether this cell is before the passed in cellbooleanisEqual(CellValueRecordInterface i)returns whether this cell represents the same cell (NOT VALUE)booleanisInValueSection()DBCELL, ROW, VALUES all say yesbooleanisValue()tells whether this type of record contains a valueintserialize(int offset, byte[] data)called by the class that is responsible for writing this sucker.voidsetColumn(short col)set the column this cell defines within the rowvoidsetRow(int row)set the row this cell occurs onvoidsetValue(double value)set the value for the cellvoidsetXFIndex(short xf)set the index to the ExtendedFormatjava.lang.StringtoString()get a string representation of the record (for biffview/debugging)protected voidvalidateSid(short id)called by constructor, should throw runtime exception in the event of a record passed with a differing ID.
-
-
-
Field Detail
-
sid
public static final short sid
- See Also:
- Constant Field Values
-
-
Constructor Detail
-
NumberRecord
public NumberRecord()
Creates new NumberRecord
-
NumberRecord
public NumberRecord(RecordInputStream in)
Constructs a Number record and sets its fields appropriately.- Parameters:
in- the RecordInputstream to read the record from
-
-
Method Detail
-
fillFields
protected void fillFields(RecordInputStream in)
Description copied from class:Recordcalled by the constructor, should set class level fields. Should throw runtime exception for bad/icomplete data.- Specified by:
fillFieldsin classRecord- Parameters:
in- the RecordInputstream to read the record from
-
setRow
public void setRow(int row)
Description copied from interface:CellValueRecordInterfaceset the row this cell occurs on- Specified by:
setRowin interfaceCellValueRecordInterface- Parameters:
row- the row this cell occurs within
-
setColumn
public void setColumn(short col)
Description copied from interface:CellValueRecordInterfaceset the column this cell defines within the row- Specified by:
setColumnin interfaceCellValueRecordInterface- Parameters:
col- the column this cell defines
-
setXFIndex
public void setXFIndex(short xf)
set the index to the ExtendedFormat- Specified by:
setXFIndexin interfaceCellValueRecordInterface- Parameters:
xf- index to the XF record- See Also:
ExtendedFormatRecord
-
setValue
public void setValue(double value)
set the value for the cell- Parameters:
value- double representing the value
-
getRow
public int getRow()
Description copied from interface:CellValueRecordInterfaceget the row this cell occurs on- Specified by:
getRowin interfaceCellValueRecordInterface- Returns:
- the row
-
getColumn
public short getColumn()
Description copied from interface:CellValueRecordInterfaceget the column this cell defines within the row- Specified by:
getColumnin interfaceCellValueRecordInterface- Returns:
- the column
-
getXFIndex
public short getXFIndex()
get the index to the ExtendedFormat- Specified by:
getXFIndexin interfaceCellValueRecordInterface- Returns:
- index to the XF record
- See Also:
ExtendedFormatRecord
-
getValue
public double getValue()
get the value for the cell- Returns:
- double representing the value
-
toString
public java.lang.String toString()
Description copied from class:Recordget a string representation of the record (for biffview/debugging)
-
serialize
public int serialize(int offset, byte[] data)called by the class that is responsible for writing this sucker. Subclasses should implement this so that their data is passed back in a byte array.
-
getRecordSize
public int getRecordSize()
Description copied from class:Recordgives the current serialized size of the record. Should include the sid and reclength (4 bytes).- Overrides:
getRecordSizein classRecord
-
validateSid
protected void validateSid(short id)
called by constructor, should throw runtime exception in the event of a record passed with a differing ID.- Specified by:
validateSidin classRecord- Parameters:
id- alleged id for this record
-
getSid
public short getSid()
Description copied from class:Recordreturn the non static version of the id for this record.
-
isBefore
public boolean isBefore(CellValueRecordInterface i)
Description copied from interface:CellValueRecordInterfacereturns whether this cell is before the passed in cell- Specified by:
isBeforein interfaceCellValueRecordInterface- Parameters:
i- another cell interface record to compare- Returns:
- true if the cells is before, or false if not
-
isAfter
public boolean isAfter(CellValueRecordInterface i)
Description copied from interface:CellValueRecordInterfacereturns whether this cell is after the passed in cell- Specified by:
isAfterin interfaceCellValueRecordInterface- Parameters:
i- record to compare- Returns:
- true if the cell is after, false if not
-
isEqual
public boolean isEqual(CellValueRecordInterface i)
Description copied from interface:CellValueRecordInterfacereturns whether this cell represents the same cell (NOT VALUE)- Specified by:
isEqualin interfaceCellValueRecordInterface- Parameters:
i- record to compare- Returns:
- true if the cells are the same cell (positionally), false if not.
-
isInValueSection
public boolean isInValueSection()
Description copied from class:RecordDBCELL, ROW, VALUES all say yes- Overrides:
isInValueSectionin classRecord
-
isValue
public boolean isValue()
Description copied from class:Recordtells whether this type of record contains a value
-
compareTo
public int compareTo(java.lang.Object obj)
- Specified by:
compareToin interfacejava.lang.Comparable
-
equals
public boolean equals(java.lang.Object obj)
- Overrides:
equalsin classjava.lang.Object
-
clone
public java.lang.Object clone()
- Specified by:
clonein interfaceCellValueRecordInterface- Overrides:
clonein classRecord
-
-