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