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 StringHSSFFormulaParser.toFormulaString(HSSFWorkbook book, Ptg[] ptgs) Static method to convert an array ofPtgs 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 ofPtgtokens.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 TypeMethodDescriptionvoidNameRecord.setNameDefinition(Ptg[] ptgs) voidExternalNameRecord.setParsedExpression(Ptg[] ptgs) voidFormulaRecord.setParsedExpression(Ptg[] ptgs) voidCFRuleBase.setParsedExpression1(Ptg[] ptgs) voidCFRuleBase.setParsedExpression2(Ptg[] ptgs) voidCFRule12Record.setParsedExpressionScale(Ptg[] ptgs) Constructors in org.apache.poi.hssf.record with parameters of type PtgModifierConstructorDescriptionprotectedCFRuleBase(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 TypeMethodDescriptionvoidFormulaRecordAggregate.setArrayFormula(CellRangeAddress r, Ptg[] ptgs) voidFormulaRecordAggregate.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 TypeMethodDescriptionvoidLinkedDataRecord.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 StringHSSFConditionalFormattingRule.toFormulaString(Ptg[] parsedExpression) protected static StringHSSFConditionalFormattingRule.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 TypeMethodDescriptionbooleanFormulaShifter.adjustFormula(Ptg[] ptgs, int currentExternSheetIx) protected booleanWorkbookEvaluator.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 Formulastatic StringFormulaRenderer.toFormulaString(FormulaRenderingWorkbook book, Ptg[] ptgs) Static method to convert an array ofPtgs 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 TypeClassDescriptionclassThis 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 classAddition operator PTG the "+" binomial operator.classCommon superclass of 2-D area refsfinal classTitle: Area 3D Ptg - 3D reference (Sheet + Area)final classTitle: XSSF Area 3D Reference (Sheet + Area)final classAreaErr - handles deleted cell area references.final classSpecifies a rectangular area of cells A1:A4 for instance.final classSpecifies a rectangular area of cells A1:A4 for instance.classSpecifies a rectangular area of cells A1:A4 for instance.final classArrayPtg - 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 classBoolean (boolean) Stores a (java) boolean value in a formula.final classclassCommon superclass for tExp tTbl tParen tNlr tAttr tSheet tEndSheetfinal classAn XSSF only representation of a reference to a deleted areafinal classTitle: Deleted Area 3D Ptg - 3D referecnce (Sheet + Area)final classTitle: Deleted Reference 3D Ptgfinal classThis PTG implements the standard binomial divide "/"final classfinal classfinal classfinal classfinal classfinal classPTG class to implement greater or equal tofinal classGreater than operator PTG ">"final classfinal classInteger (unsigned short integer) Stores an unsigned short value (java int) in a formulafinal classPtg class to implement less than or equalfinal classLess than operator PTG "<".final classfinal classfinal classfinal classMissing Function Arguments Avik Sengupta <avik at apache.org>final classImplements the standard mathmatical multiplication - *final classSee the spec at 2.5.198.76 PtgNamefinal classA Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.final classA Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.final classPtg class to implement not equalfinal classNumber Stores a floating point value in a formula value stored in a 8 byte field using IEEE notationclassclassdefines a Ptg that is an operation instead of an operandfinal classWhile 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 classPercent PTG.final classfinal classfinal classTitle: Reference 3D Ptgfinal classTitle: XSSF 3D Referencefinal classRefError - handles deleted cell referencefinal classRefNPtgfinal classReferencePtg - handles references (such as A1, A2, IA4)classReferencePtgBase - handles references (such as A1, A2, IA4)classCommon superclass of allPtgs that represent simple constant values.final classString Stores a String value in a formula value stored in the format <length 2 bytes>char[]final classfinal classThis ptg indicates a data table.final classUnary Plus operator does not have any effect on the operandfinal classUnary Plus operator does not have any effect on the operandfinal classclassclassCommon superclass of all value operators.Fields in org.apache.poi.ss.formula.ptg declared as PtgModifier and TypeFieldDescriptionstatic final Ptg[]Ptg.EMPTY_PTG_ARRAYstatic final PtgMissingArgPtg.instanceMethods in org.apache.poi.ss.formula.ptg that return PtgModifier and TypeMethodDescriptionstatic PtgPtg.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 booleanPtg.doesFormulaReferToDeletedCell(Ptg[] ptgs) static intPtg.getEncodedSize(Ptg[] ptgs) This method will return the same result asgetEncodedSizeWithoutArrayData(Ptg[])if there are no array tokens present.static intPtg.getEncodedSizeWithoutArrayData(Ptg[] ptgs) Used to calculate value that should be encoded at the start of the encoded Ptg token array;static intPtg.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 booleanRangeCopier.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)