Support long month names, dot after day, single digit day of month

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

1 files changed, 12 insertions, 0 deletions

diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestValue.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestValue.java
index 33d1e7bfa4..57d35e9604 100644
--- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestValue.java
+++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestValue.java
@@ -29,9 +29,13 @@ import org.apache.poi.ss.formula.eval.NumberEval;
 import org.apache.poi.ss.formula.eval.StringEval;
 import org.apache.poi.ss.formula.eval.ValueEval;
 import org.apache.poi.ss.util.Utils;
+import org.apache.poi.util.LocaleUtil;
 import org.junit.jupiter.api.Test;
 
 import java.io.IOException;
+import java.time.LocalDate;
+import java.time.format.DateTimeFormatter;
+import java.util.Locale;
 
 /**
  * Tests for {@link Value}
@@ -86,6 +90,14 @@ final class TestValue {
     }
 
     @Test
+    void testDates() {
+        confirmValue("1 January 2025", 45658);
+        confirmValue("01 January 2025", 45658);
+        confirmValue("1 Jan 2025", 45658);
+        confirmValue("01 Jan 2025", 45658);
+    }
+
+    @Test
     void testErrors() {
         confirmValueError("1+1");
         confirmValueError("1 1");