jxl.read.biff
Class BooleanFormulaRecord

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

All Implemented Interfaces:

BooleanCell, BooleanFormulaCell, Cell, FormulaCell, FormulaData

class BooleanFormulaRecord

extends CellValue

implements BooleanCell, FormulaData, BooleanFormulaCell

A boolean 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 NameTable	nameTable A handle to the name table
private boolean	value The boolean value of this cell.

Fields inherited from class jxl.read.biff.CellValue

column, format, formattingRecords, initialized, row, sheet, xfIndex

Fields inherited from class jxl.biff.RecordData

code, record

Constructor Summary

BooleanFormulaRecord(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.
CellType	getType() Returns the cell type
boolean	getValue() Interface method which Gets the boolean value stored in this cell.

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 boolean value

The boolean value of this cell. If this cell represents an error, this will be false

externalSheet

private ExternalSheet externalSheet

A handle to the class needed to access external sheets

nameTable

private NameTable nameTable

A handle to the name table

formulaString

private java.lang.String formulaString

The formula as an excel string

data

private byte[] data

The raw data

Constructor Detail

BooleanFormulaRecord

public BooleanFormulaRecord(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 records

si - the sheet

es - the sheet

nt - the name table

Method Detail

getValue

public boolean getValue()

Interface method which Gets the boolean value stored in this cell. If this cell contains an error, then returns FALSE. Always query this cell type using the accessor method isError() prior to calling this method

Specified by:

getValue in interface BooleanCell

Returns:

TRUE if this cell contains TRUE, FALSE if it contains FALSE or an error code

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

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

Throws:

FormulaException -