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, getSheet, 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