Package org.apache.poi.hssf.record
Class OldFormulaRecord
java.lang.Object
org.apache.poi.hssf.record.OldCellRecord
org.apache.poi.hssf.record.OldFormulaRecord
Formula Record (0x0006 / 0x0206 / 0x0406) - holds a formula in
encoded form, along with the value if a number
-
Field Summary
Fields -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionprotected void
Append specific debug info (used byOldCellRecord.toString()
for the value contained in this record.boolean
int
int
short
get the option flagsPtg[]
protected String
Gets the debug info BIFF record type name (used byOldCellRecord.toString()
.double
getValue()
get the calculated value of the formulaMethods inherited from class org.apache.poi.hssf.record.OldCellRecord
getCellAttrs, getColumn, getRow, getSid, getXFIndex, isBiff2, toString
-
Field Details
-
biff2_sid
public static final short biff2_sid- See Also:
-
biff3_sid
public static final short biff3_sid- See Also:
-
biff4_sid
public static final short biff4_sid- See Also:
-
biff5_sid
public static final short biff5_sid- See Also:
-
-
Constructor Details
-
OldFormulaRecord
-
-
Method Details
-
getCachedResultType
public int getCachedResultType() -
getCachedBooleanValue
public boolean getCachedBooleanValue() -
getCachedErrorValue
public int getCachedErrorValue() -
getValue
public double getValue()get the calculated value of the formula- Returns:
- calculated value
-
getOptions
public short getOptions()get the option flags- Returns:
- bitmask
-
getParsedExpression
- Returns:
- the formula tokens. never
null
-
getFormula
-
appendValueText
Description copied from class:OldCellRecord
Append specific debug info (used byOldCellRecord.toString()
for the value contained in this record. Trailing new-line should not be appended (superclass does that).- Specified by:
appendValueText
in classOldCellRecord
- Parameters:
sb
- the StringBuilder to append to
-
getRecordName
Description copied from class:OldCellRecord
Gets the debug info BIFF record type name (used byOldCellRecord.toString()
.- Specified by:
getRecordName
in classOldCellRecord
- Returns:
- the debug info BIFF record type name
-