org.apache.poi.ss.formula.ptg
Class Area3DPtg
java.lang.Object
org.apache.poi.ss.formula.ptg.Ptg
org.apache.poi.ss.formula.ptg.OperandPtg
org.apache.poi.ss.formula.ptg.AreaPtgBase
org.apache.poi.ss.formula.ptg.Area3DPtg
- All Implemented Interfaces:
- java.lang.Cloneable, ExternSheetReferenceToken, AreaI, WorkbookDependentFormula
public final class Area3DPtg
- extends AreaPtgBase
- implements WorkbookDependentFormula, ExternSheetReferenceToken
Title: Area 3D Ptg - 3D reference (Sheet + Area)
Description: Defined an area in Extern Sheet.
REFERENCE:
This is HSSF only, as it matches the HSSF file format way of
referring to the sheet by an extern index. The XSSF equivalent
is Area3DPxg
Field Summary |
static byte |
sid
|
Constructor Summary |
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)
|
Area3DPtg(java.lang.String arearef,
int externIdx)
|
Methods inherited from class org.apache.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 java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
sid
public static final byte sid
- See Also:
- Constant Field Values
Area3DPtg
public Area3DPtg(java.lang.String arearef,
int externIdx)
Area3DPtg
public Area3DPtg(LittleEndianInput in)
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)
toString
public 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 Ptg
write
public void write(LittleEndianOutput out)
- 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.
getExternSheetIndex
public int getExternSheetIndex()
- Specified by:
getExternSheetIndex
in interface ExternSheetReferenceToken
setExternSheetIndex
public void setExternSheetIndex(int index)
format2DRefAsString
public java.lang.String format2DRefAsString()
- Specified by:
format2DRefAsString
in interface ExternSheetReferenceToken
- Returns:
- formula text for this reference token without the qualifying sheet name
toFormulaString
public java.lang.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 java.lang.String toFormulaString()
- Description copied from class:
Ptg
- return a string representation of this token alone
- Overrides:
toFormulaString
in class AreaPtgBase
Copyright 2015 The Apache Software Foundation or
its licensors, as applicable.