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
  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 | 1 year 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 | 1 year 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 1 times, last 1 week ago
  2. davidvanlaatum 7 times, last 4 weeks ago
  3. cesarnog 1 times, last 2 months ago
  4. tfr 1 times, last 4 months ago
  5. qoomon 1 times, last 4 months ago
1 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