org.zkoss.poi.ss.formula

Class PtgShifter

java.lang.Object

org.zkoss.poi.ss.formula.PtgShifter

public class PtgShifter
extends java.lang.Object

Author:

henrichen

Constructor Summary

Constructors

Constructor and Description
PtgShifter(int externSheetIndex, int firstRow, int lastRow, int rowAmount, int firstCol, int lastCol, int colAmount, SpreadsheetVersion ver)

Method Summary

Modifier and Type	Method and Description
boolean	adjustFormula(Ptg[] ptgs, int currentExternSheetIx)
static Ptg	createDeletedRef(Ptg ptg)
static Ptg	createDeletedRef3d(java.lang.String bookName, Ptg ptg)
java.lang.String	toString()

Methods inherited from class java.lang.Object

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

Constructor Detail

PtgShifter

public PtgShifter(int externSheetIndex,
                  int firstRow,
                  int lastRow,
                  int rowAmount,
                  int firstCol,
                  int lastCol,
                  int colAmount,
                  SpreadsheetVersion ver)

Method Detail

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

adjustFormula

public boolean adjustFormula(Ptg[] ptgs,
                             int currentExternSheetIx)

Parameters:

ptgs - - if necessary, will get modified by this method

currentExternSheetIx - - the extern sheet index of the sheet that contains the formula being adjusted

Returns:

true if a change was made to the formula tokens

createDeletedRef

public static Ptg createDeletedRef(Ptg ptg)

createDeletedRef3d

public static Ptg createDeletedRef3d(java.lang.String bookName,
                                     Ptg ptg)