org.apache.poi.ss.formula.ptg

## Class Ref3DPtg

- java.lang.Object
- - org.apache.poi.ss.formula.ptg.Ptg
  - - org.apache.poi.ss.formula.ptg.OperandPtg
    - - org.apache.poi.ss.formula.ptg.RefPtgBase
      - - org.apache.poi.ss.formula.ptg.Ref3DPtg

- All Implemented Interfaces:
    Duplicatable, ExternSheetReferenceToken, WorkbookDependentFormula

      public final class Ref3DPtg
      extends RefPtgBase
      implements WorkbookDependentFormula, ExternSheetReferenceToken

  Reference 3D Ptg

  Defined a cell in extern sheet.

  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 `Ref3DPxg`

- - ### Field Summary

    Fields
    Modifier and Type | Field and Description
    --- | ---
    `static byte` | `sid`

    - ### Fields inherited from class org.apache.poi.ss.formula.ptg.Ptg

      `CLASS_ARRAY, CLASS_REF, CLASS_VALUE, EMPTY_PTG_ARRAY`

  - ### Constructor Summary

    Constructors
    Constructor and Description
    `Ref3DPtg(CellReference c, int externIdx)`
    `Ref3DPtg(LittleEndianInput in)`
    `Ref3DPtg(Ref3DPtg other)`
    `Ref3DPtg(java.lang.String cellref, int externIdx)`

  - ### Method Summary

    All Methods Instance Methods Concrete Methods
    Modifier and Type | Method and Description
    --- | ---
    `Ref3DPtg` | `copy()`
    `java.lang.String` | `format2DRefAsString()`
    `int` | `getExternSheetIndex()`
    `int` | `getSize()`
    `void` | `setExternSheetIndex(int index)`
    `java.lang.String` | `toFormulaString()` return a string representation of this token alone
    `java.lang.String` | `toFormulaString(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.apache.poi.ss.formula.ptg.RefPtgBase

      `formatReferenceAsString, getColumn, getDefaultOperandClass, getRow, isColRelative, isRowRelative, readCoordinates, setColRelative, setColumn, setRow, setRowRelative, writeCoordinates`

    - ### Methods inherited from class org.apache.poi.ss.formula.ptg.OperandPtg

      `isBaseToken`

    - ### Methods inherited from class org.apache.poi.ss.formula.ptg.Ptg

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

    - ### Methods inherited from class java.lang.Object

      `clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait`

- - ### Field Detail

    - #### sid

          public static final byte sid

      See Also:
        Constant Field Values

  - ### Constructor Detail

    - #### Ref3DPtg

          public Ref3DPtg(Ref3DPtg other)

    - #### Ref3DPtg

          public Ref3DPtg(LittleEndianInput in)

    - #### Ref3DPtg

          public Ref3DPtg(java.lang.String cellref,
                          int externIdx)

    - #### Ref3DPtg

          public Ref3DPtg(CellReference c,
                          int externIdx)

  - ### Method Detail

    - #### 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 cell 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
      Specified by:
        `toFormulaString` in class `Ptg`

    - #### copy

          public Ref3DPtg copy()

      Specified by:
        `copy` in interface `Duplicatable`
      Specified by:
        `copy` in class `OperandPtg`
      Returns:
        a deep copy of the implementing class / instance

Copyright 2020 The Apache Software Foundation or its licensors, as applicable.