Author: fanningpj
Date: Sun Jul 2 12:29:37 2017
New Revision: 1800558
URL: http://svn.apache.org/viewvc?rev=1800558&view=rev
Log:
add test case for date formatting using different locales
Modified:
poi/trunk/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java
Modified:
poi/trunk/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java?rev=1800558&r1=1800557&r2=1800558&view=diff
==============================================================================
--- poi/trunk/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java
(original)
+++ poi/trunk/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java
Sun Jul 2 12:29:37 2017
@@ -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<Locale> locales = Arrays.asList(new Locale[] {Locale.GERMANY,
Locale.US, Locale.ROOT} );
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
