java.lang.AssertionError: =SECOND("4:48 PM") failed, at row 23 in xsheet: formula-datetime
Expected: "0"
     but: was "#VALUE!"
	at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
	at org.junit.Assert.assertThat(Assert.java:865)
	at org.junit.rules.ErrorCollector$1.call(ErrorCollector.java:65)
	at org.junit.rules.ErrorCollector.checkSucceeds(ErrorCollector.java:78)
	at org.junit.rules.ErrorCollector.checkThat(ErrorCollector.java:63)
	at zss.test.FormulaTest.testFormulaByRangesInSheet(FormulaTest.java:158)
	at zss.test.FormulaTest.testDateTime(FormulaTest.java:87)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	

java.lang.AssertionError: =WORKDAY(DATE(2013,4,1),5) failed, at row 33 in xsheet: formula-datetime
Expected: "41372"
     but: was "41366"
	at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
	at org.junit.Assert.assertThat(Assert.java:865)
	at org.junit.rules.ErrorCollector$1.call(ErrorCollector.java:65)
	at org.junit.rules.ErrorCollector.checkSucceeds(ErrorCollector.java:78)
	at org.junit.rules.ErrorCollector.checkThat(ErrorCollector.java:63)
	at zss.test.FormulaTest.testFormulaByRangesInSheet(FormulaTest.java:158)
	at zss.test.FormulaTest.testDateTime(FormulaTest.java:87)
	

java.lang.AssertionError: =TIMEVALUE("2:24 AM") failed, at row 27 in xsheet: formula-datetime
Expected: "0.1"
     but: was "#NAME?"
	at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
	at org.junit.Assert.assertThat(Assert.java:865)
	at org.junit.rules.ErrorCollector$1.call(ErrorCollector.java:65)
	at org.junit.rules.ErrorCollector.checkSucceeds(ErrorCollector.java:78)
	at org.junit.rules.ErrorCollector.checkThat(ErrorCollector.java:63)
	at zss.test.FormulaTest.testFormulaByRangesInSheet(FormulaTest.java:158)
	at zss.test.FormulaTest.testDateTime(FormulaTest.java:87)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)