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. |
formula package contains binary PTG structures used in Formulas (not yet supported!)