Top Description Fields Constructors Methods
org.apache.poi.hssf.usermodel.helpers

public final Class HSSFColumnShifter

extends ColumnShifter
Class Inheritance
Annotations
@Beta
Imports
org.apache.poi.hssf.usermodel.HSSFSheet, org.apache.poi.ss.formula.FormulaShifter, org.apache.poi.ss.formula.eval.NotImplementedException, org.apache.poi.ss.usermodel.helpers.ColumnShifter, org.apache.poi.util.Beta, .NotImplemented
Helper for shifting columns up or down
Since
POI 4.0.0

Field Summary

Inherited from org.apache.poi.ss.usermodel.helpers.ColumnShifter:
sheet

Constructor Summary

AccessConstructor and Description
public
HSSFColumnShifter(HSSFSheet sh)

Method Summary

Modifier and TypeMethod and Description
public void
updateConditionalFormatting(FormulaShifter
The FormulaShifter to use
formulaShifter)

Implements abstract org.apache.poi.ss.usermodel.helpers.BaseRowColShifter.updateConditionalFormatting.

Update conditional formatting

public void
updateFormulas(FormulaShifter formulaShifter)

Implements abstract org.apache.poi.ss.usermodel.helpers.BaseRowColShifter.updateFormulas.

Update formulas.

public void
updateNamedRanges(FormulaShifter formulaShifter)

Implements abstract org.apache.poi.ss.usermodel.helpers.BaseRowColShifter.updateNamedRanges.

Update named ranges

Inherited from org.apache.poi.ss.usermodel.helpers.ColumnShifter:
shiftColumnsshiftMergedRegions

Constructor Detail

HSSFColumnShifterback to summary
public HSSFColumnShifter(HSSFSheet sh)

Method Detail

updateConditionalFormattingback to summary
public void updateConditionalFormatting(FormulaShifter formulaShifter)

Implements abstract org.apache.poi.ss.usermodel.helpers.BaseRowColShifter.updateConditionalFormatting.

Doc from org.apache.poi.ss.usermodel.helpers.BaseRowColShifter.updateConditionalFormatting.

Update conditional formatting

Parameters
formulaShifter:FormulaShifter

The FormulaShifter to use

Annotations
@Override
@NotImplemented
updateFormulasback to summary
public void updateFormulas(FormulaShifter formulaShifter)

Implements abstract org.apache.poi.ss.usermodel.helpers.BaseRowColShifter.updateFormulas.

Doc from org.apache.poi.ss.usermodel.helpers.BaseRowColShifter.updateFormulas.

Update formulas.

Annotations
@Override
@NotImplemented
updateHyperlinksback to summary
public void updateHyperlinks(FormulaShifter formulaShifter)

Implements abstract org.apache.poi.ss.usermodel.helpers.BaseRowColShifter.updateHyperlinks.

Doc from org.apache.poi.ss.usermodel.helpers.BaseRowColShifter.updateHyperlinks.

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.

Parameters
formulaShifter:FormulaShifter

the formula shifting policy

Annotations
@Override
@NotImplemented
updateNamedRangesback to summary
public void updateNamedRanges(FormulaShifter formulaShifter)

Implements abstract org.apache.poi.ss.usermodel.helpers.BaseRowColShifter.updateNamedRanges.

Doc from org.apache.poi.ss.usermodel.helpers.BaseRowColShifter.updateNamedRanges.

Update named ranges

Annotations
@Override
@NotImplemented