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:
loci.poi.hssf.record
,FormulaRecord
-
Class Summary Class Description AbstractFunctionPtg 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 subclassesAddPtg Addition operator PTG the "+" binomial operator.Area3DPtg Title: Area 3D Ptg - 3D referecnce (Sheet + Area)AreaAPtg Specifies a rectangular area of cells A1:A4 for instance.AreaErrPtg AreaErr - handles deleted cell area references.AreaNAPtg Specifies a rectangular area of cells A1:A4 for instance.AreaNPtg Specifies a rectangular area of cells A1:A4 for instance.AreaNVPtg Specifies a rectangular area of cells A1:A4 for instance.AreaPtg Specifies a rectangular area of cells A1:A4 for instance.AreaVPtg Specifies a rectangular area of cells A1:A4 for instance.ArrayPtg 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 ArrayPtgA - handles arraysArrayPtgV 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.AttrPtg "Special Attributes" This seems to be a Misc Stuff and Junk record.BoolPtg Boolean (boolean) Stores a (java) boolean value in a formula.ConcatPtg ControlPtg DeletedArea3DPtg Title: Deleted Area 3D Ptg - 3D referecnce (Sheet + Area)DeletedRef3DPtg Title: Deleted Reference 3D PtgDividePtg This PTG implements the standard binomial divide "/"EqualPtg ErrPtg ExpPtg FuncPtg FuncVarPtg GreaterEqualPtg PTG class to implement greater or equal toGreaterThanPtg Greater than operator PTG ">"IntersectionPtg IntPtg Integer (short intger) Stores a (java) short value in a formulaLessEqualPtg Ptg class to implement less than or equalLessThanPtg Less than operator PTG "<".MemAreaPtg MemErrPtg MemFuncPtg MissingArgPtg Missing Function Arguments Avik Sengupta <avik at apache.org>MultiplyPtg Implements the standard mathmatical multiplication - *NamePtg NameXPtg NotEqualPtg Ptg class to implement not equalNumberPtg Number Stores a floating point value in a formula value stored in a 8 byte field using IEEE notationOperationPtg defines a Ptg that is an operation instead of an operandParenthesisPtg 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.PercentPtg Percent PTG.PowerPtg Ptg RangePtg Ref3DPtg Title: Reference 3D PtgRefAPtg RefNAPtgReferencePtg ReferencePtg - handles references (such as A1, A2, IA4)RefErrorPtg RefError - handles deleted cell referenceRefNAPtg RefNAPtgRefNPtg RefNPtgRefNVPtg RefNVPtgRefVPtg RefVPtgStringPtg Number Stores a String value in a formula value stored in the format <length 2 bytes>char[]SubtractPtg UnaryMinusPtg Unary Plus operator does not have any effect on the operandUnaryPlusPtg Unary Plus operator does not have any effect on the operandUnionPtg UnknownPtg