public final class XSSFRowShifter
extends java.lang.Object
| Constructor and Description |
|---|
XSSFRowShifter(XSSFSheet sh) |
| Modifier and Type | Method and Description |
|---|---|
java.util.List<CellRangeAddress> |
shiftMerged(int startRow,
int endRow,
int n)
Shift merged regions
|
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(XSSFRow row,
FormulaShifter shifter)
Update the formulas in specified row using the formula shifting policy specified by shifter
|
public XSSFRowShifter(XSSFSheet sh)
public java.util.List<CellRangeAddress> shiftMerged(int startRow, int endRow, int n)
startRow - the row to start shiftingendRow - the row to end shiftingn - the number of rows to shiftpublic void updateNamedRanges(FormulaShifter shifter)
public void updateFormulas(FormulaShifter shifter)
@Internal public void updateRowFormulas(XSSFRow row, FormulaShifter shifter)
row - the row to update the formulas onshifter - the formula shifting policypublic void updateConditionalFormatting(FormulaShifter shifter)
public void updateHyperlinks(FormulaShifter shifter)
shifter - Copyright 2017 The Apache Software Foundation or its licensors, as applicable.