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 Details

  • Constructor Details

  • 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

      public Ptg[] getParsedExpression()
      Returns:
      the formula tokens. never null
    • getFormula

      public Formula getFormula()
    • appendValueText

      protected void appendValueText(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 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