jxl.read.biff
Class NumberFormulaRecord

java.lang.Object
  |
  +--jxl.biff.RecordData
        |
        +--jxl.read.biff.CellValue
              |
              +--jxl.read.biff.NumberFormulaRecord
All Implemented Interfaces:
Cell, FormulaCell, FormulaData, NumberCell, NumberFormulaCell

class NumberFormulaRecord
extends CellValue
implements NumberCell, FormulaData, NumberFormulaCell

A formula's last calculated value


Field Summary
private  byte[] data
          The raw data
private static java.text.DecimalFormat defaultFormat
          The string format for the double value
private  ExternalSheet externalSheet
          A handle to the class needed to access external sheets
private  java.text.NumberFormat format
          The number format
private  java.lang.String formulaString
          The formula as an excel string
private  NameTable nameTable
          A handle to the name table
private  double value
          The last calculated value of the formula
 
Fields inherited from class jxl.read.biff.CellValue
column, formattingRecords, initialized, row, sheet, xfIndex
 
Fields inherited from class jxl.biff.RecordData
code, record
 
Constructor Summary
NumberFormulaRecord(Record t, FormattingRecords fr, ExternalSheet es, NameTable nt, SheetImpl si)
          Constructs this object from the raw data
 
Method Summary
 java.lang.String getContents()
          Returns the numerical value as a string
 java.lang.String getFormula()
          Gets the formula as an excel string
 byte[] getFormulaData()
          Gets the raw bytes for the formula.
 java.text.NumberFormat getNumberFormat()
          Gets the NumberFormat used to format this cell.
 CellType getType()
          Returns the cell type
 double getValue()
          Interface method which returns the value
 
Methods inherited from class jxl.read.biff.CellValue
getCellFormat, getColumn, getRow, getSheet, getXFIndex, isHidden
 
Methods inherited from class jxl.biff.RecordData
getCode, getRecord
 
Methods inherited from class java.lang.Object
, clone, equals, finalize, getClass, hashCode, notify, notifyAll, registerNatives, toString, wait, wait, wait
 
Methods inherited from interface jxl.Cell
getCellFormat, getColumn, getRow, isHidden
 

Field Detail

value

private double value
The last calculated value of the formula

format

private java.text.NumberFormat format
The number format

defaultFormat

private static final java.text.DecimalFormat defaultFormat
The string format for the double value

formulaString

private java.lang.String formulaString
The formula as an excel string

externalSheet

private ExternalSheet externalSheet
A handle to the class needed to access external sheets

nameTable

private NameTable nameTable
A handle to the name table

data

private byte[] data
The raw data
Constructor Detail

NumberFormulaRecord

public NumberFormulaRecord(Record t,
                           FormattingRecords fr,
                           ExternalSheet es,
                           NameTable nt,
                           SheetImpl si)
Constructs this object from the raw data
Parameters:
t - the raw data
fr - the formatting record
es - the external sheet
nt - the name table
si - the sheet
Method Detail

getValue

public double getValue()
Interface method which returns the value
Specified by:
getValue in interface NumberCell
Returns:
the last calculated value of the formula

getContents

public java.lang.String getContents()
Returns the numerical value as a string
Specified by:
getContents in interface Cell
Returns:
The numerical value of the formula as a string

getType

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

getFormulaData

public byte[] getFormulaData()
Gets the raw bytes for the formula. This will include the parsed tokens array. Used when copying spreadsheets
Specified by:
getFormulaData in interface FormulaData
Returns:
the raw record data

getFormula

public java.lang.String getFormula()
                            throws FormulaException
Gets the formula as an excel string
Specified by:
getFormula in interface FormulaCell
Returns:
the formula as an excel string

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