|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.poi.xssf.usermodel.helpers.XSSFRowShifter
public final class XSSFRowShifter
Helper for shifting rows up or down
Constructor Summary | |
---|---|
XSSFRowShifter(XSSFSheet sh)
|
Method Summary | |
---|---|
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 |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public XSSFRowShifter(XSSFSheet sh)
Method Detail |
---|
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 shift
public 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
-
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |