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:
-
ClassesClassDescriptionThis 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 subclassesAddition 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 arraysArrayPtg - 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 PtgThis PTG implements the standard binomial divide "/"PTG class to implement greater or equal toGreater than operator PTG ">"Integer (short intger) Stores a (java) short value in a formulaPtg class to implement less than or equalLess than operator PTG "<".Missing Function Arguments Avik Sengupta <avik at apache.org>Implements the standard mathmatical multiplication - *Ptg class to implement not equalNumber Stores a floating point value in a formula value stored in a 8 byte field using IEEE notationdefines a Ptg that is an operation instead of an operandWhile 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 PtgRefNAPtgReferencePtg - handles references (such as A1, A2, IA4)RefError - handles deleted cell referenceRefNAPtgRefNPtgRefNVPtgRefVPtgNumber 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 operandUnary Plus operator does not have any effect on the operand