Class BaseRowColShifter
java.lang.Object
org.apache.poi.ss.usermodel.helpers.BaseRowColShifter
- Direct Known Subclasses:
ColumnShifter
,RowShifter
Class for code common to
RowShifter
and ColumnShifter
Helper for shifting rows up or down and columns left and right- Since:
- POI 4.0.0
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionabstract List
<CellRangeAddress> shiftMergedRegions
(int start, int end, int n) Shifts, grows, or shrinks the merged regions due to a row shift (RowShifter
) or column shift (ColumnShifter
).static CellRangeAddress
shiftRange
(FormulaShifter formulaShifter, CellRangeAddress cra, int currentExternSheetIx) abstract void
updateConditionalFormatting
(FormulaShifter formulaShifter) Update conditional formattingabstract void
updateFormulas
(FormulaShifter formulaShifter) Update formulas.abstract void
updateHyperlinks
(FormulaShifter formulaShifter) 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).abstract void
updateNamedRanges
(FormulaShifter formulaShifter) Update named ranges
-
Constructor Details
-
BaseRowColShifter
public BaseRowColShifter()
-
-
Method Details
-
updateNamedRanges
Update named ranges -
updateFormulas
Update formulas. -
shiftMergedRegions
Shifts, grows, or shrinks the merged regions due to a row shift (RowShifter
) or column shift (ColumnShifter
). Merged regions that are completely overlaid by shifting will be deleted.- Parameters:
start
- the first row or column to be shiftedend
- the last row or column to be shiftedn
- the number of rows or columns to shift- Returns:
- a list of affected merged regions, excluding contain deleted ones
-
updateConditionalFormatting
Update conditional formatting- Parameters:
formulaShifter
-
-
updateHyperlinks
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.- Parameters:
formulaShifter
- the formula shifting policy
-
shiftRange
public static CellRangeAddress shiftRange(FormulaShifter formulaShifter, CellRangeAddress cra, int currentExternSheetIx)
-