org.apache.poi.ss.formula
Class FormulaShifter
java.lang.Object
org.apache.poi.ss.formula.FormulaShifter
public final class FormulaShifter
- extends java.lang.Object
Updates Formulas as rows or sheets are shifted
|
Method Summary |
boolean |
adjustFormula(Ptg[] ptgs,
int currentExternSheetIx)
|
static FormulaShifter |
createForRowCopy(int externSheetIndex,
java.lang.String sheetName,
int firstMovedRowIndex,
int lastMovedRowIndex,
int numberOfRowsToMove,
SpreadsheetVersion version)
|
static FormulaShifter |
createForRowShift(int externSheetIndex,
java.lang.String sheetName,
int firstMovedRowIndex,
int lastMovedRowIndex,
int numberOfRowsToMove,
SpreadsheetVersion version)
|
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 |
createForRowShift
public static FormulaShifter createForRowShift(int externSheetIndex,
java.lang.String sheetName,
int firstMovedRowIndex,
int lastMovedRowIndex,
int numberOfRowsToMove,
SpreadsheetVersion version)
createForRowCopy
public static FormulaShifter createForRowCopy(int externSheetIndex,
java.lang.String sheetName,
int firstMovedRowIndex,
int lastMovedRowIndex,
int numberOfRowsToMove,
SpreadsheetVersion version)
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 methodcurrentExternSheetIx - - the extern sheet index of the sheet that contains the formula being adjusted
- Returns:
true if a change was made to the formula tokens