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

## Uses of Class
org.apache.poi.hssf.record.formula.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.chart |
org.apache.poi.hssf.record.formula | formula package contains binary PTG structures used in Formulas
org.apache.poi.hssf.record.formula.eval |
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.

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, int formulaType)`
`static Ptg[]` | `HSSFFormulaParser.parse(java.lang.String formula, HSSFWorkbook workbook, int 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
`static Ptg[]` | `SharedFormulaRecord.convertSharedFormulas(Ptg[] ptgs, int formulaRow, int formulaColumn)` Creates a non shared formula from the shared formula counterpart Perhaps this functionality could be implemented in terms of the raw byte array inside `Formula`.
`Ptg` | `LbsDataSubRecord.getFormula()`
`Ptg[]` | `ArrayRecord.getFormulaTokens()`
`Ptg[]` | `SharedFormulaRecord.getFormulaTokens(FormulaRecord formula)`
`Ptg` | `TextObjectRecord.getLinkRefPtg()`
`Ptg[]` | `NameRecord.getNameDefinition()` gets the definition, reference (Formula)
`Ptg[]` | `FormulaRecord.getParsedExpression()`
`Ptg[]` | `CFRuleRecord.getParsedExpression1()` get the stack of the 1st expression as a list
`Ptg[]` | `CFRuleRecord.getParsedExpression2()` get the stack of the 2nd expression as a list

Methods in org.apache.poi.hssf.record with parameters of type Ptg
`static Ptg[]` | `SharedFormulaRecord.convertSharedFormulas(Ptg[] ptgs, int formulaRow, int formulaColumn)` Creates a non shared formula from the shared formula counterpart Perhaps this functionality could be implemented in terms of the raw byte array inside `Formula`.
`void` | `NameRecord.setNameDefinition(Ptg[] ptgs)`
`void` | `FormulaRecord.setParsedExpression(Ptg[] ptgs)`
`void` | `CFRuleRecord.setParsedExpression1(Ptg[] ptgs)`
`void` | `CFRuleRecord.setParsedExpression2(Ptg[] ptgs)`

Constructors in org.apache.poi.hssf.record with parameters of type Ptg
`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.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.record.formula

Subclasses of Ptg in org.apache.poi.hssf.record.formula
`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` | `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` | `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`
`class` | `NameXPtg`
`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` | `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.hssf.record.formula declared as Ptg
`static Ptg[]` | `Ptg.EMPTY_PTG_ARRAY`
`static Ptg` | `MissingArgPtg.instance`

Methods in org.apache.poi.hssf.record.formula 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.hssf.record.formula with parameters of type Ptg
`boolean` | `FormulaShifter.adjustFormula(Ptg[] ptgs, int currentExternSheetIx)`
`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.hssf.record.formula.eval

Constructors in org.apache.poi.hssf.record.formula.eval with parameters of type Ptg
`NumberEval(Ptg ptg)`
`StringEval(Ptg ptg)`

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

Methods in org.apache.poi.hssf.usermodel that return Ptg
`Ptg[]` | `DVConstraint.FormulaPair.getFormula1()`
`Ptg[]` | `DVConstraint.FormulaPair.getFormula2()`
`Ptg[]` | `HSSFEvaluationWorkbook.getFormulaTokens(EvaluationCell evalCell)`

Constructors in org.apache.poi.hssf.usermodel with parameters of type Ptg
`DVConstraint.FormulaPair(Ptg[] formula1, Ptg[] formula2)`
`DVConstraint.FormulaPair(Ptg[] formula1, Ptg[] formula2)`

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

Methods in org.apache.poi.ss.formula that return Ptg
`Ptg[]` | `EvaluationWorkbook.getFormulaTokens(EvaluationCell cell)`
`Ptg[]` | `EvaluationName.getNameDefinition()`
`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, int formulaType, int sheetIndex)` Parse a formula into a array of tokens

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

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