Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

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

Packages that use FormulaShifter
org.apache.poi.hssf.model | Provides low level API structures for reading, writing, modifying XLS files.
org.apache.poi.hssf.record.aggregates | 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 |
org.apache.poi.xssf.usermodel.helpers |

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

Methods in org.apache.poi.hssf.model with parameters of type FormulaShifter
`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
`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
`void` | `HSSFRowShifter.updateConditionalFormatting(FormulaShifter shifter)`
`void` | `HSSFRowShifter.updateFormulas(FormulaShifter shifter)`
`void` | `HSSFRowShifter.updateHyperlinks(FormulaShifter shifter)`
`void` | `HSSFRowShifter.updateNamedRanges(FormulaShifter shifter)`
`void` | `HSSFRowShifter.updateRowFormulas(Row row, FormulaShifter shifter)`

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

Methods in org.apache.poi.ss.formula that return FormulaShifter
`static FormulaShifter` | `FormulaShifter.createForRowCopy(int externSheetIndex, java.lang.String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version)`
`static FormulaShifter` | `FormulaShifter.createForRowShift(int externSheetIndex, java.lang.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
`abstract void` | `RowShifter.updateConditionalFormatting(FormulaShifter shifter)`
`abstract void` | `RowShifter.updateFormulas(FormulaShifter shifter)` Update formulas.
`abstract void` | `RowShifter.updateHyperlinks(FormulaShifter shifter)` 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` | `RowShifter.updateNamedRanges(FormulaShifter shifter)` Updated named ranges
`abstract void` | `RowShifter.updateRowFormulas(Row row, FormulaShifter shifter)` Update the formulas in specified row using the formula shifting policy specified by shifter

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

Methods in org.apache.poi.xssf.usermodel.helpers with parameters of type FormulaShifter
`void` | `XSSFRowShifter.updateConditionalFormatting(FormulaShifter shifter)`
`void` | `XSSFRowShifter.updateFormulas(FormulaShifter shifter)` Update formulas.
`void` | `XSSFRowShifter.updateHyperlinks(FormulaShifter shifter)` 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).
`void` | `XSSFRowShifter.updateNamedRanges(FormulaShifter shifter)` Updated named ranges
`void` | `XSSFRowShifter.updateRowFormulas(Row row, FormulaShifter shifter)` Update the formulas in specified row using the formula shifting policy specified by shifter

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

Copyright 2017 The Apache Software Foundation or its licensors, as applicable.