Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

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

Packages that use Ptg
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 | 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 | usermodel package maps HSSF low level strutures 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 | formula package contains binary PTG structures used in Formulas
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
`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
`static java.lang.String` | `HSSFFormulaParser.toFormulaString(HSSFWorkbook book, Ptg[] ptgs)` Static method to convert an array of `Ptg`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 Ptg
`Ptg` | `LbsDataSubRecord.getFormula()`
`Ptg[]` | `DVRecord.getFormula1()`
`Ptg[]` | `DVRecord.getFormula2()`
`Ptg[]` | `ArrayRecord.getFormulaTokens()`
`Ptg[]` | `SharedFormulaRecord.getFormulaTokens(FormulaRecord formula)`
`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
`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
`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
`Ptg[]` | `FormulaRecordAggregate.getFormulaTokens()`

Methods in org.apache.poi.hssf.record.aggregates with parameters of type Ptg
`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
`Ptg[]` | `Threshold.getParsedExpression()`

Methods in org.apache.poi.hssf.record.cf with parameters of type Ptg
`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
`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
`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
`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
`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
`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
`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.
`protected boolean` | `WorkbookEvaluator.adjustRegionRelativeReference(Ptg[] ptgs, int deltaRow, int deltaColumn)` Adjust the formula relative cell references by a given delta
`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 `Ptg`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
`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
`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` Title: Area 3D Ptg - 3D reference (Sheet + Area)
`class` | `Area3DPxg` Title: 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" This seems to be a Misc Stuff and Junk record.
`class` | `BoolPtg` Boolean (boolean) Stores a (java) boolean value in a formula.
`class` | `ConcatPtg`
`class` | `ControlPtg` Common superclass for tExp tTbl tParen tNlr tAttr tSheet tEndSheet
`class` | `Deleted3DPxg` An XSSF only representation of a reference to a deleted area
`class` | `DeletedArea3DPtg` Title: Deleted Area 3D Ptg - 3D referecnce (Sheet + Area)
`class` | `DeletedRef3DPtg` Title: 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 Avik Sengupta <avik at apache.org>
`class` | `MultiplyPtg` Implements the standard mathmatical 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 Avik Sengupta <lists@aviksengupta.com> Andrew C.
`class` | `PercentPtg` Percent PTG.
`class` | `PowerPtg`
`class` | `RangePtg`
`class` | `Ref3DPtg` Title: Reference 3D Ptg
`class` | `Ref3DPxg` Title: XSSF 3D Reference
`class` | `RefErrorPtg` RefError - handles deleted cell reference
`class` | `RefNPtg` 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 `Ptg`s 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
`static Ptg[]` | `Ptg.EMPTY_PTG_ARRAY`
`static Ptg` | `MissingArgPtg.instance`

Methods in org.apache.poi.ss.formula.ptg that return Ptg
`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 `Ptg`s.

Methods in org.apache.poi.ss.formula.ptg with parameters of type Ptg
`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.

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

Methods in org.apache.poi.xssf.streaming that return Ptg
`Ptg[]` | `SXSSFEvaluationWorkbook.getFormulaTokens(EvaluationCell evalCell)`

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

Methods in org.apache.poi.xssf.usermodel that return Ptg
`Ptg` | `BaseXSSFEvaluationWorkbook.get3DReferencePtg(AreaReference area, SheetIdentifier sheet)`
`Ptg` | `BaseXSSFEvaluationWorkbook.get3DReferencePtg(CellReference cell, SheetIdentifier sheet)`
`Ptg[]` | `XSSFEvaluationWorkbook.getFormulaTokens(EvaluationCell evalCell)`

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

Copyright 2017 The Apache Software Foundation or its licensors, as applicable.