Class ColumnShifter
java.lang.Object
org.apache.poi.ss.usermodel.helpers.BaseRowColShifter
org.apache.poi.ss.usermodel.helpers.ColumnShifter
- Direct Known Subclasses:
HSSFColumnShifter
,XSSFColumnShifter
Helper for shifting columns up or down
- Since:
- POI 4.0.0
-
Field Summary
Fields -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoid
shiftColumns
(int firstShiftColumnIndex, int lastShiftColumnIndex, int step) shiftMergedRegions
(int startColumn, int endColumn, int n) Shifts, grows, or shrinks the merged regions due to a column shift.Methods inherited from class org.apache.poi.ss.usermodel.helpers.BaseRowColShifter
shiftRange, updateConditionalFormatting, updateFormulas, updateHyperlinks, updateNamedRanges
-
Field Details
-
sheet
-
-
Constructor Details
-
ColumnShifter
-
-
Method Details
-
shiftMergedRegions
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 classBaseRowColShifter
- Parameters:
startColumn
- the column to start shiftingendColumn
- the column to end shiftingn
- 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)
-