Uses of Class
org.apache.poi.ss.formula.FormulaShifter

Packages that use FormulaShifter

Package	Description
org.apache.poi.hssf.model	Provides low level API structures for reading, writing, modifying XLS files.
org.apache.poi.hssf.record.aggregates	The record aggregates are not real "records" but collections of records that act as a single record.
org.apache.poi.hssf.usermodel.helpers
org.apache.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.apache.poi.ss.usermodel.helpers

Uses of FormulaShifter in org.apache.poi.hssf.model

Methods in org.apache.poi.hssf.model with parameters of type FormulaShifter

Modifier and Type	Method	Description
void	InternalSheet.updateFormulasAfterCellShift(FormulaShifter shifter, int externSheetIndex)	Updates formulas in cells and conditional formats due to moving of cells
void	InternalWorkbook.updateNamesAfterCellShift(FormulaShifter shifter)	Updates named ranges due to moving of cells

Uses of FormulaShifter in org.apache.poi.hssf.record.aggregates

Methods in org.apache.poi.hssf.record.aggregates with parameters of type FormulaShifter

Modifier and Type	Method	Description
boolean	CFRecordsAggregate.updateFormulasAfterCellShift(FormulaShifter shifter, int currentExternSheetIx)
void	ConditionalFormattingTable.updateFormulasAfterCellShift(FormulaShifter shifter, int externSheetIndex)
void	RowRecordsAggregate.updateFormulasAfterRowShift(FormulaShifter formulaShifter, int currentExternSheetIndex)
void	ValueRecordsAggregate.updateFormulasAfterRowShift(FormulaShifter shifter, int currentExternSheetIndex)

Uses of FormulaShifter in org.apache.poi.hssf.usermodel.helpers

Methods in org.apache.poi.hssf.usermodel.helpers with parameters of type FormulaShifter

Modifier and Type	Method	Description
void	HSSFColumnShifter.updateConditionalFormatting(FormulaShifter formulaShifter)
void	HSSFRowShifter.updateConditionalFormatting(FormulaShifter formulaShifter)
void	HSSFColumnShifter.updateFormulas(FormulaShifter formulaShifter)
void	HSSFRowShifter.updateFormulas(FormulaShifter formulaShifter)
void	HSSFColumnShifter.updateHyperlinks(FormulaShifter formulaShifter)
void	HSSFRowShifter.updateHyperlinks(FormulaShifter formulaShifter)
void	HSSFColumnShifter.updateNamedRanges(FormulaShifter formulaShifter)
void	HSSFRowShifter.updateNamedRanges(FormulaShifter formulaShifter)
void	HSSFRowShifter.updateRowFormulas(HSSFRow row, FormulaShifter formulaShifter)	Update the formulas in specified row using the formula shifting policy specified by shifter

Uses of FormulaShifter in org.apache.poi.ss.formula

Methods in org.apache.poi.ss.formula that return FormulaShifter

Modifier and Type	Method	Description
static FormulaShifter	FormulaShifter.createForColumnCopy(int externSheetIndex, String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version)
static FormulaShifter	FormulaShifter.createForColumnShift(int externSheetIndex, String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version)
static FormulaShifter	FormulaShifter.createForRowCopy(int externSheetIndex, String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version)
static FormulaShifter	FormulaShifter.createForRowShift(int externSheetIndex, String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version)
static FormulaShifter	FormulaShifter.createForSheetShift(int srcSheetIndex, int dstSheetIndex)

Uses of FormulaShifter in org.apache.poi.ss.usermodel.helpers

Methods in org.apache.poi.ss.usermodel.helpers with parameters of type FormulaShifter

Modifier and Type	Method	Description
static CellRangeAddress	BaseRowColShifter.shiftRange(FormulaShifter formulaShifter, CellRangeAddress cra, int currentExternSheetIx)
abstract void	BaseRowColShifter.updateConditionalFormatting(FormulaShifter formulaShifter)	Update conditional formatting
abstract void	BaseRowColShifter.updateFormulas(FormulaShifter formulaShifter)	Update formulas.
abstract void	BaseRowColShifter.updateHyperlinks(FormulaShifter formulaShifter)	Shift the Hyperlink anchors (not the hyperlink text, even if the hyperlink is of type LINK_DOCUMENT and refers to a cell that was shifted).
abstract void	BaseRowColShifter.updateNamedRanges(FormulaShifter formulaShifter)	Update named ranges