Class Area3DPtg

All Implemented Interfaces:
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 Details

  • Constructor Details

    • Area3DPtg

      public Area3DPtg(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)
  • Method Details

    • 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
    • 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 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