Package org.apache.poi.xssf.usermodel.helpers

Class XSSFColumnShifter

java.lang.Object

org.apache.poi.ss.usermodel.helpers.BaseRowColShifter

org.apache.poi.ss.usermodel.helpers.ColumnShifter

org.apache.poi.xssf.usermodel.helpers.XSSFColumnShifter

@Beta
public final class XSSFColumnShifter
extends ColumnShifter

Helper for shifting columns up or down

Since:

4.0.0

Field Summary

Fields inherited from class org.apache.poi.ss.usermodel.helpers.ColumnShifter

sheet

Constructor Summary

Constructors

Constructor	Description
XSSFColumnShifter(XSSFSheet sh)

Method Summary

Modifier and Type	Method	Description
void	shiftDrawingAnchors(int startColumn, int endColumn, int n)	Shift the anchors of the shapes (charts, pictures, ...) in the sheet's drawing along with the columns they are anchored to.
void	updateConditionalFormatting(FormulaShifter formulaShifter)	Update conditional formatting
void	updateFormulas(FormulaShifter formulaShifter)	Update formulas.
void	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).
void	updateNamedRanges(FormulaShifter formulaShifter)	Update named ranges

Methods inherited from class org.apache.poi.ss.usermodel.helpers.ColumnShifter

shiftColumns, shiftMergedRegions

Methods inherited from class org.apache.poi.ss.usermodel.helpers.BaseRowColShifter

shiftRange

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

XSSFColumnShifter

public XSSFColumnShifter(XSSFSheet sh)

Method Details

updateNamedRanges

public void updateNamedRanges(FormulaShifter formulaShifter)

Description copied from class: BaseRowColShifter

Update named ranges

Specified by:

updateNamedRanges in class BaseRowColShifter

updateFormulas

public void updateFormulas(FormulaShifter formulaShifter)

Description copied from class: BaseRowColShifter

Update formulas.

Specified by:

updateFormulas in class BaseRowColShifter

updateConditionalFormatting

public void updateConditionalFormatting(FormulaShifter formulaShifter)

Description copied from class: BaseRowColShifter

Update conditional formatting

Specified by:

updateConditionalFormatting in class BaseRowColShifter

Parameters:

formulaShifter - The FormulaShifter to use

updateHyperlinks

public void updateHyperlinks(FormulaShifter formulaShifter)

Description copied from class: BaseRowColShifter

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). Hyperlinks do not track the content they point to.

Specified by:

updateHyperlinks in class BaseRowColShifter

Parameters:

formulaShifter - the formula shifting policy

shiftDrawingAnchors

public void shiftDrawingAnchors(int startColumn,
 int endColumn,
 int n)

Shift the anchors of the shapes (charts, pictures, ...) in the sheet's drawing along with the columns they are anchored to. A shape is moved when its top-left anchor column is within [startColumn, endColumn]; the whole shape is moved so it keeps its size. Shapes with an absolute anchor are not moved.

Parameters:

startColumn - the column to start shifting

endColumn - the column to end shifting

n - the number of columns to shift

Since:

6.0.0