Package org.apache.poi.hssf.record.formula

formula package contains binary PTG structures used in Formulas (not yet supported!)

See:
          Description

Class Summary
AddPtg Addition operator PTG the "+" binomial operator.
Area3DPtg Title: Area 3D Ptg - 3D referecnce (Sheet + Area)
AreaPtg Specifies a rectangular area of cells A1:A4 for instance.
AttrPtg "Special Attributes" This seems to be a Misc Stuff and Junk record.
ConcatPtg  
DividePtg  
ExpPtg  
FormulaParser This class parses a formula string into a List of tokens in RPN order Inspired by Lets Build a Compiler, by Jack Crenshaw BNF for the formula expression is : ::= [ ]* ::= [ ::= | () | | ::= ([expression [, expression]*])
FunctionPtg This class provides functions with variable arguments.
IntPtg Integer (short intger) Stores a (java) short value in a formula
MemErrPtg  
MultiplyPtg  
NamePtg  
NumberPtg Number Stores a floating point value in a formula value stored in a 8 byte field using IEEE notation
OperationPtg defines a Ptg that is an operation instead of an operand
ParenthesisPtg 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 Andrew C.
PowerPtg  
Ptg  
Ref3DPtg Title: Reference 3D Ptg
ReferencePtg ValueReferencePtg - handles references (such as A1, A2, IA4) - Should also be made to handle relative versus absolute references but I don't know enough about using them in excel to know if its correct.
SubtractPtg  
UnknownPtg  
ValueVariableFunctionPtg An excel function with variable number of value arguments.
 

Package org.apache.poi.hssf.record.formula Description

formula package contains binary PTG structures used in Formulas (not yet supported!)

Related Documentation

For overviews, tutorials, examples, guides, and tool documentation, please see:

See Also:
org.apache.poi.hssf.record, FormulaRecord

jakarta-poi 1.6.0-dev

Copyright © 2002 Apache jakarta-poi project. All Rights Reserved.