add date test

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1891878 13f79535-47bb-0310-9956-ffa450edef68

1 files changed, 20 insertions, 0 deletions

diff --git a/poi/src/test/java/org/apache/poi/ss/usermodel/BaseTestCell.java b/poi/src/test/java/org/apache/poi/ss/usermodel/BaseTestCell.java
index d8a54cfa54..944f46dd1c 100644
--- a/poi/src/test/java/org/apache/poi/ss/usermodel/BaseTestCell.java
+++ b/poi/src/test/java/org/apache/poi/ss/usermodel/BaseTestCell.java
@@ -1387,6 +1387,26 @@ public abstract class BaseTestCell {
     }
 
     @Test
+    void setCellFormulaWithDateArithmetic() throws IOException {
+        try (Workbook wb = _testDataProvider.createWorkbook()) {
+            Cell cellA1 = getInstance(wb);
+            cellA1.setCellFormula("B1+1");
+
+            LocalDate date = LocalDate.parse("2021-07-31");
+            Cell cellB1 = cellA1.getRow().createCell(1);
+            cellB1.setCellValue(date);
+
+            assertEquals(CellType.FORMULA, cellA1.getCellType());
+            assertEquals(CellType.NUMERIC, cellA1.getCachedFormulaResultType());
+
+            FormulaEvaluator fe = wb.getCreationHelper().createFormulaEvaluator();
+            CellValue valueA1 = fe.evaluate(cellA1);
+            assertEquals(CellType.NUMERIC, valueA1.getCellType());
+            assertEquals(DateUtil.getExcelDate(date.plusDays(1)), valueA1.getNumberValue());
+        }
+    }
+
+    @Test
     void setCellType_FORMULA_onAnArrayFormulaCell_doesNothing() throws IOException {
         try (Workbook wb = _testDataProvider.createWorkbook()) {
             Cell cell = getInstance(wb);