ASF Bugzilla – Attachment 29928 Details for
Bug 54533
Shifting rows does not shift the Zero Height flag
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
Remember
[x]
|
Forgot Password
Login:
[x]
JUnit test to demonstrate shifting of zero-height rows
ShiftingZeroHeightRowsTest.java (text/x-java), 1.22 KB, created by
Didier Loiseau
on 2013-02-06 15:36:18 UTC
(
hide
)
Description:
JUnit test to demonstrate shifting of zero-height rows
Filename:
MIME Type:
Creator:
Didier Loiseau
Created:
2013-02-06 15:36:18 UTC
Size:
1.22 KB
patch
obsolete
>import static org.junit.Assert.assertEquals; >import static org.junit.Assert.assertFalse; >import static org.junit.Assert.assertTrue; > >import org.apache.poi.hssf.usermodel.HSSFWorkbook; >import org.apache.poi.ss.usermodel.Row; >import org.apache.poi.ss.usermodel.Sheet; >import org.apache.poi.ss.usermodel.Workbook; >import org.junit.Test; > >/** > * Tests that shifting rows with zero height works as expected. > * > * @author Didier Loiseau > */ >public class ShiftingZeroHeightRowsTest { > > @Test > public final void test() { > Workbook workbook = new HSSFWorkbook(); > Sheet sheet = workbook.createSheet(); > sheet.createRow(0); > Row row1 = sheet.createRow(1); > row1.setZeroHeight(true); > row1.getCell(0, Row.CREATE_NULL_AS_BLANK).setCellValue("test"); > sheet.createRow(2); > sheet.shiftRows(0, sheet.getLastRowNum(), 1); > assertEquals("Row values should have been shifted", "test", sheet.getRow(2).getCell(0).getStringCellValue()); > assertFalse("Row 1 (old row 0) should not be zero height", sheet.getRow(1).getZeroHeight()); > assertTrue("Row 2 (old row 1) should be zero height", sheet.getRow(2).getZeroHeight()); > assertFalse("Row 3 (old row 2) should not be zero height", sheet.getRow(3).getZeroHeight()); > } > >}
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 54533
: 29928