Class BaseRowColShifter

java.lang.Object
org.apache.poi.ss.usermodel.helpers.BaseRowColShifter
Direct Known Subclasses:
ColumnShifter, RowShifter

@Internal public abstract class BaseRowColShifter extends Object
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 Details

    • BaseRowColShifter

      public BaseRowColShifter()
  • Method Details

    • updateNamedRanges

      public abstract void updateNamedRanges(FormulaShifter formulaShifter)
      Update named ranges
    • updateFormulas

      public abstract void updateFormulas(FormulaShifter formulaShifter)
      Update formulas.
    • shiftMergedRegions

      public abstract 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). Merged regions that are completely overlaid by shifting will be deleted.
      Parameters:
      start - the first row or column to be shifted
      end - the last row or column to be shifted
      n - the number of rows or columns to shift
      Returns:
      a list of affected merged regions, excluding contain deleted ones
    • updateConditionalFormatting

      public abstract void updateConditionalFormatting(FormulaShifter formulaShifter)
      Update conditional formatting
      Parameters:
      formulaShifter -
    • updateHyperlinks

      public 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). 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)