java.lang.AssertionError: =WORKDAY(DATE(2013,4,1),5) failed, at row 33 in xsheet: formula-datetime Expected: "41372" but: was "41366"

ZK-Tracker | hawk | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    evaluation result of HOUR, MINUTE, SECOND are {{#VALUE!}}. {code} 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) {code} evaluation result of WORKDAY is not as expected. {code} 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) {code} not found formula: TIMEVALUE" {code} 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) {code} h3. reproducing steps run automatic test case {{FormulaTest}} of the [project zss.test of zkspreadsheet |https://github.com/zkoss/zkspreadsheet/tree/3.0] or attached file

    ZK-Tracker | 4 years ago | hawk
    java.lang.AssertionError: =WORKDAY(DATE(2013,4,1),5) failed, at row 33 in xsheet: formula-datetime Expected: "41372" but: was "41366"
  2. 0

    evaluation result of HOUR, MINUTE, SECOND are {{#VALUE!}}. {code} 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) {code} evaluation result of WORKDAY is not as expected. {code} 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) {code} not found formula: TIMEVALUE" {code} 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) {code} h3. reproducing steps run automatic test case {{FormulaTest}} of the [project zss.test of zkspreadsheet |https://github.com/zkoss/zkspreadsheet/tree/3.0] or attached file

    ZK-Tracker | 4 years ago | hawk
    java.lang.AssertionError: =WORKDAY(DATE(2013,4,1),5) failed, at row 33 in xsheet: formula-datetime Expected: "41372" but: was "41366"
  3. 0

    [ZSS-266] Info formula "ISERR" is evaluated to a wrong result - ZK-Tracker

    zkoss.org | 2 years ago
    java.lang.AssertionError: =ISERR(B13) failed, at row 12 in xsheet: formula-info Expected: but: was
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [ZSS-269] error evaluating some financial formulas - ZK-Tracker

    zkoss.org | 2 years ago
    java.lang.AssertionError: =PV(0.08/12,20*12,500, ,0) failed, at row 99 in xsheet: formula-financial Expected: but: was
  6. 0

    h3. problem description by automatic test the Math formula SERIESSUM cannot be evaluated to a correct result. {code} java.lang.AssertionError: =SERIESSUM(B105,0,2,B106:B109) failed, at row 104 in xsheet: formula-math Expected: "0.7071" but: was "Error evaluating cell 'formula-math'!B104" 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.testMath(FormulaTest.java:51) ... {code} Exception: {code} 嚴重的: >>org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'first-error'!F20 >>org.zkoss.poi.ss.formula.eval.NotImplementedException: SERIESSUM >> at org.zkoss.poi.ss.formula.atp.AnalysisToolPak$NotImplemented.evaluate(AnalysisToolPak.java:40) >> at org.zkoss.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:65) >> at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316) >> at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119) >> at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:476) >> at org.zkoss.zss.model.sys.impl.BookHelper.reevaluate(BookHelper.java:303) >> at org.zkoss.zss.model.sys.impl.BookHelper.reevaluateAndNotify(BookHelper.java:462) >> at org.zkoss.zss.model.sys.impl.XRangeImpl.reevaluateAndNotify(XRangeImpl.java:421) >> at org.zkoss.zss.model.sys.impl.XRangeImpl.setEditText(XRangeImpl.java:385) >> at org.zkoss.zss.api.impl.RangeImpl.setCellEditText(RangeImpl.java:604) >> at org.zkoss.zss.ui.Spreadsheet.processStopEditing0(Spreadsheet.java:4381) >> at org.zkoss.zss.ui.Spreadsheet.processStopEditing(Spreadsheet.java:4344) >> at org.zkoss.zss.ui.Spreadsheet.access$42(Spreadsheet.java:4342) >> at org.zkoss.zss.ui.Spreadsheet$2.onEvent(Spreadsheet.java:318) {code} h3. reproducing steps run automatic test case {{FormulaTest}} of the [project zss.test of zkspreadsheet |https://github.com/zkoss/zkspreadsheet/tree/3.0]

    ZK-Tracker | 4 years ago | hawk
    java.lang.AssertionError: =SERIESSUM(B105,0,2,B106:B109) failed, at row 104 in xsheet: formula-math Expected: "0.7071" but: was "Error evaluating cell 'formula-math'!B104"

  1. olle.hallin 2 times, last 5 days ago
  2. marcbouvierdav 1 times, last 2 weeks ago
  3. rsprangemeijer 1 times, last 3 weeks ago
  4. Dunmer 4 times, last 3 weeks ago
  5. aldrinleal 2 times, last 2 months ago
8 more registered users
3 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. Hamcrest
    MatcherAssert.assertThat
    1. org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
    1 frame
  3. JUnit
    ErrorCollector.checkThat
    1. org.junit.Assert.assertThat(Assert.java:865)
    2. org.junit.rules.ErrorCollector$1.call(ErrorCollector.java:65)
    3. org.junit.rules.ErrorCollector.checkSucceeds(ErrorCollector.java:78)
    4. org.junit.rules.ErrorCollector.checkThat(ErrorCollector.java:63)
    4 frames
  4. zss.test
    FormulaTest.testDateTime
    1. zss.test.FormulaTest.testFormulaByRangesInSheet(FormulaTest.java:158)
    2. zss.test.FormulaTest.testDateTime(FormulaTest.java:87)
    2 frames