From 32a337f1d1322f6414e697e01a1fd95af373497f Mon Sep 17 00:00:00 2001 From: PJ Fanning Date: Sun, 2 Jul 2017 12:29:37 +0000 Subject: [PATCH] add test case for date formatting using different locales git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1800558 13f79535-47bb-0310-9956-ffa450edef68 --- .../poi/ss/usermodel/TestDataFormatter.java | 15 ++++++++++++++- 1 file changed, 14 insertions(+), 1 deletion(-) diff --git a/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java b/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java index f65bd6c5d7..5c2bb63953 100644 --- a/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java +++ b/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java @@ -854,9 +854,22 @@ public class TestDataFormatter { assertEquals("51:01", dfUS.formatRawCellContents(42605.368761574071, -1, "mm:ss")); } + @Test + public void testDateFormattingWithLocales() { + // 2017-12-01 09:54:33 which is 42747.412892397523 as double + DataFormatter dfDE = new DataFormatter(Locale.GERMANY); + DataFormatter dfZH = new DataFormatter(Locale.PRC); + DataFormatter dfIE = new DataFormatter(new Locale("GA", "IE")); + double date = 42747.412892397523; + String format = "dd MMMM yyyy HH:mm:ss"; + assertEquals("12 Januar 2017 09:54:33", dfDE.formatRawCellContents(date, -1, format)); + assertEquals("12 \u4E00\u6708 2017 09:54:33", dfZH.formatRawCellContents(date, -1, format)); + assertEquals("12 Ean\u00E1ir 2017 09:54:33", dfIE.formatRawCellContents(date, -1, format)); + } + /** * bug 60422 : simple number formats seem ok -≈ */ + */ @Test public void testSimpleNumericFormatsInGermanyLocale() { List locales = Arrays.asList(new Locale[] {Locale.GERMANY, Locale.US, Locale.ROOT} ); -- 2.39.5