|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
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 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[] |
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 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 |
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.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)
|
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |