jxl.read.biff
Class SharedStringFormulaRecord

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

All Implemented Interfaces:

Cell, FormulaCell, FormulaData, LabelCell, StringFormulaCell

public class SharedStringFormulaRecord

extends BaseSharedFormulaRecord

implements LabelCell, FormulaData, StringFormulaCell

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

Field Summary

private FormattingRecords	formattingRecords A handle to the formatting records
private java.lang.String	value The value of this string formula

Fields inherited from class jxl.read.biff.BaseSharedFormulaRecord

externalSheet, formulaString, nameTable, 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

SharedStringFormulaRecord(Record t, File excelFile, FormattingRecords fr, ExternalSheet es, NameTable nt, SheetImpl si, WorkbookSettings ws)
Constructs this string formula

Method Summary

java.lang.String	getContents() Accessor for the contents as a string
byte[]	getFormulaData() Gets the raw bytes for the formula.
java.lang.String	getString() Accessor for the value
CellType	getType() Accessor for the cell type

Methods inherited from class jxl.read.biff.BaseSharedFormulaRecord

getExternalSheet, getFormula, getNameTable, getRecord, getTokens, setTokens

Methods inherited from class jxl.read.biff.CellValue

getCellFormat, getColumn, getRow, getSheet, 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

value

private java.lang.String value

The value of this string formula

formattingRecords

private FormattingRecords formattingRecords

A handle to the formatting records

Constructor Detail

SharedStringFormulaRecord

public SharedStringFormulaRecord(Record t,
                                 File excelFile,
                                 FormattingRecords fr,
                                 ExternalSheet es,
                                 NameTable nt,
                                 SheetImpl si,
                                 WorkbookSettings ws)

Constructs this string formula

Parameters:

f - the formula

r - the zero based row

val - the value

si - the sheet

Method Detail

getString

public java.lang.String getString()

Accessor for the value

Specified by:

getString in interface LabelCell

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