org.zkoss.poi.ss.formula.ptg

Class TablePtg

java.lang.Object

org.zkoss.poi.ss.formula.ptg.Ptg

org.zkoss.poi.ss.formula.ptg.OperandPtg

org.zkoss.poi.ss.formula.ptg.AreaPtgBase

org.zkoss.poi.ss.formula.ptg.Area3DPtg

org.zkoss.poi.ss.formula.ptg.TablePtg

All Implemented Interfaces:

java.io.Serializable, java.lang.Cloneable, ExternSheetReferenceToken, AreaI, WorkbookDependentFormula

public class TablePtg
extends Area3DPtg

TODO: XSSF only

Since:

3.9.7

Author:

henri

See Also:

Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	TablePtg.Item

Nested classes/interfaces inherited from interface org.zkoss.poi.ss.formula.ptg.AreaI

AreaI.OffsetArea

Field Summary

Fields inherited from class org.zkoss.poi.ss.formula.ptg.Area3DPtg

sid

Fields inherited from class org.zkoss.poi.ss.formula.ptg.Ptg

CLASS_ARRAY, CLASS_REF, CLASS_VALUE, EMPTY_PTG_ARRAY

Constructor Summary

Constructors

Constructor and Description
TablePtg(int extIdx, int firstRow, int lastRow, int firstColumn, int lastColumn, java.lang.String tableName, TablePtg.Item[] items, java.lang.String[] columns, boolean inTable)

Method Summary

Modifier and Type	Method and Description
static java.lang.String	formatAsFormulaString(java.lang.String tableName, TablePtg.Item item1, TablePtg.Item item2, java.lang.String column1, java.lang.String column2, boolean inTable)
java.lang.String	getColumn1()
java.lang.String	getColumn2()
byte	getDefaultOperandClass()
TablePtg.Item	getItem1()
TablePtg.Item	getItem2()
int	getSize()
java.lang.String	getTableName()
void	setColumn1(java.lang.String column)
void	setColumn2(java.lang.String column)
void	setTableName(java.lang.String tableName)
java.lang.String	toCopyFormulaString()
java.lang.String	toFormulaString(FormulaRenderingWorkbook book)
java.lang.String	toInternalFormulaString(FormulaRenderingWorkbook book)
java.lang.String	toString() Overridden toString method to ensure object hash is not printed.
void	write(LittleEndianOutput out)

Methods inherited from class org.zkoss.poi.ss.formula.ptg.Area3DPtg

equals, format2DRefAsString, getExternSheetIndex, hashCode, setExternSheetIndex, toFormulaString

Methods inherited from class org.zkoss.poi.ss.formula.ptg.AreaPtgBase

formatReferenceAsString, getFirstColumn, getFirstColumnRaw, getFirstRow, getLastColumn, getLastColumnRaw, getLastRow, isFirstColRelative, isFirstRowRelative, isLastColRelative, isLastRowRelative, notImplemented, readCoordinates, setFirstColRelative, setFirstColumn, setFirstColumnRaw, setFirstRow, setFirstRowRelative, setLastColRelative, setLastColumn, setLastColumnRaw, setLastRow, setLastRowRelative, writeCoordinates

Methods inherited from class org.zkoss.poi.ss.formula.ptg.OperandPtg

copy, isBaseToken

Methods inherited from class org.zkoss.poi.ss.formula.ptg.Ptg

createPtg, doesFormulaReferToDeletedCell, getEncodedSize, getEncodedSizeWithoutArrayData, getPtgClass, getRVAType, readTokens, serializePtgs, setClass

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

TablePtg

public TablePtg(int extIdx,
                int firstRow,
                int lastRow,
                int firstColumn,
                int lastColumn,
                java.lang.String tableName,
                TablePtg.Item[] items,
                java.lang.String[] columns,
                boolean inTable)

Method Detail

getTableName

public java.lang.String getTableName()

setTableName

public void setTableName(java.lang.String tableName)

getItem1

public TablePtg.Item getItem1()

getItem2

public TablePtg.Item getItem2()

getColumn1

public java.lang.String getColumn1()

setColumn1

public void setColumn1(java.lang.String column)

getColumn2

public java.lang.String getColumn2()

setColumn2

public void setColumn2(java.lang.String column)

write

public void write(LittleEndianOutput out)

Overrides:

write in class Area3DPtg

getSize

public int getSize()

Overrides:

getSize in class Area3DPtg

Returns:

the encoded length of this Ptg, including the initial Ptg type identifier byte.

formatAsFormulaString

public static java.lang.String formatAsFormulaString(java.lang.String tableName,
                                                     TablePtg.Item item1,
                                                     TablePtg.Item item2,
                                                     java.lang.String column1,
                                                     java.lang.String column2,
                                                     boolean inTable)

toFormulaString

public java.lang.String toFormulaString(FormulaRenderingWorkbook book)

Specified by:

toFormulaString in interface WorkbookDependentFormula

Overrides:

toFormulaString in class Area3DPtg

Returns:

text representation of this area reference that can be used in text formulas. The sheet name will get properly delimited if required.

toInternalFormulaString

public java.lang.String toInternalFormulaString(FormulaRenderingWorkbook book)

Specified by:

toInternalFormulaString in interface WorkbookDependentFormula

Overrides:

toInternalFormulaString in class Area3DPtg

Returns:

text representation of this area reference that can be used in text formulas. The sheet name will get properly delimited if required.

getDefaultOperandClass

public byte getDefaultOperandClass()

Overrides:

getDefaultOperandClass in class AreaPtgBase

toString

public final java.lang.String toString()

Description copied from class: Ptg

Overridden toString method to ensure object hash is not printed. This helps get rid of gratuitous diffs when comparing two dumps Subclasses may output more relevant information by overriding this method

Overrides:

toString in class Area3DPtg

toCopyFormulaString

public java.lang.String toCopyFormulaString()