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.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.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, 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 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
 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[] ExternalNameRecord.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
 void NameRecord.setNameDefinition(Ptg[] ptgs)
           
 void FormulaRecord.setParsedExpression(Ptg[] ptgs)
           
 void ExternalNameRecord.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.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[] SharedFormula.convertSharedFormulas(Ptg[] ptgs, int formulaRow, int formulaColumn)
          Creates a non shared formula from the shared formula counterpart, i.e.
 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
 boolean FormulaShifter.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 java.lang.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.
 

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 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 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 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 Ptgs.
 

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.usermodel
 

Methods in org.apache.poi.xssf.usermodel that return Ptg
 Ptg[] XSSFEvaluationWorkbook.getFormulaTokens(EvaluationCell evalCell)
           
 



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