You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ce...@apache.org on 2020/11/01 17:59:33 UTC
svn commit: r1883055 -
/poi/trunk/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheetShiftRows.java
Author: centic
Date: Sun Nov 1 17:59:33 2020
New Revision: 1883055
URL: http://svn.apache.org/viewvc?rev=1883055&view=rev
Log:
Add unit-test from bug 56454 to show that the problem is fixed now
Probably fixed as part of 64460 via r1883037.
Modified:
poi/trunk/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheetShiftRows.java
Modified: poi/trunk/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheetShiftRows.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheetShiftRows.java?rev=1883055&r1=1883054&r2=1883055&view=diff
==============================================================================
--- poi/trunk/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheetShiftRows.java (original)
+++ poi/trunk/src/testcases/org/apache/poi/ss/usermodel/BaseTestSheetShiftRows.java Sun Nov 1 17:59:33 2020
@@ -764,6 +764,38 @@ public abstract class BaseTestSheetShift
}
+ @Test
+ public void checkMergedRegions56454() {
+ Workbook wb = _testDataProvider.createWorkbook();
+ Sheet sheet = wb.createSheet();
+
+ // populate sheet cells
+ for (int i = 0; i < 10; i++) {
+ Row row = sheet.createRow(i);
+
+ for (int j = 0; j < 10; j++) {
+ Cell cell = row.createCell(j, CellType.STRING);
+
+ cell.setCellValue(i + "x" + j);
+ }
+ }
+
+ CellRangeAddress region1 = new CellRangeAddress(3, 6, 0, 1);
+ CellRangeAddress region2 = new CellRangeAddress(3, 6, 2, 3);
+
+ sheet.addMergedRegion(region1);
+ sheet.addMergedRegion(region2);
+
+ sheet.shiftRows(4, sheet.getLastRowNum(), 1);
+
+ // check, if all regions still start at row 3
+ for (int i = 0; i < sheet.getNumMergedRegions(); i++) {
+ CellRangeAddress cr = sheet.getMergedRegion(i);
+
+ assertEquals(cr.getFirstRow(), 3);
+ }
+ }
+
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org