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

Packages that use Ptg

Package	Description
io.keikai.model.impl.sys.formula	Keikai Spreadsheet Internal Book Model Implementation classes.
io.keikai.model.sys.formula	Keikai Spreadsheet Internal Book Model Engines classes.
io.keikaiex.formula	Classes bridging Keikai Spreadsheet formula functions to ZK EL functions.
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.formula.token
org.apache.poi.ss.usermodel
org.apache.poi.xssf.usermodel

Uses of Ptg in io.keikai.model.impl.sys.formula

Methods in io.keikai.model.impl.sys.formula that return Ptg

Modifier and Type	Method	Description
Ptg	EvalBook.get3DReferencePtg(AreaReference area, SheetIdentifier sheet)
Ptg	EvalBook.get3DReferencePtg(CellReference cell, SheetIdentifier sheet)
Ptg	ParsingBook.get3DReferencePtg(AreaReference areaRef, SheetIdentifier sheet)
Ptg	ParsingBook.get3DReferencePtg(CellReference cr, SheetIdentifier sheet)
Ptg[]	EvalBook.getFormulaTokens(int sheetIndex, String formula)
Ptg[]	EvalBook.getFormulaTokens(EvaluationCell cell)
Ptg	EvalBook.getNameXPtg(String name, SheetIdentifier sheet)
Ptg	ParsingBook.getNameXPtg(String name, SheetIdentifier sheet)
Ptg[]	FormulaEngineImpl.ErrorFormulaExpressionImpl.getPtgs()
Ptg[]	FormulaEngineImpl.FormulaExpressionImpl.getPtgs()
Ptg[]	FormulaEngineImpl.parse(String formula, FormulaParsingWorkbook book, int sheetIndex, FormulaParseContext context)

Methods in io.keikai.model.impl.sys.formula with parameters of type Ptg

Modifier and Type	Method	Description
void	DependencyTrackerImpl.addDependency(OperationEvaluationContext ec, Ptg[] ptgs)
boolean	FormulaEngineImpl.FormulaAdjuster.process(int sheetIndex, Ptg[] tokens, ParsingBook parsingBook, FormulaParseContext context)
protected String	FormulaEngineImpl.renderFormula(ParsingBook parsingBook, String formula, Ptg[] tokens, boolean always)
protected Ref	FormulaEngineImpl.toDependRef(FormulaParseContext ctx, ParsingBook parsingBook, Ptg ptg, int ptgIndex)

Constructors in io.keikai.model.impl.sys.formula with parameters of type Ptg

Constructor	Description
FormulaExpressionImpl(String formula, Ptg[] ptgs, Ref[] refs)
FormulaExpressionImpl(String formula, Ptg[] ptgs, Ref[] refs, boolean multipleArea)
FormulaExpressionImpl(String formula, Ptg[] ptgs, Ref[] refs, boolean error, String errorMessage, boolean multipleArea)

Uses of Ptg in io.keikai.model.sys.formula

Methods in io.keikai.model.sys.formula that return Ptg

Modifier and Type	Method	Description
Ptg[]	FormulaExpression.getPtgs()	Returns the cached parsing things.

Uses of Ptg in io.keikaiex.formula

Methods in io.keikaiex.formula that return Ptg

Modifier and Type	Method	Description
Ptg[]	FormulaEngineEx.parse(String formula, FormulaParsingWorkbook book, int sheetIndex, FormulaParseContext context)

Methods in io.keikaiex.formula with parameters of type Ptg

Modifier and Type	Method	Description
void	DependencyTrackerEx.addDependency(OperationEvaluationContext ec, Ptg[] ptgs)
protected String	FormulaEngineEx.renderFormula(ParsingBook parsingBook, String formula, Ptg[] tokens, boolean always)

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

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

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

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

Modifier and Type	Method	Description
static 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	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[]	FormulaRecord.getParsedExpression()
Ptg[]	OldFormulaRecord.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(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	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	Description
CFRuleBase(byte conditionType, byte comparisonOperation, Ptg[] formula1, Ptg[] formula2)
DVRecord(int validationType, int operator, int errorStyle, boolean emptyCellAllowed, boolean suppressDropDownArrow, boolean isExplicitList, boolean showPromptBox, String promptTitle, String promptText, boolean showErrorBox, String errorTitle, 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	Description
Ptg[]	FormulaRecordAggregate.getFormulaTokens()

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

Modifier and Type	Method	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	Description
Ptg[]	Threshold.getParsedExpression()

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

Modifier and Type	Method	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	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	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	Description
Ptg	HSSFEvaluationWorkbook.get3DReferencePtg(AreaReference areaRef, SheetIdentifier sheet)
Ptg	HSSFEvaluationWorkbook.get3DReferencePtg(CellReference cr, SheetIdentifier sheet)
Ptg[]	HSSFEvaluationWorkbook.getFormulaTokens(int sheetIndex, String formula)
Ptg[]	HSSFEvaluationWorkbook.getFormulaTokens(EvaluationCell evalCell)

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

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

Modifier and Type	Method	Description
Ptg[]	SharedFormula.convertSharedFormulas(Ptg[] ptgs, int formulaRow, int formulaColumn)	Creates a non shared formula from the shared formula counterpart, i.e.
static Ptg	FormulaShifter.createDeletedRef(Ptg ptg)
static Ptg	PtgShifter.createDeletedRef(Ptg ptg)
static Ptg	PtgShifter.createDeletedRef3d(String bookName, Ptg ptg)
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(int sheetIndex, String formula)
Ptg[]	EvaluationWorkbook.getFormulaTokens(EvaluationCell cell)
Ptg[]	EvaluationName.getNameDefinition()
Ptg	FormulaParsingWorkbook.getNameXPtg(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[]	Formula.getTokens(Formula formula, SpreadsheetVersion version)
Ptg[]	Formula.getTokens(SpreadsheetVersion version)
static Ptg[]	FormulaParser.parse(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(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)
static Ptg[]	FormulaParser.parse(String formula, FormulaParsingWorkbook workbook, FormulaType formulaType, int sheetIndex, int rowIndex, int colIndex)
static Ptg[]	FormulaTokenParser.parse(String formula, FormulaParsingWorkbook book, int sheetIndex, Locale locale, int rowIndex, int colIndex, FormulaType formulaType)
static Ptg[]	FormulaTokenParser.parse(String formula, FormulaParsingWorkbook book, int sheetIndex, FormulaType formulaType)
static Ptg[][]	FormulaRenderer.unwrapPtgArrays(Ptg[] ptgs)	Static method to convert an RPN ptgs in the form of (areaPtg1, areaPtg2, ...) to Ptg[][].

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

Modifier and Type	Method	Description
void	DependencyTracker.addDependency(OperationEvaluationContext ec, Ptg[] ptgs)	Construct formula reference dependencies.
boolean	FormulaShifter.adjustFormula(Ptg[] ptgs, int currentExternSheetIx)
boolean	PtgShifter.adjustFormula(Ptg[] ptgs, int currentExternSheetIx)
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 Ptg	FormulaShifter.createDeletedRef(Ptg ptg)
static Ptg	PtgShifter.createDeletedRef(Ptg ptg)
static Ptg	PtgShifter.createDeletedRef3d(String bookName, Ptg ptg)
static Formula	Formula.createX(Ptg[] ptgs)	Creates a Formula object from a supplied Ptg array with Xlsx version.
static String	FormulaRenderer.toFormulaCopyText(FormulaRenderingWorkbook book, Ptg[] tokens, String formula)
static String	FormulaRenderer.toFormulaEditText(FormulaRenderingWorkbook book, Ptg[] tokens, String formula)
static 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.
static String	FormulaRenderer.toInternalFormulaString(FormulaRenderingWorkbook book, Ptg[] ptgs)	Static method to convert an array of Ptgs in RPN order to internal string format for storing into file.
static Ptg[][]	FormulaRenderer.unwrapPtgArrays(Ptg[] ptgs)	Static method to convert an RPN ptgs in the form of (areaPtg1, areaPtg2, ...) to Ptg[][].

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

Constructor	Description
TokenOperandClassTransformer(FormulaType formulaType, List<Ptg> ptgs)

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

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

Constructor	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	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	DeferredNamePtg	A defined name is only used for parsing and evaluation which will not be written out.
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	Parenthesis2Ptg	This Ptg is for multiple area expression generally used in chart series and is only used for parsing and evaluation which will not be written out.
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	TablePtg	TODO: XSSF only
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	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	Description
Ptg	Parenthesis2Ptg.copy()
abstract Ptg	Ptg.copy()
static Ptg	Ptg.createPtg(LittleEndianInput in)
static Ptg	Ptg.createPtg(LittleEndianInput in, SpreadsheetVersion version)
static Ptg[]	Ptg.readTokens(int size, LittleEndianInput in)	Reads size bytes of the input stream, to create an array of Ptgs.
static Ptg[]	Ptg.readTokens(int size, LittleEndianInput in, SpreadsheetVersion version)

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

Modifier and Type	Method	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.getEncodedSize(Ptg[] ptgs, SpreadsheetVersion version)	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.getEncodedSizeWithoutArrayData(Ptg[] ptgs, SpreadsheetVersion version)
static int	Ptg.serializePtgs(Ptg[] ptgs, byte[] array, int offset)	Writes the ptgs to the data buffer, starting at the specified offset.
static int	Ptg.serializePtgs(Ptg[] ptgs, byte[] array, int offset, SpreadsheetVersion version)

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

Constructor	Description
Ptg(Ptg other)

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

Methods in org.apache.poi.ss.formula.token that return types with arguments of type Ptg

Modifier and Type	Method	Description
List<Ptg>	TokenToPtgVisitor.visitAdd(AddNode node)
List<Ptg>	TokenToPtgVisitor.visitAnd(AndNode node)
List<Ptg>	TokenToPtgVisitor.visitAreaRef(AreaRefNode node)
List<Ptg>	TokenToPtgVisitor.visitArrayColumns(ArrayColumnsNode node)
List<Ptg>	TokenToPtgVisitor.visitBoolean(BoolNode node)
List<Ptg>	TokenToPtgVisitor.visitColon(ColonNode node)
List<Ptg>	TokenToPtgVisitor.visitComma(CommaNode node)
List<Ptg>	TokenToPtgVisitor.visitDiv(DivNode node)
List<Ptg>	TokenToPtgVisitor.visitEmpty(EmptyNode node)
List<Ptg>	TokenToPtgVisitor.visitEqual(EqualNode node)
List<Ptg>	TokenToPtgVisitor.visitError(ErrorNode node)
List<Ptg>	TokenToPtgVisitor.visitErrorRef(ErrorRefNode node)
List<Ptg>	TokenToPtgVisitor.visitExp(ExpNode node)
List<Ptg>	TokenToPtgVisitor.visitFunction(FunctionNode node)
List<Ptg>	TokenToPtgVisitor.visitGreat(GreatNode node)
List<Ptg>	TokenToPtgVisitor.visitGreaterThanEqual(GreaterThanEqualNode node)
List<Ptg>	TokenToPtgVisitor.visitLess(LessNode node)
List<Ptg>	TokenToPtgVisitor.visitLessThanEqual(LessThanEqualNode node)
List<Ptg>	TokenToPtgVisitor.visitMinus(MinusNode node)
List<Ptg>	TokenToPtgVisitor.visitMulti(MultiNode node)
List<Ptg>	TokenToPtgVisitor.visitName(NameNode node)
List<Ptg>	TokenToPtgVisitor.visitNameRef(NameRefNode node)
List<Ptg>	TokenToPtgVisitor.visitNotEqual(NotEqualNode node)
<T extends Number> List<Ptg>	TokenToPtgVisitor.visitNumber(NumberNode<T> node)
List<Ptg>	TokenToPtgVisitor.visitPercent(PercentNode node)
List<Ptg>	TokenToPtgVisitor.visitPlus(PlusNode node)
List<Ptg>	TokenToPtgVisitor.visitRef(RefNode node)
List<Ptg>	TokenToPtgVisitor.visitSpace(SpaceNode node)
List<Ptg>	TokenToPtgVisitor.visitString(StringNode node)
List<Ptg>	TokenToPtgVisitor.visitSubtract(SubtractNode node)
List<Ptg>	TokenToPtgVisitor.visitTableRef(TableRefNode node)
List<Ptg>	TokenToPtgVisitor.visitUnion(UnionNode node)

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	Description
protected boolean	RangeCopier.adjustInBothDirections(Ptg[] ptgs, int sheetIndex, int deltaX, int deltaY)

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

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

Modifier and Type	Method	Description
static Ptg[]	XSSFEvaluationWorkbookInterceptor.getFormulaTokens(org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook workbook, EvaluationCell evalCell)