https://bz.apache.org/bugzilla/show_bug.cgi?id=57423
--- Comment #11 from Javen O'Neal <one...@apache.org> ---
Before: After:
A A
1 a <empty>
2 b <empty>
3 c c
4 a
5 b
sh.createRow(0).createCell(0).setCellValue("a");
sh.createRow(1).createCell(0).setCellValue("b");
sh.createRow(2).createCell(0).setCellValue("c");
sh.shiftRows(0, 1, 3); //move "a" and "b" 3 rows down
Output: xl/sheet1.xlsx
<?xml version="1.0" encoding="UTF-8"?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main";>
<dimension ref="A3:B5"/>
<sheetViews><sheetView workbookViewId="0" tabSelected="true"/></sheetViews>
<sheetFormatPr defaultRowHeight="15.0"/>
<sheetData>
<row r="4"><c r="A4" t="s"><v>0</v></c></row> <!-- "a" -->
<row r="5"><c r="A5" t="s"><v>1</v></c></row> <!-- "b" -->
<row r="3"><c r="A3" t="s"><v>2</v></c></row> <!-- "c" -->
</sheetData>
<pageMargins bottom="0.75" footer="0.3" header="0.3" left="0.7" right="0.7"
top="0.75"/>
</worksheet>
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
