org.apache.poi.xssf.usermodel.helpers

Class XSSFRowShifter

java.lang.Object

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

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

org.apache.poi.xssf.usermodel.helpers.XSSFRowShifter

public final class XSSFRowShifter
extends RowShifter

Helper for shifting rows up or down

Field Summary

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

sheet

Constructor Summary

Constructors

Constructor and Description
XSSFRowShifter(XSSFSheet sh)

Method Summary

Modifier and Type	Method and Description
void	updateConditionalFormatting(FormulaShifter formulaShifter)
void	updateFormulas(FormulaShifter formulaShifter)
void	updateHyperlinks(FormulaShifter formulaShifter)
void	updateNamedRanges(FormulaShifter formulaShifter)
void	updateRowFormulas(XSSFRow row, FormulaShifter formulaShifter) 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, validateShiftLeftParameters, validateShiftParameters

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 Detail

XSSFRowShifter

public XSSFRowShifter(XSSFSheet sh)

Method Detail

updateNamedRanges

public void updateNamedRanges(FormulaShifter formulaShifter)

Specified by:

updateNamedRanges in class BaseRowColShifter

updateFormulas

public void updateFormulas(FormulaShifter formulaShifter)

Specified by:

updateFormulas in class BaseRowColShifter

updateRowFormulas

@Internal(since="3.15 beta 2")
public void updateRowFormulas(XSSFRow row,
                                                             FormulaShifter formulaShifter)

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

Parameters:

row - the row to update the formulas on

formulaShifter - the formula shifting policy

updateConditionalFormatting

public void updateConditionalFormatting(FormulaShifter formulaShifter)

Specified by:

updateConditionalFormatting in class BaseRowColShifter

updateHyperlinks

public void updateHyperlinks(FormulaShifter formulaShifter)

Specified by:

updateHyperlinks in class BaseRowColShifter