You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by fa...@apache.org on 2021/08/06 15:41:16 UTC
svn commit: r1892043 -
/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/eval/TestOperandResolver.java
Author: fanningpj
Date: Fri Aug 6 15:41:16 2021
New Revision: 1892043
URL: http://svn.apache.org/viewvc?rev=1892043&view=rev
Log:
extend tests
Modified:
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/eval/TestOperandResolver.java
Modified: poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/eval/TestOperandResolver.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/eval/TestOperandResolver.java?rev=1892043&r1=1892042&r2=1892043&view=diff
==============================================================================
--- poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/eval/TestOperandResolver.java (original)
+++ poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/eval/TestOperandResolver.java Fri Aug 6 15:41:16 2021
@@ -94,6 +94,27 @@ final class TestOperandResolver {
}
@Test
+ void testCoerceDateTimeStringToNumber() throws EvaluationException {
+ Map<String, Double> values = new LinkedHashMap<>();
+ values.put("2019/1/18 12:00", 43483.5);
+ values.put("2019/1/18 6:00 AM", 43483.25);
+ values.put("18-Jan-2019 6:00 PM", 43483.75);
+ values.put("2019/1/18 15:15:15", 43483.63559027778);
+ values.put("18-Jan-2019 6:15:15 PM", 43483.76059027778);
+
+ for (String str : values.keySet()) {
+ try {
+ assertEquals(OperandResolver.coerceValueToDouble(new StringEval(str)), values.get(str), 0.00001);
+ } catch (EvaluationException e) {
+ fail("While handling: " + str + ". "
+ + "This failure can indicate that the wrong locale is used during test-execution, "
+ + "ensure you run with english/US via -Duser.language=en -Duser.country=US. "
+ + "Having: " + System.getProperty("user.language") + "/" + System.getProperty("user.country"), e);
+ }
+ }
+ }
+
+ @Test
void testCoerceTimeStringToNumber() throws EvaluationException {
Map<String, Double> values = new LinkedHashMap<>();
values.put("00:00", 0.0);
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org