diff options
| -rw-r--r-- | poi-ooxml-full/src/main/java9/module-info.class | bin | 1757 -> 1758 bytes | |||
| -rw-r--r-- | poi-ooxml-lite-agent/src/main/java9/module-info.class | bin | 278 -> 279 bytes | |||
| -rw-r--r-- | poi-ooxml/src/main/java9/module-info.class | bin | 3732 -> 3733 bytes | |||
| -rw-r--r-- | poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFBugs.java | 39 | ||||
| -rw-r--r-- | poi-ooxml/src/test/java9/module-info.class | bin | 5119 -> 5120 bytes | |||
| -rw-r--r-- | poi-scratchpad/src/main/java9/module-info.class | bin | 2641 -> 2642 bytes | |||
| -rw-r--r-- | poi-scratchpad/src/test/java9/module-info.class | bin | 3288 -> 3289 bytes | |||
| -rw-r--r-- | poi/src/test/java9/module-info.class | bin | 4145 -> 4145 bytes |
8 files changed, 39 insertions, 0 deletions
diff --git a/poi-ooxml-full/src/main/java9/module-info.class b/poi-ooxml-full/src/main/java9/module-info.class Binary files differindex 34e3970b88..e922419617 100644 --- a/poi-ooxml-full/src/main/java9/module-info.class +++ b/poi-ooxml-full/src/main/java9/module-info.class diff --git a/poi-ooxml-lite-agent/src/main/java9/module-info.class b/poi-ooxml-lite-agent/src/main/java9/module-info.class Binary files differindex 7839f4047c..8b45606400 100644 --- a/poi-ooxml-lite-agent/src/main/java9/module-info.class +++ b/poi-ooxml-lite-agent/src/main/java9/module-info.class diff --git a/poi-ooxml/src/main/java9/module-info.class b/poi-ooxml/src/main/java9/module-info.class Binary files differindex fd29b43f37..f4db29c614 100644 --- a/poi-ooxml/src/main/java9/module-info.class +++ b/poi-ooxml/src/main/java9/module-info.class diff --git a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFBugs.java b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFBugs.java index 432444f044..a9dbe077ec 100644 --- a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFBugs.java +++ b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFBugs.java @@ -274,4 +274,43 @@ public final class TestSXSSFBugs extends BaseTestBugzillaIssues { } } } + + @Test + public void test62215() throws IOException { + String sheetName = "1"; + int rowIndex = 0; + int colIndex = 0; + String formula = "1"; + String value = "yes"; + CellType valueType = CellType.STRING; + + try (Workbook wb = new SXSSFWorkbook()) { + Sheet sheet = wb.createSheet(sheetName); + Row row = sheet.createRow(rowIndex); + Cell cell = row.createCell(colIndex); + + // this order ensures that value will not be overwritten by setting the formula + cell.setCellFormula(formula); + cell.setCellValue(value); + + assertEquals(CellType.FORMULA, cell.getCellType()); + assertEquals(formula, cell.getCellFormula()); + assertEquals(valueType, cell.getCachedFormulaResultType()); + assertEquals(value, cell.getStringCellValue()); + // so far so good + + try (UnsynchronizedByteArrayOutputStream bos = new UnsynchronizedByteArrayOutputStream()){ + wb.write(bos); + + try (XSSFWorkbook testWb = new XSSFWorkbook(bos.toInputStream())) { + Cell testCell = testWb.getSheet(sheetName).getRow(rowIndex).getCell(colIndex); + assertEquals(CellType.FORMULA, testCell.getCellType()); + assertEquals(formula, testCell.getCellFormula()); + + assertEquals(CellType.STRING, testCell.getCachedFormulaResultType()); + assertEquals(value, testCell.getStringCellValue()); + } + } + } + } } diff --git a/poi-ooxml/src/test/java9/module-info.class b/poi-ooxml/src/test/java9/module-info.class Binary files differindex 012028ad0b..2cd55eb942 100644 --- a/poi-ooxml/src/test/java9/module-info.class +++ b/poi-ooxml/src/test/java9/module-info.class diff --git a/poi-scratchpad/src/main/java9/module-info.class b/poi-scratchpad/src/main/java9/module-info.class Binary files differindex 53efc695f7..72189ac318 100644 --- a/poi-scratchpad/src/main/java9/module-info.class +++ b/poi-scratchpad/src/main/java9/module-info.class diff --git a/poi-scratchpad/src/test/java9/module-info.class b/poi-scratchpad/src/test/java9/module-info.class Binary files differindex e4d2abd3d2..f5349bb241 100644 --- a/poi-scratchpad/src/test/java9/module-info.class +++ b/poi-scratchpad/src/test/java9/module-info.class diff --git a/poi/src/test/java9/module-info.class b/poi/src/test/java9/module-info.class Binary files differindex b145aa3bb7..028b943d0a 100644 --- a/poi/src/test/java9/module-info.class +++ b/poi/src/test/java9/module-info.class |