add data-formatter test

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

2 files changed, 13 insertions, 0 deletions

diff --git a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFDataFormat.java b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFDataFormat.java
index 5147e1f843..fe4aa0a00a 100644
--- a/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFDataFormat.java
+++ b/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFDataFormat.java
@@ -107,4 +107,17 @@ public final class TestXSSFDataFormat extends BaseTestDataFormat {
             assertEquals("1000", formatter.formatCellValue(cell, evaluator));
         }
     }
+
+    @Test
+    void testSetUseCachedValuesForFormulaCells() throws Exception {
+        try (XSSFWorkbook wb = openSampleWorkbook("formula-eval.xlsx")) {
+            final DataFormatter formatter = new DataFormatter();
+            XSSFSheet sheet = wb.getSheetAt(0);
+            XSSFRow row = sheet.getRow(0);
+            XSSFCell d1 = row.getCell(3);
+            assertEquals("SUM(A1:C1)", formatter.formatCellValue(d1));
+            formatter.setUseCachedValuesForFormulaCells(true);
+            assertEquals("6.75", formatter.formatCellValue(d1));
+        }
+    }
 }
diff --git a/test-data/spreadsheet/formula-eval.xlsx b/test-data/spreadsheet/formula-eval.xlsx
new file mode 100644
index 0000000000..198c6b5e07
--- /dev/null
+++ b/test-data/spreadsheet/formula-eval.xlsx