From cee18e78b5f883c6d9de6dc363196b2e3301dad0 Mon Sep 17 00:00:00 2001 From: PJ Fanning Date: Wed, 27 Jul 2022 00:02:56 +0000 Subject: [PATCH] add tests git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1903040 13f79535-47bb-0310-9956-ffa450edef68 --- .../poi/xssf/streaming/TestSXSSFWorkbook.java | 40 +++++++++++++++++++ 1 file changed, 40 insertions(+) diff --git a/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFWorkbook.java b/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFWorkbook.java index 16449a9f8c..b3e86899c2 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFWorkbook.java +++ b/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFWorkbook.java @@ -580,6 +580,46 @@ public final class TestSXSSFWorkbook extends BaseTestXWorkbook { } } + @Test + void addDimension1() throws IOException { + try ( + SXSSFWorkbook wb = new SXSSFWorkbook(1); + UnsynchronizedByteArrayOutputStream bos = new UnsynchronizedByteArrayOutputStream() + ) { + SXSSFSheet sheet = wb.createSheet(); + sheet.createRow(2).createCell(3).setCellValue("top left"); + sheet.createRow(6).createCell(5).setCellValue("bottom right"); + assertEquals(2, sheet.getFirstRowNum()); + assertEquals(6, sheet.getLastRowNum()); + wb.write(bos); + try (XSSFWorkbook xssfWorkbook = new XSSFWorkbook(bos.toInputStream())) { + XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(0); + assertEquals(CellRangeAddress.valueOf("D3:F7"), xssfSheet.getDimension()); + } + } + } + + @Test + void addDimensionXSSFtoSXSSF() throws IOException { + try (XSSFWorkbook wb = new XSSFWorkbook()) { + XSSFSheet sheet = wb.createSheet(); + sheet.createRow(2).createCell(3).setCellValue("top left"); + sheet.createRow(6).createCell(5).setCellValue("bottom right"); + assertEquals(2, sheet.getFirstRowNum()); + assertEquals(6, sheet.getLastRowNum()); + try ( + SXSSFWorkbook sxssfWorkbook = new SXSSFWorkbook(wb); + UnsynchronizedByteArrayOutputStream bos = new UnsynchronizedByteArrayOutputStream() + ) { + sxssfWorkbook.write(bos); + try (XSSFWorkbook xssfWorkbook = new XSSFWorkbook(bos.toInputStream())) { + XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(0); + assertEquals(CellRangeAddress.valueOf("D3:F7"), xssfSheet.getDimension()); + } + } + } + } + @Test void addDimensionDisabled() throws IOException { try ( -- 2.39.5