org.zkoss.poi.ss.formula.ptg

Class Area3DPtg

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

All Implemented Interfaces:

Serializable, Cloneable, ExternSheetReferenceToken, AreaI, WorkbookDependentFormula

Direct Known Subclasses:

TablePtg

public class Area3DPtg
extends AreaPtgBase
implements WorkbookDependentFormula, ExternSheetReferenceToken

Title: Area 3D Ptg - 3D reference (Sheet + Area)

Description: Defined a area in Extern Sheet.

REFERENCE:

Author:

Libin Roman (Vista Portal LDT. Developer), avik, Jason Height (jheight at chariot dot net dot au)

See Also:

Serialized Form

Nested Class Summary

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

AreaI.OffsetArea

Field Summary

Fields

Modifier and Type	Field and Description
protected int	field_1_index_extern_sheet
static byte	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
Area3DPtg(AreaReference arearef, int externIdx)
Area3DPtg(int firstRow, int lastRow, int firstColumn, int lastColumn, boolean firstRowRelative, boolean lastRowRelative, boolean firstColRelative, boolean lastColRelative, int externalSheetIndex)
Area3DPtg(LittleEndianInput in, SpreadsheetVersion version)
Area3DPtg(String arearef, int externIdx)

Method Summary

Modifier and Type	Method and Description
boolean	equals(Object o)
String	format2DRefAsString()
int	getExternSheetIndex()
int	getSize()
int	getSize(SpreadsheetVersion version)
int	hashCode()
void	setExternSheetIndex(int index)
String	toFormulaString() return a string representation of this token alone
String	toFormulaString(FormulaRenderingWorkbook book)
String	toInternalFormulaString(FormulaRenderingWorkbook book)
String	toString() Overridden toString method to ensure object hash is not printed.
void	write(LittleEndianOutput out)
void	write(LittleEndianOutput out, SpreadsheetVersion version)

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

formatReferenceAsString, getDefaultOperandClass, 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

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

Methods inherited from class java.lang.Object

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

Field Detail

sid

public static final byte sid

See Also:

Constant Field Values

field_1_index_extern_sheet

protected int field_1_index_extern_sheet

Constructor Detail

Area3DPtg

public Area3DPtg(String arearef,
                 int externIdx)

Area3DPtg

public Area3DPtg(LittleEndianInput in,
                 SpreadsheetVersion version)

Area3DPtg

public Area3DPtg(int firstRow,
                 int lastRow,
                 int firstColumn,
                 int lastColumn,
                 boolean firstRowRelative,
                 boolean lastRowRelative,
                 boolean firstColRelative,
                 boolean lastColRelative,
                 int externalSheetIndex)

Area3DPtg

public Area3DPtg(AreaReference arearef,
                 int externIdx)

Method Detail

toString

public 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 Ptg

write

public void write(LittleEndianOutput out)

Specified by:

write in class Ptg

write

public void write(LittleEndianOutput out,
                  SpreadsheetVersion version)

Specified by:

write in class Ptg

getSize

public int getSize()

Specified by:

getSize in class Ptg

Returns:

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

getSize

public int getSize(SpreadsheetVersion version)

Specified by:

getSize in class Ptg

Returns:

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

getExternSheetIndex

public int getExternSheetIndex()

Specified by:

getExternSheetIndex in interface ExternSheetReferenceToken

setExternSheetIndex

public void setExternSheetIndex(int index)

format2DRefAsString

public String format2DRefAsString()

Specified by:

format2DRefAsString in interface ExternSheetReferenceToken

Returns:

formula text for this reference token without the qualifying sheet name

toFormulaString

public String toFormulaString(FormulaRenderingWorkbook book)

Specified by:

toFormulaString in interface WorkbookDependentFormula

Returns:

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

toFormulaString

public String toFormulaString()

Description copied from class: Ptg

return a string representation of this token alone

Overrides:

toFormulaString in class AreaPtgBase

hashCode

public int hashCode()

Overrides:

hashCode in class AreaPtgBase

equals

public boolean equals(Object o)

Overrides:

equals in class AreaPtgBase

toInternalFormulaString

public String toInternalFormulaString(FormulaRenderingWorkbook book)

Specified by:

toInternalFormulaString in interface WorkbookDependentFormula

Returns:

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