Uses of Class
org.apache.poi.ss.formula.ptg.Ptg

Packages that use Ptg

Package	Description
org.apache.poi.hssf.model	Provides low level API structures for reading, writing, modifying XLS files.
org.apache.poi.hssf.record	Record package contains class representations for XLS binary strutures.
org.apache.poi.hssf.record.aggregates	The record aggregates are not real "records" but collections of records that act as a single record.
org.apache.poi.hssf.record.cf
org.apache.poi.hssf.record.chart
org.apache.poi.hssf.usermodel	The usermodel package maps HSSF low level structures to familiar workbook/sheet model
org.apache.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.apache.poi.ss.formula.eval
org.apache.poi.ss.formula.ptg	The formula package contains binary PTG structures used in Formulas
org.apache.poi.ss.usermodel
org.apache.poi.xssf.streaming
org.apache.poi.xssf.usermodel

Uses of Ptg in org.apache.poi.hssf.model

Methods in org.apache.poi.hssf.model that return Ptg

Modifier and Type	Method and Description
static Ptg[]	HSSFFormulaParser.parse(java.lang.String formula, HSSFWorkbook workbook) Convenience method for parsing cell formulas.
static Ptg[]	HSSFFormulaParser.parse(java.lang.String formula, HSSFWorkbook workbook, FormulaType formulaType)
static Ptg[]	HSSFFormulaParser.parse(java.lang.String formula, HSSFWorkbook workbook, FormulaType formulaType, int sheetIndex)

Methods in org.apache.poi.hssf.model with parameters of type Ptg

Modifier and Type	Method and Description
static java.lang.String	HSSFFormulaParser.toFormulaString(HSSFWorkbook book, Ptg[] ptgs) Static method to convert an array of Ptgs in RPN order to a human readable string format in infix mode.

Uses of Ptg in org.apache.poi.hssf.record

Methods in org.apache.poi.hssf.record that return Ptg

Modifier and Type	Method and Description
Ptg	LbsDataSubRecord.getFormula()
Ptg[]	DVRecord.getFormula1()
Ptg[]	DVRecord.getFormula2()
Ptg[]	ArrayRecord.getFormulaTokens()
Ptg[]	SharedFormulaRecord.getFormulaTokens(FormulaRecord formula) Convert formula into an array of Ptg tokens.
Ptg	TextObjectRecord.getLinkRefPtg()
Ptg[]	NameRecord.getNameDefinition() gets the definition, reference (Formula)
Ptg[]	ExternalNameRecord.getParsedExpression()
Ptg[]	OldFormulaRecord.getParsedExpression()
Ptg[]	FormulaRecord.getParsedExpression()
Ptg[]	CFRuleBase.getParsedExpression1() get the stack of the 1st expression as a list
Ptg[]	CFRuleBase.getParsedExpression2() get the stack of the 2nd expression as a list
Ptg[]	CFRule12Record.getParsedExpressionScale() get the stack of the scale expression as a list
static Ptg[]	CFRuleBase.parseFormula(java.lang.String formula, HSSFSheet sheet) TODO - parse conditional format formulas properly i.e.

Methods in org.apache.poi.hssf.record with parameters of type Ptg

Modifier and Type	Method and Description
void	NameRecord.setNameDefinition(Ptg[] ptgs)
void	ExternalNameRecord.setParsedExpression(Ptg[] ptgs)
void	FormulaRecord.setParsedExpression(Ptg[] ptgs)
void	CFRuleBase.setParsedExpression1(Ptg[] ptgs)
void	CFRuleBase.setParsedExpression2(Ptg[] ptgs)
void	CFRule12Record.setParsedExpressionScale(Ptg[] ptgs)

Constructors in org.apache.poi.hssf.record with parameters of type Ptg

Constructor and Description
CFRuleBase(byte conditionType, byte comparisonOperation, Ptg[] formula1, Ptg[] formula2)
CFRuleBase(byte conditionType, byte comparisonOperation, Ptg[] formula1, Ptg[] formula2)
DVRecord(int validationType, int operator, int errorStyle, boolean emptyCellAllowed, boolean suppressDropDownArrow, boolean isExplicitList, boolean showPromptBox, java.lang.String promptTitle, java.lang.String promptText, boolean showErrorBox, java.lang.String errorTitle, java.lang.String errorText, Ptg[] formula1, Ptg[] formula2, CellRangeAddressList regions)
DVRecord(int validationType, int operator, int errorStyle, boolean emptyCellAllowed, boolean suppressDropDownArrow, boolean isExplicitList, boolean showPromptBox, java.lang.String promptTitle, java.lang.String promptText, boolean showErrorBox, java.lang.String errorTitle, java.lang.String errorText, Ptg[] formula1, Ptg[] formula2, CellRangeAddressList regions)

Uses of Ptg in org.apache.poi.hssf.record.aggregates

Methods in org.apache.poi.hssf.record.aggregates that return Ptg

Modifier and Type	Method and Description
Ptg[]	FormulaRecordAggregate.getFormulaTokens()

Methods in org.apache.poi.hssf.record.aggregates with parameters of type Ptg

Modifier and Type	Method and Description
void	FormulaRecordAggregate.setArrayFormula(CellRangeAddress r, Ptg[] ptgs)
void	FormulaRecordAggregate.setParsedExpression(Ptg[] ptgs) Also checks for a related shared formula and unlinks it if found

Uses of Ptg in org.apache.poi.hssf.record.cf

Methods in org.apache.poi.hssf.record.cf that return Ptg

Modifier and Type	Method and Description
Ptg[]	Threshold.getParsedExpression()

Methods in org.apache.poi.hssf.record.cf with parameters of type Ptg

Modifier and Type	Method and Description
void	Threshold.setParsedExpression(Ptg[] ptgs)

Uses of Ptg in org.apache.poi.hssf.record.chart

Methods in org.apache.poi.hssf.record.chart that return Ptg

Modifier and Type	Method and Description
Ptg[]	LinkedDataRecord.getFormulaOfLink() Get the formula of link field for the LinkedData record.

Methods in org.apache.poi.hssf.record.chart with parameters of type Ptg

Modifier and Type	Method and Description
void	LinkedDataRecord.setFormulaOfLink(Ptg[] ptgs) Set the formula of link field for the LinkedData record.

Uses of Ptg in org.apache.poi.hssf.usermodel

Methods in org.apache.poi.hssf.usermodel that return Ptg

Modifier and Type	Method and Description
Ptg	HSSFEvaluationWorkbook.get3DReferencePtg(AreaReference areaRef, SheetIdentifier sheet)
Ptg	HSSFEvaluationWorkbook.get3DReferencePtg(CellReference cr, SheetIdentifier sheet)
Ptg[]	HSSFEvaluationWorkbook.getFormulaTokens(EvaluationCell evalCell)

Methods in org.apache.poi.hssf.usermodel with parameters of type Ptg

Modifier and Type	Method and Description
protected java.lang.String	HSSFConditionalFormattingRule.toFormulaString(Ptg[] parsedExpression)
protected static java.lang.String	HSSFConditionalFormattingRule.toFormulaString(Ptg[] parsedExpression, HSSFWorkbook workbook)

Uses of Ptg in org.apache.poi.ss.formula

Methods in org.apache.poi.ss.formula that return Ptg

Modifier and Type	Method and Description
Ptg[]	SharedFormula.convertSharedFormulas(Ptg[] ptgs, int formulaRow, int formulaColumn) Creates a non shared formula from the shared formula counterpart, i.e.
Ptg	FormulaParsingWorkbook.get3DReferencePtg(AreaReference area, SheetIdentifier sheet) Produce the appropriate Ptg for a 3d area reference
Ptg	FormulaParsingWorkbook.get3DReferencePtg(CellReference cell, SheetIdentifier sheet) Produce the appropriate Ptg for a 3d cell reference
Ptg[]	EvaluationWorkbook.getFormulaTokens(EvaluationCell cell)
Ptg[]	EvaluationName.getNameDefinition()
Ptg	FormulaParsingWorkbook.getNameXPtg(java.lang.String name, SheetIdentifier sheet) Return an external name (named range, function, user-defined function) Ptg
Ptg[]	Formula.getTokens()
static Ptg[]	Formula.getTokens(Formula formula) Gets the Ptg array from the supplied Formula.
static Ptg[]	FormulaParser.parse(java.lang.String formula, FormulaParsingWorkbook workbook, FormulaType formulaType, int sheetIndex) Parse a formula into an array of tokens Side effect: creates name (Workbook.createName()) if formula contains unrecognized names (names are likely UDFs)
static Ptg[]	FormulaParser.parse(java.lang.String formula, FormulaParsingWorkbook workbook, FormulaType formulaType, int sheetIndex, int rowIndex) Parse a formula into an array of tokens Side effect: creates name (Workbook.createName()) if formula contains unrecognized names (names are likely UDFs)

Methods in org.apache.poi.ss.formula with parameters of type Ptg

Modifier and Type	Method and Description
boolean	FormulaShifter.adjustFormula(Ptg[] ptgs, int currentExternSheetIx)
protected boolean	WorkbookEvaluator.adjustRegionRelativeReference(Ptg[] ptgs, CellReference target, CellRangeAddressBase region) Adjust formula relative references by the offset between the start of the given region and the given target cell.
Ptg[]	SharedFormula.convertSharedFormulas(Ptg[] ptgs, int formulaRow, int formulaColumn) Creates a non shared formula from the shared formula counterpart, i.e.
static Formula	Formula.create(Ptg[] ptgs) Creates a Formula object from a supplied Ptg array.
static java.lang.String	FormulaRenderer.toFormulaString(FormulaRenderingWorkbook book, Ptg[] ptgs) Static method to convert an array of Ptgs in RPN order to a human readable string format in infix mode.

Uses of Ptg in org.apache.poi.ss.formula.eval

Constructors in org.apache.poi.ss.formula.eval with parameters of type Ptg

Constructor and Description
NumberEval(Ptg ptg)
StringEval(Ptg ptg)

Uses of Ptg in org.apache.poi.ss.formula.ptg

Subclasses of Ptg in org.apache.poi.ss.formula.ptg

Modifier and Type	Class and Description
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
class	AddPtg Addition operator PTG the "+" binomial operator.
class	Area2DPtgBase Common superclass of 2-D area refs
class	Area3DPtg Area 3D Ptg - 3D reference (Sheet + Area)
class	Area3DPxg XSSF Area 3D Reference (Sheet + Area)
class	AreaErrPtg AreaErr - handles deleted cell area references.
class	AreaNPtg Specifies a rectangular area of cells A1:A4 for instance.
class	AreaPtg Specifies a rectangular area of cells A1:A4 for instance.
class	AreaPtgBase Specifies a rectangular area of cells A1:A4 for instance.
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.
class	AttrPtg "Special Attributes"
class	BoolPtg Boolean (boolean) Stores a (java) boolean value in a formula.
class	ConcatPtg
class	ControlPtg
class	Deleted3DPxg An XSSF only representation of a reference to a deleted area
class	DeletedArea3DPtg Deleted Area 3D Ptg - 3D referecnce (Sheet + Area)
class	DeletedRef3DPtg Deleted Reference 3D Ptg
class	DividePtg This PTG implements the standard binomial divide "/"
class	EqualPtg
class	ErrPtg
class	ExpPtg
class	FuncPtg
class	FuncVarPtg
class	GreaterEqualPtg PTG class to implement greater or equal to
class	GreaterThanPtg Greater than operator PTG ">"
class	IntersectionPtg
class	IntPtg Integer (unsigned short integer) Stores an unsigned short value (java int) in a formula
class	LessEqualPtg Ptg class to implement less than or equal
class	LessThanPtg Less than operator PTG "<".
class	MemAreaPtg
class	MemErrPtg
class	MemFuncPtg
class	MissingArgPtg Missing Function Arguments
class	MultiplyPtg Implements the standard mathematical multiplication "*"
class	NamePtg See the spec at 2.5.198.76 PtgName
class	NameXPtg A Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.
class	NameXPxg A Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.
class	NotEqualPtg Ptg class to implement not equal
class	NumberPtg Number Stores a floating point value in a formula value stored in a 8 byte field using IEEE notation
class	OperandPtg
class	OperationPtg defines a Ptg that is an operation instead of an operand
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
class	PercentPtg Percent PTG.
class	PowerPtg
class	RangePtg
class	Ref3DPtg Reference 3D Ptg
class	Ref3DPxg XSSF 3D Reference
class	RefErrorPtg RefError - handles deleted cell reference
class	RefNPtg
class	RefPtg ReferencePtg - handles references (such as A1, A2, IA4)
class	RefPtgBase ReferencePtgBase - handles references (such as A1, A2, IA4)
class	ScalarConstantPtg Common superclass of all Ptgs that represent simple constant values.
class	StringPtg String Stores a String value in a formula value stored in the format <length 2 bytes>char[]
class	SubtractPtg
class	TblPtg This ptg indicates a data table.
class	UnaryMinusPtg Unary Plus operator - does not have any effect on the operand
class	UnaryPlusPtg Unary Plus operator - does not have any effect on the operand
class	UnionPtg
class	UnknownPtg
class	ValueOperatorPtg Common superclass of all value operators.

Fields in org.apache.poi.ss.formula.ptg declared as Ptg

Modifier and Type	Field and Description
static Ptg[]	Ptg.EMPTY_PTG_ARRAY
static Ptg	MissingArgPtg.instance

Methods in org.apache.poi.ss.formula.ptg that return Ptg

Modifier and Type	Method and Description
abstract Ptg	Ptg.copy()
static Ptg	Ptg.createPtg(LittleEndianInput in)
static Ptg[]	Ptg.readTokens(int size, LittleEndianInput in) Reads size bytes of the input stream, to create an array of Ptgs.

Methods in org.apache.poi.ss.formula.ptg with parameters of type Ptg

Modifier and Type	Method and Description
static boolean	Ptg.doesFormulaReferToDeletedCell(Ptg[] ptgs)
static int	Ptg.getEncodedSize(Ptg[] ptgs) This method will return the same result as getEncodedSizeWithoutArrayData(Ptg[]) if there are no array tokens present.
static int	Ptg.getEncodedSizeWithoutArrayData(Ptg[] ptgs) Used to calculate value that should be encoded at the start of the encoded Ptg token array;
static int	Ptg.serializePtgs(Ptg[] ptgs, byte[] array, int offset) Writes the ptgs to the data buffer, starting at the specified offset.

Constructors in org.apache.poi.ss.formula.ptg with parameters of type Ptg

Constructor and Description
Ptg(Ptg other)

Uses of Ptg in org.apache.poi.ss.usermodel

Methods in org.apache.poi.ss.usermodel with parameters of type Ptg

Modifier and Type	Method and Description
protected boolean	RangeCopier.adjustInBothDirections(Ptg[] ptgs, int sheetIndex, int deltaX, int deltaY)

Uses of Ptg in org.apache.poi.xssf.streaming

Methods in org.apache.poi.xssf.streaming that return Ptg

Modifier and Type	Method and Description
Ptg[]	SXSSFEvaluationWorkbook.getFormulaTokens(EvaluationCell evalCell)

Uses of Ptg in org.apache.poi.xssf.usermodel

Methods in org.apache.poi.xssf.usermodel that return Ptg

Modifier and Type	Method and Description
Ptg	BaseXSSFEvaluationWorkbook.get3DReferencePtg(AreaReference area, SheetIdentifier sheet)
Ptg	BaseXSSFEvaluationWorkbook.get3DReferencePtg(CellReference cell, SheetIdentifier sheet)
Ptg[]	XSSFEvaluationWorkbook.getFormulaTokens(EvaluationCell evalCell)