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
Helper for shifting rows up or down
-
Field Summary
Fields inherited from class org.apache.poi.ss.usermodel.helpers.RowShifter
sheet
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoid
updateConditionalFormatting
(FormulaShifter formulaShifter) Update conditional formattingvoid
updateFormulas
(FormulaShifter formulaShifter) Update formulas.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).void
updateNamedRanges
(FormulaShifter formulaShifter) Update named rangesvoid
updateRowFormulas
(XSSFRow row, FormulaShifter formulaShifter) Update the formulas in specified row using the formula shifting policy specified by shifterMethods inherited from class org.apache.poi.ss.usermodel.helpers.RowShifter
shiftMergedRegions
Methods inherited from class org.apache.poi.ss.usermodel.helpers.BaseRowColShifter
shiftRange
-
Constructor Details
-
XSSFRowShifter
-
-
Method Details
-
updateNamedRanges
Description copied from class:BaseRowColShifter
Update named ranges- Specified by:
updateNamedRanges
in classBaseRowColShifter
-
updateFormulas
Description copied from class:BaseRowColShifter
Update formulas.- Specified by:
updateFormulas
in classBaseRowColShifter
-
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 onformulaShifter
- the formula shifting policy
-
updateConditionalFormatting
Description copied from class:BaseRowColShifter
Update conditional formatting- Specified by:
updateConditionalFormatting
in classBaseRowColShifter
- Parameters:
formulaShifter
-
-
updateHyperlinks
Description copied from class:BaseRowColShifter
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.- Specified by:
updateHyperlinks
in classBaseRowColShifter
- Parameters:
formulaShifter
- the formula shifting policy
-