Package 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:
Cloneable
,CellValueRecordInterface
public final class FormulaRecord extends CellRecord implements Cloneable
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 Description static short
sid
-
Constructor Summary
Constructors Constructor Description FormulaRecord()
Creates new FormulaRecordFormulaRecord(RecordInputStream ris)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description FormulaRecord
clone()
boolean
getCachedBooleanValue()
int
getCachedErrorValue()
int
getCachedResultType()
Formula
getFormula()
short
getOptions()
get the option flagsPtg[]
getParsedExpression()
short
getSid()
return the non static version of the id for this record.double
getValue()
get the calculated value of the formulaboolean
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 flagsvoid
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
-
-
-
-
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 thisFormulaRecord
is followed by aStringRecord
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.
-
clone
public FormulaRecord clone()
-
-