Top Description Interfaces Classes
[default module]

Package org.apache.poi.ss.formula.ptg


The formula package contains binary PTG structures used in Formulas
See Also
org.apache.poi.hssf.record, org.apache.poi.hssf.record.FormulaRecord

Interface Summary

Modifier and TypeInterface and Description
public interface
AreaI

Common interface for AreaPtg and Area3DPtg, and their child classes.

public interface
Pxg

An XSSF only special kind of Ptg, which stores the sheet / book reference in string form.

public interface
Pxg3D

An XSSF only special kind of Ptg, which stores a range of sheet / book references in string form.

Class Summary

Modifier and TypeClass and Description
public abstract class
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 subclasses

public class
AddPtg

Addition operator PTG the "+" binomial operator.

public abstract class
Area2DPtgBase

Common superclass of 2-D area refs

public class
Area3DPtg

Area 3D Ptg - 3D reference (Sheet + Area)

Defined an area in Extern Sheet.

public class
Area3DPxg

XSSF Area 3D Reference (Sheet + Area)

Defined an area in an external or different sheet.

public class
AreaErrPtg

AreaErr - handles deleted cell area references.

public class
AreaNPtg

Specifies a rectangular area of cells A1:A4 for instance.

public class
AreaPtg

Specifies a rectangular area of cells A1:A4 for instance.

public abstract class
AreaPtgBase

Specifies a rectangular area of cells A1:A4 for instance.

pack-priv class
ArrayInitialPtg

Represents the initial plain tArray token (without the constant data that trails the whole formula).

public class
ArrayPtg

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.

public class
AttrPtg

"Special Attributes"

This seems to be a Misc Stuff and Junk record.

public class
BoolPtg

Boolean (boolean) Stores a (java) boolean value in a formula.

public class
public abstract class
public class
Deleted3DPxg

An XSSF only representation of a reference to a deleted area

public class
DeletedArea3DPtg

Deleted Area 3D Ptg - 3D referecnce (Sheet + Area)

Defined an area in Extern Sheet.

public class
DeletedRef3DPtg

Deleted Reference 3D Ptg

Defined a cell in extern sheet.

public class
DividePtg

This PTG implements the standard binomial divide "/"

public class
public class
public class
pack-priv class
public class
public class
public class
GreaterEqualPtg

PTG class to implement greater or equal to

public class
GreaterThanPtg

Greater than operator PTG ">"

public class
public class
IntPtg

Integer (unsigned short integer) Stores an unsigned short value (java int) in a formula

public class
LessEqualPtg

Ptg class to implement less than or equal

public class
LessThanPtg

Less than operator PTG "<".

public class
public class
public class
public class
MissingArgPtg

Missing Function Arguments

public class
MultiplyPtg

Implements the standard mathematical multiplication "*"

public class
NamePtg

See the spec at 2.5.198.76 PtgName

public class
NameXPtg

A Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.

public class
NameXPxg

A Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.

public class
NotEqualPtg

Ptg class to implement not equal

public class
NumberPtg

Number Stores a floating point value in a formula value stored in a 8 byte field using IEEE notation

public abstract class
public abstract class
OperationPtg

defines a Ptg that is an operation instead of an operand

public class
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

public class
PercentPtg

Percent PTG.

public class
public abstract class
Ptg

Ptg represents a syntactic token in a formula.

public class
pack-priv abstract class
public class
Ref3DPtg

Reference 3D Ptg

Defined a cell in extern sheet.

public class
Ref3DPxg

XSSF 3D Reference

Defines a cell in an external or different sheet.

public class
RefErrorPtg

RefError - handles deleted cell reference

public class
public class
RefPtg

ReferencePtg - handles references (such as A1, A2, IA4)

public abstract class
RefPtgBase

ReferencePtgBase - handles references (such as A1, A2, IA4)

public abstract class
ScalarConstantPtg

Common superclass of all Ptgs that represent simple constant values.

public class
StringPtg

String Stores a String value in a formula value stored in the format <length 2 bytes>char[]

public class
public class
TblPtg

This ptg indicates a data table.

public class
UnaryMinusPtg

Unary Plus operator - does not have any effect on the operand

public class
UnaryPlusPtg

Unary Plus operator - does not have any effect on the operand

public class
public class
public abstract class
ValueOperatorPtg

Common superclass of all value operators.