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 TypeMethodDescriptionvoidupdateConditionalFormatting(FormulaShifter formulaShifter) Update conditional formattingvoidupdateFormulas(FormulaShifter formulaShifter) Update formulas.voidupdateHyperlinks(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).voidupdateNamedRanges(FormulaShifter formulaShifter) Update named rangesvoidupdateRowFormulas(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
shiftMergedRegionsMethods inherited from class org.apache.poi.ss.usermodel.helpers.BaseRowColShifter
shiftRange
-
Constructor Details
-
XSSFRowShifter
-
-
Method Details
-
updateNamedRanges
Description copied from class:BaseRowColShifterUpdate named ranges- Specified by:
updateNamedRangesin classBaseRowColShifter
-
updateFormulas
Description copied from class:BaseRowColShifterUpdate formulas.- Specified by:
updateFormulasin 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:BaseRowColShifterUpdate conditional formatting- Specified by:
updateConditionalFormattingin classBaseRowColShifter
-
updateHyperlinks
Description copied from class:BaseRowColShifterShift 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:
updateHyperlinksin classBaseRowColShifter- Parameters:
formulaShifter- the formula shifting policy
-