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

Packages that use FormulaShifter

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

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

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

Modifier and Type	Method and 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.zkoss.poi.hssf.record.aggregates

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

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

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

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

Modifier and Type	Method and Description
static FormulaShifter	FormulaShifter.createForColumnShift(int externSheetIndex, int firstMovedColIndex, int lastMovedColIndex, int numberOfColsToMove)
static FormulaShifter	FormulaShifter.createForRowShift(int externSheetIndex, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove)
static FormulaShifter	FormulaShifter.createForSheetShift(int srcSheetIndex, int dstSheetIndex)

Uses of FormulaShifter in org.zkoss.poi.xssf.usermodel.helpers

Methods in org.zkoss.poi.xssf.usermodel.helpers with parameters of type FormulaShifter

Modifier and Type	Method and Description
void	XSSFRowShifter.updateConditionalFormatting(FormulaShifter shifter)
void	XSSFRowShifter.updateFormulas(FormulaShifter shifter) Update formulas.
void	XSSFRowShifter.updateNamedRanges(FormulaShifter shifter) Updated named ranges