Class ColumnShifter

    • Field Detail

      • sheet

        protected final Sheet sheet
    • Constructor Detail

      • ColumnShifter

        public ColumnShifter​(Sheet sh)
    • Method Detail

      • shiftMergedRegions

        public List<CellRangeAddress> shiftMergedRegions​(int startColumn,
                                                         int endColumn,
                                                         int n)
        Shifts, grows, or shrinks the merged regions due to a column shift. Merged regions that are completely overlaid by shifting will be deleted.
        Specified by:
        shiftMergedRegions in class BaseRowColShifter
        Parameters:
        startColumn - the column to start shifting
        endColumn - the column to end shifting
        n - the number of columns to shift
        Returns:
        an array of affected merged regions, doesn't contain deleted ones
        Since:
        POI 4.0.0
      • shiftColumns

        public void shiftColumns​(int firstShiftColumnIndex,
                                 int lastShiftColumnIndex,
                                 int step)