org.apache.poi.hssf.record

Class FormulaRecord

java.lang.Object

org.apache.poi.hssf.record.RecordBase

org.apache.poi.hssf.record.Record

org.apache.poi.hssf.record.StandardRecord

org.apache.poi.hssf.record.CellRecord

org.apache.poi.hssf.record.FormulaRecord

All Implemented Interfaces:

CellValueRecordInterface

public final class FormulaRecord
extends CellRecord

Formula Record (0x0006). REFERENCE: PG 317/444 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)

Field Summary

Fields

Modifier and Type	Field and Description
static short	sid

Constructor Summary

Constructors

Constructor and Description
FormulaRecord() Creates new FormulaRecord
FormulaRecord(RecordInputStream ris)

Method Summary

Modifier and Type	Method and Description
java.lang.Object	clone()
boolean	getCachedBooleanValue()
int	getCachedErrorValue()
int	getCachedResultType()
Formula	getFormula()
short	getOptions() get the option flags
Ptg[]	getParsedExpression()
short	getSid() return the non static version of the id for this record.
double	getValue() get the calculated value of the formula
boolean	hasCachedResultString()
boolean	isAlwaysCalc()
boolean	isCalcOnLoad()
boolean	isSharedFormula()
void	setAlwaysCalc(boolean flag)
void	setCachedResultBoolean(boolean value)
void	setCachedResultErrorCode(int errorCode)
void	setCachedResultTypeEmptyString()
void	setCachedResultTypeString()
void	setCalcOnLoad(boolean flag)
void	setOptions(short options) set the option flags
void	setParsedExpression(Ptg[] ptgs)
void	setSharedFormula(boolean flag)
void	setValue(double value) set the calculated value of the formula

Methods inherited from class org.apache.poi.hssf.record.CellRecord

getColumn, getRow, getXFIndex, serialize, setColumn, setRow, setXFIndex, toString

Methods inherited from class org.apache.poi.hssf.record.StandardRecord

getRecordSize, serialize

Methods inherited from class org.apache.poi.hssf.record.Record

cloneViaReserialise, serialize

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

sid

public static final short sid

See Also:

Constant Field Values

Constructor Detail

FormulaRecord

public FormulaRecord()

Creates new FormulaRecord

FormulaRecord

public FormulaRecord(RecordInputStream ris)

Method Detail

setValue

public void setValue(double value)

set the calculated value of the formula

Parameters:

value - calculated value

setCachedResultTypeEmptyString

public void setCachedResultTypeEmptyString()

setCachedResultTypeString

public void setCachedResultTypeString()

setCachedResultErrorCode

public void setCachedResultErrorCode(int errorCode)

setCachedResultBoolean

public void setCachedResultBoolean(boolean value)

hasCachedResultString

public boolean hasCachedResultString()

Returns:

true if this FormulaRecord is followed by a StringRecord representing the cached text result of the formula evaluation.

getCachedResultType

public int getCachedResultType()

getCachedBooleanValue

public boolean getCachedBooleanValue()

getCachedErrorValue

public int getCachedErrorValue()

setOptions

public void setOptions(short options)

set the option flags

Parameters:

options - bitmask

getValue

public double getValue()

get the calculated value of the formula

Returns:

calculated value

getOptions

public short getOptions()

get the option flags

Returns:

bitmask

isSharedFormula

public boolean isSharedFormula()

setSharedFormula

public void setSharedFormula(boolean flag)

isAlwaysCalc

public boolean isAlwaysCalc()

setAlwaysCalc

public void setAlwaysCalc(boolean flag)

isCalcOnLoad

public boolean isCalcOnLoad()

setCalcOnLoad

public void setCalcOnLoad(boolean flag)

getParsedExpression

public Ptg[] getParsedExpression()

Returns:

the formula tokens. never null

getFormula

public Formula getFormula()

setParsedExpression

public void setParsedExpression(Ptg[] ptgs)

getSid

public short getSid()

Description copied from class: Record

return the non static version of the id for this record.

Specified by:

getSid in class Record

clone

public java.lang.Object clone()

Overrides:

clone in class Record