Attachment 31556 Details for Bug 56454 – Test case demonstrating the problem.

Test case demonstrating the problem.

TestSheetRowShift.java (text/plain), 1.40 KB, created by Jörg Selbach on 2014-04-24 16:24:36 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jörg Selbach

Created: 2014-04-24 16:24:36 UTC

Size: 1.40 KB

patch

obsolete

>package org.apache.poi.xssf;
>
>import org.apache.poi.hssf.usermodel.HSSFWorkbook;
>import org.apache.poi.ss.usermodel.Cell;
>import org.apache.poi.ss.usermodel.Row;
>import org.apache.poi.ss.usermodel.Sheet;
>import org.apache.poi.ss.usermodel.Workbook;
>import org.apache.poi.ss.util.CellRangeAddress;
>import org.apache.poi.xssf.usermodel.XSSFWorkbook;
>import org.junit.Assert;
>import org.junit.Test;
>
>public class TestSheetRowShift {
>
>	@Test
>	public void testHSSFRowShift() {
>		checkMergedRegions(new HSSFWorkbook());
>	}
>
>	@Test
>	public void testXSSFRowShift() {
>		checkMergedRegions(new XSSFWorkbook());
>	}
>
>	private void checkMergedRegions(Workbook wb) {
>		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, Cell.CELL_TYPE_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);
>
>			Assert.assertEquals(cr.getFirstRow(), 3);
>		}
>	}
>}

Actions: View

Attachments on bug 56454: 31556 | 33328 | 33329 | 33330