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

public final Class HSSFRowShifter

extends RowShifter
Class Inheritance
Imports
org.apache.poi.hssf.usermodel.HSSFRow, .HSSFSheet, org.apache.poi.ss.formula.FormulaShifter, org.apache.poi.ss.formula.eval.NotImplementedException, org.apache.poi.ss.usermodel.helpers.RowShifter, org.apache.poi.util.Internal, .NotImplemented
Helper for shifting rows up or down

Field Summary

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

Constructor Summary

AccessConstructor and Description
public
HSSFRowShifter(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

public void
updateRowFormulas(HSSFRow
the row to update the formulas on
row, FormulaShifter
the formula shifting policy
formulaShifter)

Update the formulas in specified row using the formula shifting policy specified by shifter

Inherited from org.apache.poi.ss.usermodel.helpers.RowShifter:
shiftMergedRegionsvalidateShiftLeftParametersvalidateShiftParameters

Constructor Detail

HSSFRowShifterback to summary
public HSSFRowShifter(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
updateRowFormulasback to summary
public void updateRowFormulas(HSSFRow row, FormulaShifter formulaShifter)

Update the formulas in specified row using the formula shifting policy specified by shifter

Parameters
row:HSSFRow

the row to update the formulas on

formulaShifter:FormulaShifter

the formula shifting policy

Annotations
@Internal
since:5.1.0