jxl.read.biff
Class NumberValue

java.lang.Object
  |
  +--jxl.read.biff.NumberValue
All Implemented Interfaces:
Cell, NumberCell

class NumberValue
extends java.lang.Object
implements NumberCell

A numerical cell value, initialized indirectly from a multiple biff record rather than directly from the binary data


Field Summary
private  CellFormat cellFormat
          The raw cell format
private  int column
          The column containing this number
private static java.text.DecimalFormat defaultFormat
          The format in which to return this number as a string
private  java.text.NumberFormat format
          The cell format
private  FormattingRecords formattingRecords
          A handle to the formatting records
private  boolean initialized
          A flag to indicate whether this object's formatting things have been initialized
private  int row
          The row containing this number
private  SheetImpl sheet
          A handle to the sheet
private  double value
          The value of this number
private  int xfIndex
          The index to the XF Record
 
Constructor Summary
NumberValue(int r, int c, double val, int xfi, FormattingRecords fr, SheetImpl si)
          Constructs this number
 
Method Summary
 CellFormat getCellFormat()
          Gets the cell format
 int getColumn()
          Accessor for the column
 java.lang.String getContents()
          Accessor for the contents as a string
 java.text.NumberFormat getNumberFormat()
          Gets the NumberFormat used to format this cell.
 int getRow()
          Accessor for the row
 CellType getType()
          Accessor for the cell type
 double getValue()
          Accessor for the value
 boolean isHidden()
          Determines whether or not this cell has been hidden
(package private)  void setNumberFormat(java.text.NumberFormat f)
          Sets the format for the number based on the Excel spreadsheets' format.
 
Methods inherited from class java.lang.Object
, clone, equals, finalize, getClass, hashCode, notify, notifyAll, registerNatives, toString, wait, wait, wait
 

Field Detail

row

private int row
The row containing this number

column

private int column
The column containing this number

value

private double value
The value of this number

format

private java.text.NumberFormat format
The cell format

cellFormat

private CellFormat cellFormat
The raw cell format

xfIndex

private int xfIndex
The index to the XF Record

formattingRecords

private FormattingRecords formattingRecords
A handle to the formatting records

initialized

private boolean initialized
A flag to indicate whether this object's formatting things have been initialized

sheet

private SheetImpl sheet
A handle to the sheet

defaultFormat

private static java.text.DecimalFormat defaultFormat
The format in which to return this number as a string
Constructor Detail

NumberValue

public NumberValue(int r,
                   int c,
                   double val,
                   int xfi,
                   FormattingRecords fr,
                   SheetImpl si)
Constructs this number
Parameters:
c - the zero base column
r - the zero based row
val - the value
si - the sheet
Method Detail

setNumberFormat

final void setNumberFormat(java.text.NumberFormat f)
Sets the format for the number based on the Excel spreadsheets' format. This is called from SheetImpl when it has been definitely established that this cell is a number and not a date
Parameters:
f - the format

getRow

public final int getRow()
Accessor for the row
Specified by:
getRow in interface Cell
Returns:
the zero based row

getColumn

public final int getColumn()
Accessor for the column
Specified by:
getColumn in interface Cell
Returns:
the zero based column

getValue

public double getValue()
Accessor for the value
Specified by:
getValue in interface NumberCell
Returns:
the value

getContents

public java.lang.String getContents()
Accessor for the contents as a string
Specified by:
getContents in interface Cell
Returns:
the value as a string

getType

public CellType getType()
Accessor for the cell type
Specified by:
getType in interface Cell
Returns:
the cell type

getCellFormat

public CellFormat getCellFormat()
Gets the cell format
Specified by:
getCellFormat in interface Cell
Returns:
the cell format

isHidden

public boolean isHidden()
Determines whether or not this cell has been hidden
Specified by:
isHidden in interface Cell
Returns:
TRUE if this cell has been hidden, FALSE otherwise

getNumberFormat

public java.text.NumberFormat getNumberFormat()
Gets the NumberFormat used to format this cell. This is the java equivalent of the Excel format
Specified by:
getNumberFormat in interface NumberCell
Returns:
the NumberFormat used to format the cell