jxl.read.biff
Class DateFormulaRecord

java.lang.Object
  |
  +--jxl.read.biff.DateRecord
        |
        +--jxl.read.biff.DateFormulaRecord

All Implemented Interfaces:

Cell, DateCell, FormulaCell, FormulaData, NumberCell, NumberFormulaCell

class DateFormulaRecord

extends DateRecord

implements DateCell, FormulaData, NumberFormulaCell

A date formula's last calculated value

Field Summary

private byte[]	data The raw data
private ExternalSheet	externalSheet A handle to the class needed to access external sheets
private java.lang.String	formulaString The formula as an excel string
private double	value The last calculated value of the formula

Fields inherited from class jxl.read.biff.DateRecord

cellFormat, column, date, dateFormat, format, formattingRecords, gmtZone, initialized, msInADay, nonLeapDay, row, sheet, time, timeFormat, utcOffsetDays, utcOffsetDays1904, xfIndex

Constructor Summary

DateFormulaRecord(NumberFormulaRecord t, FormattingRecords fr, ExternalSheet es, boolean nf, SheetImpl si)
Constructs this object from the raw data

Method Summary

java.lang.String	getFormula() Gets the formula as an excel string
byte[]	getFormulaData() Gets the raw bytes for the formula.
CellType	getType() Returns the cell type
double	getValue() Interface method which returns the value

Methods inherited from class jxl.read.biff.DateRecord

getCellFormat, getColumn, getContents, getDate, getDateFormat, getRow, isHidden, isTime

Methods inherited from class java.lang.Object

, clone, equals, finalize, getClass, hashCode, notify, notifyAll, registerNatives, toString, wait, wait, wait

Methods inherited from interface jxl.DateCell

getDate, getDateFormat, isTime

Methods inherited from interface jxl.Cell

getCellFormat, getColumn, getContents, getRow, isHidden

Field Detail

value

private double value

The last calculated value of the formula

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

data

private byte[] data

The raw data

Constructor Detail

DateFormulaRecord

public DateFormulaRecord(NumberFormulaRecord t,
                         FormattingRecords fr,
                         ExternalSheet es,
                         boolean nf,
                         SheetImpl si)

Constructs this object from the raw data

Parameters:

t - the basic number formula record

fr - the formatting records

es - the external sheet

nf - flag indicating whether the 1904 date system is in use

si - the sheet

Method Detail

getType

public CellType getType()

Returns the cell type

Specified by:

getType in interface Cell

Overrides:

getType in class DateRecord

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

getValue

public double getValue()

Interface method which returns the value

Specified by:

getValue in interface NumberCell

Returns:

the last calculated value of the formula