apache
diff --git a/‎poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java‎
Lines changed: 16 additions & 0 deletions b/‎poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java‎
Lines changed: 16 additions & 0 deletions
diff --git a/‎test-data/spreadsheet/github-321.xlsx‎
7.93 KB b/‎test-data/spreadsheet/github-321.xlsx‎
7.93 KB
@@ -43,6 +43,7 @@ Licensed to the Apache Software Foundation (ASF) under one or more
 import org.apache.poi.ss.usermodel.DataFormatter;
 import org.apache.poi.ss.usermodel.Font;
 import org.apache.poi.ss.usermodel.FormulaError;
+import org.apache.poi.ss.usermodel.FormulaEvaluator;
 import org.apache.poi.ss.usermodel.RichTextString;
 import org.apache.poi.ss.usermodel.Row;
 import org.apache.poi.ss.usermodel.Row.MissingCellPolicy;
@@ -1398,6 +1399,21 @@ void checkNewFileForR1C1Refs() throws IOException {
         }
     }
 
+    @Test
+    void testGithub321() throws Exception {
+        try (XSSFWorkbook wb = openSampleWorkbook("github-321.xlsx")) {
+            XSSFSheet xssfSheet = wb.getSheetAt(0);
+            DataFormatter dataFormatter = new DataFormatter();
+            FormulaEvaluator formulaEvaluator = wb.getCreationHelper().createFormulaEvaluator();
+            XSSFCell a3 = xssfSheet.getRow(2).getCell(0);
+            assertEquals("2.05", dataFormatter.formatCellValue(a3));
+            assertEquals("2.05", dataFormatter.formatCellValue(a3, formulaEvaluator));
+            XSSFCell a4 = xssfSheet.getRow(3).getCell(0);
+            assertEquals("2.1", dataFormatter.formatCellValue(a4));
+            assertEquals("2.1", dataFormatter.formatCellValue(a4, formulaEvaluator));
+        }
+    }
+
     private static void expectFormattedContent(Cell cell, String value) {
         assertEquals(value, new DataFormatter().formatCellValue(cell),
                 "Cell " + ref(cell) + " has wrong formatted content.");