Uses of Class
org.apache.poi.ss.formula.FormulaShifter
Packages that use FormulaShifter
Package
Description
Provides low level API structures for reading, writing, modifying XLS files.
record aggregates are not real "records" but collections of records that act as a single record.
This package contains common internal POI code for manipulating formulas.
-
Uses of FormulaShifter in org.apache.poi.hssf.model
Methods in org.apache.poi.hssf.model with parameters of type FormulaShifterModifier and TypeMethodDescriptionvoidInternalSheet.updateFormulasAfterCellShift(FormulaShifter shifter, int externSheetIndex) Updates formulas in cells and conditional formats due to moving of cellsvoidInternalWorkbook.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 FormulaShifterModifier and TypeMethodDescriptionbooleanCFRecordsAggregate.updateFormulasAfterCellShift(FormulaShifter shifter, int currentExternSheetIx) voidConditionalFormattingTable.updateFormulasAfterCellShift(FormulaShifter shifter, int externSheetIndex) voidRowRecordsAggregate.updateFormulasAfterRowShift(FormulaShifter formulaShifter, int currentExternSheetIndex) voidValueRecordsAggregate.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 FormulaShifterModifier and TypeMethodDescriptionvoidHSSFColumnShifter.updateConditionalFormatting(FormulaShifter formulaShifter) voidHSSFRowShifter.updateConditionalFormatting(FormulaShifter formulaShifter) voidHSSFColumnShifter.updateFormulas(FormulaShifter formulaShifter) voidHSSFRowShifter.updateFormulas(FormulaShifter formulaShifter) voidHSSFColumnShifter.updateHyperlinks(FormulaShifter formulaShifter) voidHSSFRowShifter.updateHyperlinks(FormulaShifter formulaShifter) voidHSSFColumnShifter.updateNamedRanges(FormulaShifter formulaShifter) voidHSSFRowShifter.updateNamedRanges(FormulaShifter formulaShifter) -
Uses of FormulaShifter in org.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula that return FormulaShifterModifier and TypeMethodDescriptionstatic FormulaShifterFormulaShifter.createForColumnCopy(int externSheetIndex, String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version) static FormulaShifterFormulaShifter.createForColumnShift(int externSheetIndex, String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version) static FormulaShifterFormulaShifter.createForRowCopy(int externSheetIndex, String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version) static FormulaShifterFormulaShifter.createForRowShift(int externSheetIndex, String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version) static FormulaShifterFormulaShifter.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 FormulaShifterModifier and TypeMethodDescriptionstatic CellRangeAddressBaseRowColShifter.shiftRange(FormulaShifter formulaShifter, CellRangeAddress cra, int currentExternSheetIx) abstract voidBaseRowColShifter.updateConditionalFormatting(FormulaShifter formulaShifter) Update conditional formattingabstract voidBaseRowColShifter.updateFormulas(FormulaShifter formulaShifter) Update formulas.abstract voidBaseRowColShifter.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 voidBaseRowColShifter.updateNamedRanges(FormulaShifter formulaShifter) Update named ranges -
Uses of FormulaShifter in org.apache.poi.xssf.usermodel.helpers
Methods in org.apache.poi.xssf.usermodel.helpers with parameters of type FormulaShifterModifier and TypeMethodDescriptionvoidXSSFColumnShifter.updateConditionalFormatting(FormulaShifter formulaShifter) voidXSSFRowShifter.updateConditionalFormatting(FormulaShifter formulaShifter) voidXSSFColumnShifter.updateFormulas(FormulaShifter formulaShifter) voidXSSFRowShifter.updateFormulas(FormulaShifter formulaShifter) voidXSSFColumnShifter.updateHyperlinks(FormulaShifter formulaShifter) voidXSSFRowShifter.updateHyperlinks(FormulaShifter formulaShifter) voidXSSFColumnShifter.updateNamedRanges(FormulaShifter formulaShifter) voidXSSFRowShifter.updateNamedRanges(FormulaShifter formulaShifter) voidXSSFRowShifter.updateRowFormulas(XSSFRow row, FormulaShifter formulaShifter) Update the formulas in specified row using the formula shifting policy specified by shifter