org.apache.poi.hssf.usermodel.helpers

Class HSSFRowShifter

java.lang.Object

org.apache.poi.ss.usermodel.helpers.RowShifter

org.apache.poi.hssf.usermodel.helpers.HSSFRowShifter

public final class HSSFRowShifter
extends RowShifter

Helper for shifting rows up or down When possible, code should be implemented in the RowShifter abstract class to avoid duplication with XSSFRowShifter

Field Summary

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

sheet

Constructor Summary

Constructors

Constructor and Description
HSSFRowShifter(HSSFSheet sh)

Method Summary

Modifier and Type	Method and Description
void	updateConditionalFormatting(FormulaShifter shifter)
void	updateFormulas(FormulaShifter shifter) Update formulas.
void	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	updateNamedRanges(FormulaShifter shifter) Updated named ranges
void	updateRowFormulas(Row row, FormulaShifter shifter) Update the formulas in specified row using the formula shifting policy specified by shifter

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

shiftMergedRegions

Methods inherited from class java.lang.Object

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

Constructor Detail

HSSFRowShifter

public HSSFRowShifter(HSSFSheet sh)

Method Detail

updateNamedRanges

@NotImplemented
public void updateNamedRanges(FormulaShifter shifter)

Description copied from class: RowShifter

Updated named ranges

Specified by:

updateNamedRanges in class RowShifter

updateFormulas

@NotImplemented
public void updateFormulas(FormulaShifter shifter)

Description copied from class: RowShifter

Update formulas.

Specified by:

updateFormulas in class RowShifter

updateRowFormulas

@Internal
 @NotImplemented
public void updateRowFormulas(Row row,
                                                           FormulaShifter shifter)

Description copied from class: RowShifter

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

Specified by:

updateRowFormulas in class RowShifter

Parameters:

row - the row to update the formulas on

shifter - the formula shifting policy

updateConditionalFormatting

@NotImplemented
public void updateConditionalFormatting(FormulaShifter shifter)

Specified by:

updateConditionalFormatting in class RowShifter

updateHyperlinks

@NotImplemented
public void updateHyperlinks(FormulaShifter shifter)

Description copied from class: RowShifter

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 RowShifter

Parameters:

shifter - the formula shifting policy