|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectorg.apache.poi.ss.usermodel.helpers.RowShifter
org.apache.poi.xssf.usermodel.helpers.XSSFRowShifter
public final class XSSFRowShifter
Helper for shifting rows up or down
When possible, code should be implemented in the RowShifter abstract class to avoid duplication with HSSFRowShifter
| Field Summary |
|---|
| Fields inherited from class org.apache.poi.ss.usermodel.helpers.RowShifter |
|---|
sheet |
| Constructor Summary | |
|---|---|
XSSFRowShifter(XSSFSheet sh)
|
|
| Method Summary | |
|---|---|
java.util.List<CellRangeAddress> |
shiftMerged(int startRow,
int endRow,
int n)
Deprecated. POI 3.15 beta 2. Use RowShifter.shiftMergedRegions(int, int, int) instead. |
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 |
|---|
public XSSFRowShifter(XSSFSheet sh)
| Method Detail |
|---|
public java.util.List<CellRangeAddress> shiftMerged(int startRow,
int endRow,
int n)
RowShifter.shiftMergedRegions(int, int, int) instead.
startRow - the row to start shiftingendRow - the row to end shiftingn - the number of rows to shift
public void updateNamedRanges(FormulaShifter shifter)
updateNamedRanges in class RowShifterpublic void updateFormulas(FormulaShifter shifter)
updateFormulas in class RowShifter
@Internal
public void updateRowFormulas(Row row,
FormulaShifter shifter)
updateRowFormulas in class RowShifterrow - the row to update the formulas onshifter - the formula shifting policypublic void updateConditionalFormatting(FormulaShifter shifter)
updateConditionalFormatting in class RowShifterpublic void updateHyperlinks(FormulaShifter shifter)
updateHyperlinks in class RowShiftershifter -
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||