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.