jxl.read.biff
Class SharedDateFormulaRecord

java.lang.Object
  |
  +--jxl.biff.RecordData
        |
        +--jxl.read.biff.CellValue
              |
              +--jxl.read.biff.BaseSharedFormulaRecord
                    |
                    +--jxl.read.biff.SharedDateFormulaRecord

All Implemented Interfaces:

Cell, DateCell, FormulaCell, FormulaData, NumberCell, NumberFormulaCell

public class SharedDateFormulaRecord

extends BaseSharedFormulaRecord

implements DateCell, FormulaData, NumberFormulaCell

A number formula record, manufactured out of the Shared Formula "optimization"

Field Summary

private DateRecord	dateRecord Re-use the date record to handle all the formatting information and date calculations
private double	value The double value

Fields inherited from class jxl.read.biff.BaseSharedFormulaRecord

externalSheet, formattingRecords, formulaString, tokens

Fields inherited from class jxl.read.biff.CellValue

column, format, initialized, row, sheet, xfIndex

Fields inherited from class jxl.biff.RecordData

code, record

Constructor Summary

SharedDateFormulaRecord(SharedNumberFormulaRecord nfr, FormattingRecords fr, boolean nf, SheetImpl si)
Constructs this number

Method Summary

java.lang.String	getContents() Accessor for the contents as a string
java.util.Date	getDate() Gets the date
java.text.DateFormat	getDateFormat() Gets the DateFormat used to format the cell.
byte[]	getFormulaData() Gets the raw bytes for the formula.
CellType	getType() Accessor for the cell type
double	getValue() Accessor for the value
boolean	isTime() Indicates whether the date value contained in this cell refers to a date, or merely a time

Methods inherited from class jxl.read.biff.BaseSharedFormulaRecord

getExternalSheet, getFormula, getRecord, getTokens, setTokens

Methods inherited from class jxl.read.biff.CellValue

getCellFormat, getColumn, getRow, getXFIndex, isHidden

Methods inherited from class jxl.biff.RecordData

getCode

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

Methods inherited from interface jxl.FormulaCell

getFormula

Field Detail

dateRecord

private DateRecord dateRecord

Re-use the date record to handle all the formatting information and date calculations

value

private double value

The double value

Constructor Detail

SharedDateFormulaRecord

public SharedDateFormulaRecord(SharedNumberFormulaRecord nfr,
                               FormattingRecords fr,
                               boolean nf,
                               SheetImpl si)

Constructs this number

Parameters:

f - the formula

r - the zero based row

val - the value

nf - flag indicating whether this uses the 1904 date system

si - the sheet

Method Detail

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

getFormulaData

public byte[] getFormulaData()
                      throws FormulaException

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

getDate

public java.util.Date getDate()

Gets the date

Specified by:

getDate in interface DateCell

Returns:

the date

isTime

public boolean isTime()

Indicates whether the date value contained in this cell refers to a date, or merely a time

Specified by:

isTime in interface DateCell

Returns:

TRUE if the value refers to a time

getDateFormat

public java.text.DateFormat getDateFormat()

Gets the DateFormat used to format the cell. This will normally be the format specified in the excel spreadsheet, but in the event of any difficulty parsing this, it will revert to the default date/time format.

Specified by:

getDateFormat in interface DateCell

Returns:

the DateFormat object used to format the date in the original excel cell