Author: fanningpj
Date: Mon Aug 1 15:57:58 2022
New Revision: 1903170
URL: http://svn.apache.org/viewvc?rev=1903170&view=rev
Log:
[bug-66181] test case
Modified:
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
Modified:
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
URL:
http://svn.apache.org/viewvc/poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFBugs.java?rev=1903170&r1=1903169&r2=1903170&view=diff
==============================================================================
---
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
(original)
+++
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
Mon Aug 1 15:57:58 2022
@@ -3686,4 +3686,23 @@ public final class TestXSSFBugs extends
}
}
}
+
+ @Test
+ void testBug66181() throws IOException {
+ File file =
XSSFTestDataSamples.getSampleFile("ValueFunctionOfBlank.xlsx");
+ try (
+ FileInputStream fis = new FileInputStream(file);
+ Workbook workbook = WorkbookFactory.create(fis)
+ ) {
+ Sheet sheet = workbook.getSheetAt(0);
+ Row row = sheet.getRow(0);
+ Cell a1 = row.getCell(0);
+ assertEquals(CellType.FORMULA, a1.getCellType());
+ assertEquals(CellType.ERROR, a1.getCachedFormulaResultType());
+ FormulaEvaluator evaluator =
workbook.getCreationHelper().createFormulaEvaluator();
+ CellValue cv1 = evaluator.evaluate(a1);
+ //this next line should probably return CellType.ERROR
+ assertEquals(CellType.NUMERIC, cv1.getCellType());
+ }
+ }
}
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
