Package org.apache.poi.ss.formula.ptg
package org.apache.poi.ss.formula.ptg
The formula package contains binary PTG structures used in Formulas
- See Also:
-
ClassDescriptionThis 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.Common superclass of 2-D area refsArea 3D Ptg - 3D reference (Sheet + Area)XSSF Area 3D Reference (Sheet + Area)AreaErr - handles deleted cell area references.Common interface for AreaPtg and Area3DPtg, and their child classes.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 weird, the size of the Ptg when parsing initially only includes the Ptg sid and the reserved bytes."Special Attributes"Boolean (boolean) Stores a (java) boolean value in a formula.An XSSF only representation of a reference to a deleted areaDeleted Area 3D Ptg - 3D referecnce (Sheet + Area)Deleted Reference 3D PtgThis PTG implements the standard binomial divide "/"PTG class to implement greater or equal toGreater than operator PTG ">"Integer (unsigned short integer) Stores an unsigned short value (java int) in a formulaPtg class to implement less than or equalLess than operator PTG "<".Missing Function ArgumentsImplements the standard mathematical multiplication "*"See the spec at 2.5.198.76 PtgNameA Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.A Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.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 backPercent PTG.
Ptg
represents a syntactic token in a formula.An XSSF only special kind of Ptg, which stores the sheet / book reference in string form.An XSSF only special kind of Ptg, which stores a range of sheet / book references in string form.Reference 3D PtgXSSF 3D ReferenceRefError - handles deleted cell referenceReferencePtg - handles references (such as A1, A2, IA4)ReferencePtgBase - handles references (such as A1, A2, IA4)Common superclass of allPtgs
that represent simple constant values.String Stores a String value in a formula value stored in the format <length 2 bytes>char[]This ptg indicates a data table.Unary Plus operator - does not have any effect on the operandUnary Plus operator - does not have any effect on the operandCommon superclass of all value operators.