Package loci.poi.hssf.record.formula


package loci.poi.hssf.record.formula
formula package contains binary PTG structures used in Formulas

Related Documentation

For overviews, tutorials, examples, guides, and tool documentation, please see:
See Also:
  • Classes
    Class
    Description
    This class provides the base functionality for Excel sheet functions There are two kinds of function Ptgs - tFunc and tFuncVar Therefore, this class will have ONLY two subclasses
    Addition operator PTG the "+" binomial operator.
    Title: Area 3D Ptg - 3D referecnce (Sheet + Area)
    Specifies a rectangular area of cells A1:A4 for instance.
    AreaErr - handles deleted cell area references.
    Specifies a rectangular area of cells A1:A4 for instance.
    Specifies a rectangular area of cells A1:A4 for instance.
    Specifies a rectangular area of cells A1:A4 for instance.
    Specifies a rectangular area of cells A1:A4 for instance.
    Specifies a rectangular area of cells A1:A4 for instance.
    ArrayPtg - handles arrays The ArrayPtg is a little wierd, the size of the Ptg when parsing initially only includes the Ptg sid and the reserved bytes.
    ArrayPtgA - handles arrays
    ArrayPtg - handles arrays The ArrayPtg is a little wierd, the size of the Ptg when parsing initially only includes the Ptg sid and the reserved bytes.
    "Special Attributes" This seems to be a Misc Stuff and Junk record.
    Boolean (boolean) Stores a (java) boolean value in a formula.
     
     
    Title: Deleted Area 3D Ptg - 3D referecnce (Sheet + Area)
    Title: Deleted Reference 3D Ptg
    This PTG implements the standard binomial divide "/"
     
     
     
     
     
    PTG class to implement greater or equal to
    Greater than operator PTG ">"
     
    Integer (short intger) Stores a (java) short value in a formula
    Ptg class to implement less than or equal
    Less than operator PTG "<".
     
     
     
    Missing Function Arguments Avik Sengupta <avik at apache.org>
    Implements the standard mathmatical multiplication - *
     
     
    Ptg class to implement not equal
    Number Stores a floating point value in a formula value stored in a 8 byte field using IEEE notation
    defines a Ptg that is an operation instead of an operand
    While formula tokens are stored in RPN order and thus do not need parenthesis for precedence reasons, Parenthesis tokens ARE written to ensure that user entered parenthesis are displayed as-is on reading back Avik Sengupta <lists@aviksengupta.com> Andrew C.
    Percent PTG.
     
     
     
    Title: Reference 3D Ptg
    RefNAPtg
    ReferencePtg - handles references (such as A1, A2, IA4)
    RefError - handles deleted cell reference
    RefNAPtg
    RefNPtg
    RefNVPtg
    RefVPtg
    Number Stores a String value in a formula value stored in the format <length 2 bytes>char[]
     
    Unary Plus operator does not have any effect on the operand
    Unary Plus operator does not have any effect on the operand