Package org.apache.poi.ss.formula
Class FormulaShifter
java.lang.Object
org.apache.poi.ss.formula.FormulaShifter
Updates Formulas as rows or sheets are shifted
-
Method Summary
Modifier and TypeMethodDescriptionbooleanadjustFormula(Ptg[] ptgs, int currentExternSheetIx) static FormulaShiftercreateForColumnCopy(int externSheetIndex, String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version) static FormulaShiftercreateForColumnShift(int externSheetIndex, String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version) static FormulaShiftercreateForRowCopy(int externSheetIndex, String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version) static FormulaShiftercreateForRowShift(int externSheetIndex, String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version) static FormulaShiftercreateForSheetShift(int srcSheetIndex, int dstSheetIndex) toString()
-
Method Details
-
createForRowShift
public static FormulaShifter createForRowShift(int externSheetIndex, String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version) -
createForRowCopy
public static FormulaShifter createForRowCopy(int externSheetIndex, String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version) -
createForColumnShift
public static FormulaShifter createForColumnShift(int externSheetIndex, String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version) - Since:
- POI 4.0.0
-
createForColumnCopy
public static FormulaShifter createForColumnCopy(int externSheetIndex, String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version) - Since:
- POI 4.0.0
-
createForSheetShift
-
toString
-
adjustFormula
- Parameters:
ptgs- - if necessary, will get modified by this methodcurrentExternSheetIx- - the extern sheet index of the sheet that contains the formula being adjusted- Returns:
trueif a change was made to the formula tokens
-