Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

## org.apache.poi.hssf.record
Class OldFormulaRecord

    java.lang.Object
      org.apache.poi.hssf.record.OldCellRecord
          org.apache.poi.hssf.record.OldFormulaRecord

    public final class OldFormulaRecord

extends OldCellRecord

Formula Record (0x0006 / 0x0206 / 0x0406) - holds a formula in encoded form, along with the value if a number

Field Summary
`static short` | `biff2_sid`
`static short` | `biff3_sid`
`static short` | `biff4_sid`
`static short` | `biff5_sid`

Constructor Summary
`OldFormulaRecord(RecordInputStream ris)`

Method Summary
`protected void` | `appendValueText(java.lang.StringBuilder sb)` Append specific debug info (used by `OldCellRecord.toString()` for the value contained in this record.
`boolean` | `getCachedBooleanValue()`
`int` | `getCachedErrorValue()`
`int` | `getCachedResultType()`
`Formula` | `getFormula()`
`short` | `getOptions()` get the option flags
`Ptg[]` | `getParsedExpression()`
`protected java.lang.String` | `getRecordName()` Gets the debug info BIFF record type name (used by `OldCellRecord.toString()`.
`double` | `getValue()` get the calculated value of the formula

Methods inherited from class org.apache.poi.hssf.record.OldCellRecord
`getCellAttrs, getColumn, getRow, getSid, getXFIndex, isBiff2, toString`

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait`

Field Detail

### biff2_sid

    public static final short biff2_sid

See Also:
  Constant Field Values

### biff3_sid

    public static final short biff3_sid

See Also:
  Constant Field Values

### biff4_sid

    public static final short biff4_sid

See Also:
  Constant Field Values

### biff5_sid

    public static final short biff5_sid

See Also:
  Constant Field Values

Constructor Detail

### OldFormulaRecord

    public OldFormulaRecord(RecordInputStream ris)

Method Detail

### 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

    public Ptg[] getParsedExpression()

  Returns:
    the formula tokens. never `null`

### getFormula

    public Formula getFormula()

### appendValueText

    protected void appendValueText(java.lang.StringBuilder sb)

  Description copied from class: `OldCellRecord`
  Append specific debug info (used by `OldCellRecord.toString()` for the value contained in this record. Trailing new-line should not be appended (superclass does that).

  Specified by:
    `appendValueText` in class `OldCellRecord`
  Parameters:
    `sb` - the StringBuilder to append to

### getRecordName

    protected java.lang.String getRecordName()

  Description copied from class: `OldCellRecord`
  Gets the debug info BIFF record type name (used by `OldCellRecord.toString()`.

  Specified by:
    `getRecordName` in class `OldCellRecord`
  Returns:
    the debug info BIFF record type name

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

Copyright 2017 The Apache Software Foundation or its licensors, as applicable.