Class RowShifter
java.lang.Object
org.apache.poi.ss.usermodel.helpers.BaseRowColShifter
org.apache.poi.ss.usermodel.helpers.RowShifter
- Direct Known Subclasses:
HSSFRowShifter
,XSSFRowShifter
Helper for shifting rows up or down
-
Field Summary
Fields -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionshiftMergedRegions
(int startRow, int endRow, int n) Shifts, grows, or shrinks the merged regions due to a row shift.Methods inherited from class org.apache.poi.ss.usermodel.helpers.BaseRowColShifter
shiftRange, updateConditionalFormatting, updateFormulas, updateHyperlinks, updateNamedRanges
-
Field Details
-
sheet
-
-
Constructor Details
-
RowShifter
-
-
Method Details
-
shiftMergedRegions
Shifts, grows, or shrinks the merged regions due to a row shift. Merged regions that are completely overlaid by shifting will be deleted.- Specified by:
shiftMergedRegions
in classBaseRowColShifter
- Parameters:
startRow
- the row to start shiftingendRow
- the row to end shiftingn
- the number of rows to shift- Returns:
- an array of affected merged regions, doesn't contain deleted ones
-