org.zkoss.poi.ss.formula

Class FormulaShifter

java.lang.Object

org.zkoss.poi.ss.formula.FormulaShifter

public final class FormulaShifter
extends java.lang.Object

Author:

Josh Micich

Method Summary

Modifier and Type	Method and Description
boolean	adjustFormula(Ptg[] ptgs, int currentExternSheetIx)
static FormulaShifter	createForColumnShift(int externSheetIndex, int firstMovedColIndex, int lastMovedColIndex, int numberOfColsToMove)
static FormulaShifter	createForRowShift(int externSheetIndex, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove)
static FormulaShifter	createForSheetShift(int srcSheetIndex, int dstSheetIndex)
java.lang.String	toString()

Methods inherited from class java.lang.Object

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

Method Detail

createForRowShift

public static FormulaShifter createForRowShift(int externSheetIndex,
                                               int firstMovedRowIndex,
                                               int lastMovedRowIndex,
                                               int numberOfRowsToMove)

createForSheetShift

public static FormulaShifter createForSheetShift(int srcSheetIndex,
                                                 int dstSheetIndex)

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

createForColumnShift

public static FormulaShifter createForColumnShift(int externSheetIndex,
                                                  int firstMovedColIndex,
                                                  int lastMovedColIndex,
                                                  int numberOfColsToMove)