Uses of Class
org.apache.poi.ss.formula.ptg.Ptg
Packages that use Ptg
Package
Description
Provides low level API structures for reading, writing, modifying XLS files.
Record package contains class representations for XLS binary strutures.
record aggregates are not real "records" but collections of records that act as a single record.
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
This package contains common internal POI code for manipulating formulas.
formula package contains binary PTG structures used in Formulas
-
Uses of Ptg in org.apache.poi.hssf.model
Methods in org.apache.poi.hssf.model that return PtgModifier and TypeMethodDescriptionstatic 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 PtgModifier and TypeMethodDescriptionstatic String
HSSFFormulaParser.toFormulaString
(HSSFWorkbook book, Ptg[] ptgs) Static method to convert an array ofPtg
s 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 PtgModifier and TypeMethodDescriptionLbsDataSubRecord.getFormula()
Ptg[]
DVRecord.getFormula1()
Ptg[]
DVRecord.getFormula2()
Ptg[]
ArrayRecord.getFormulaTokens()
Ptg[]
SharedFormulaRecord.getFormulaTokens
(FormulaRecord formula) Convert formula into an array ofPtg
tokens.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 listPtg[]
CFRuleBase.getParsedExpression2()
get the stack of the 2nd expression as a listPtg[]
CFRule12Record.getParsedExpressionScale()
get the stack of the scale expression as a liststatic 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 PtgModifier and TypeMethodDescriptionvoid
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 PtgModifierConstructorDescriptionprotected
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 PtgMethods in org.apache.poi.hssf.record.aggregates with parameters of type PtgModifier and TypeMethodDescriptionvoid
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 PtgMethods in org.apache.poi.hssf.record.cf with parameters of type Ptg -
Uses of Ptg in org.apache.poi.hssf.record.chart
Methods in org.apache.poi.hssf.record.chart that return PtgModifier and TypeMethodDescriptionPtg[]
LinkedDataRecord.getFormulaOfLink()
Get the formula of link field for the LinkedData record.Methods in org.apache.poi.hssf.record.chart with parameters of type PtgModifier and TypeMethodDescriptionvoid
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 PtgModifier and TypeMethodDescriptionHSSFEvaluationWorkbook.get3DReferencePtg
(AreaReference areaRef, SheetIdentifier sheet) HSSFEvaluationWorkbook.get3DReferencePtg
(CellReference cr, SheetIdentifier sheet) Ptg[]
HSSFEvaluationWorkbook.getFormulaTokens
(EvaluationCell evalCell) Methods in org.apache.poi.hssf.usermodel with parameters of type PtgModifier and TypeMethodDescriptionprotected String
HSSFConditionalFormattingRule.toFormulaString
(Ptg[] parsedExpression) protected static 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 PtgModifier and TypeMethodDescriptionPtg[]
SharedFormula.convertSharedFormulas
(Ptg[] ptgs, int formulaRow, int formulaColumn) Creates a non shared formula from the shared formula counterpart, i.e.FormulaParsingWorkbook.get3DReferencePtg
(AreaReference area, SheetIdentifier sheet) Produce the appropriate Ptg for a 3d area referenceFormulaParsingWorkbook.get3DReferencePtg
(CellReference cell, SheetIdentifier sheet) Produce the appropriate Ptg for a 3d cell referencePtg[]
EvaluationWorkbook.getFormulaTokens
(EvaluationCell cell) Ptg[]
EvaluationName.getNameDefinition()
FormulaParsingWorkbook.getNameXPtg
(String name, SheetIdentifier sheet) Return an external name (named range, function, user-defined function) PtgPtg[]
Formula.getTokens()
static Ptg[]
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)Methods in org.apache.poi.ss.formula with parameters of type PtgModifier and TypeMethodDescriptionboolean
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
static String
FormulaRenderer.toFormulaString
(FormulaRenderingWorkbook book, Ptg[] ptgs) Static method to convert an array ofPtg
s 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 -
Uses of Ptg in org.apache.poi.ss.formula.ptg
Subclasses of Ptg in org.apache.poi.ss.formula.ptgModifier and TypeClassDescriptionclass
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 subclassesfinal class
Addition operator PTG the "+" binomial operator.class
Common superclass of 2-D area refsfinal class
Title: Area 3D Ptg - 3D reference (Sheet + Area)final class
Title: XSSF Area 3D Reference (Sheet + Area)final class
AreaErr - handles deleted cell area references.final class
Specifies a rectangular area of cells A1:A4 for instance.final class
Specifies a rectangular area of cells A1:A4 for instance.class
Specifies a rectangular area of cells A1:A4 for instance.final class
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.final class
"Special Attributes" This seems to be a Misc Stuff and Junk record.final class
Boolean (boolean) Stores a (java) boolean value in a formula.final class
class
Common superclass for tExp tTbl tParen tNlr tAttr tSheet tEndSheetfinal class
An XSSF only representation of a reference to a deleted areafinal class
Title: Deleted Area 3D Ptg - 3D referecnce (Sheet + Area)final class
Title: Deleted Reference 3D Ptgfinal class
This PTG implements the standard binomial divide "/"final class
final class
final class
final class
final class
final class
PTG class to implement greater or equal tofinal class
Greater than operator PTG ">"final class
final class
Integer (unsigned short integer) Stores an unsigned short value (java int) in a formulafinal class
Ptg class to implement less than or equalfinal class
Less than operator PTG "<".final class
final class
final class
final class
Missing Function Arguments Avik Sengupta <avik at apache.org>final class
Implements the standard mathmatical multiplication - *final class
See the spec at 2.5.198.76 PtgNamefinal class
A Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.final class
A Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.final class
Ptg class to implement not equalfinal class
Number Stores a floating point value in a formula value stored in a 8 byte field using IEEE notationclass
class
defines a Ptg that is an operation instead of an operandfinal class
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.final class
Percent PTG.final class
final class
final class
Title: Reference 3D Ptgfinal class
Title: XSSF 3D Referencefinal class
RefError - handles deleted cell referencefinal class
RefNPtgfinal class
ReferencePtg - handles references (such as A1, A2, IA4)class
ReferencePtgBase - handles references (such as A1, A2, IA4)class
Common superclass of allPtg
s that represent simple constant values.final class
String Stores a String value in a formula value stored in the format <length 2 bytes>char[]final class
final class
This ptg indicates a data table.final class
Unary Plus operator does not have any effect on the operandfinal class
Unary Plus operator does not have any effect on the operandfinal class
class
class
Common superclass of all value operators.Fields in org.apache.poi.ss.formula.ptg declared as PtgModifier and TypeFieldDescriptionstatic final Ptg[]
Ptg.EMPTY_PTG_ARRAY
static final Ptg
MissingArgPtg.instance
Methods in org.apache.poi.ss.formula.ptg that return PtgModifier and TypeMethodDescriptionstatic 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 PtgModifier and TypeMethodDescriptionstatic boolean
Ptg.doesFormulaReferToDeletedCell
(Ptg[] ptgs) static int
Ptg.getEncodedSize
(Ptg[] ptgs) This method will return the same result asgetEncodedSizeWithoutArrayData(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. -
Uses of Ptg in org.apache.poi.ss.usermodel
Methods in org.apache.poi.ss.usermodel with parameters of type PtgModifier and TypeMethodDescriptionprotected 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 PtgModifier and TypeMethodDescriptionPtg[]
SXSSFEvaluationWorkbook.getFormulaTokens
(EvaluationCell evalCell) -
Uses of Ptg in org.apache.poi.xssf.usermodel
Methods in org.apache.poi.xssf.usermodel that return PtgModifier and TypeMethodDescriptionBaseXSSFEvaluationWorkbook.get3DReferencePtg
(AreaReference area, SheetIdentifier sheet) BaseXSSFEvaluationWorkbook.get3DReferencePtg
(CellReference cell, SheetIdentifier sheet) Ptg[]
XSSFEvaluationWorkbook.getFormulaTokens
(EvaluationCell evalCell)