org.zkoss.poi.ss.formula.eval.NotImplementedException: DATEVALUE, not in zk context

ZK-Tracker | hawk | 4 years ago
  1. 0

    h3. Problem Description: {quote} 嚴重的: >>org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'formula-datetime'!B6 >>org.zkoss.poi.ss.formula.eval.NotImplementedException: DATEVALUE, not in zk context >> at org.zkoss.zssex.formula.ELEvalFunction.evaluate(ELEvalFunction.java:109) >> at org.zkoss.poi.ss.formula.functions.NotImplementedFunction.evaluate(NotImplementedFunction.java:62) >> at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) >> 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:492) >> at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1034) >> at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355) >> at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3041) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2915) >> at org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:839) >> at org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:778) >> at org.zkoss.zss.ui.Spreadsheet.access$41(Spreadsheet.java:756) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3495) >> at org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:87) >> at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4760) {quote} h3. Reproducing Steps: # run the Spreadsheet # type the formula: {{=DATEVALUE("2008/1/1")}} *Expected:* evaluated value. *Actual:* An exception thrown like above.

    ZK-Tracker | 4 years ago | hawk
    org.zkoss.poi.ss.formula.eval.NotImplementedException: DATEVALUE, not in zk context
  2. 0

    h3. Problem Description: {quote} 嚴重的: >>org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'formula-datetime'!B6 >>org.zkoss.poi.ss.formula.eval.NotImplementedException: DATEVALUE, not in zk context >> at org.zkoss.zssex.formula.ELEvalFunction.evaluate(ELEvalFunction.java:109) >> at org.zkoss.poi.ss.formula.functions.NotImplementedFunction.evaluate(NotImplementedFunction.java:62) >> at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) >> 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:492) >> at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1034) >> at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355) >> at org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3041) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2915) >> at org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:839) >> at org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:778) >> at org.zkoss.zss.ui.Spreadsheet.access$41(Spreadsheet.java:756) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3495) >> at org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:87) >> at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4760) {quote} h3. Reproducing Steps: # run the Spreadsheet # type the formula: {{=DATEVALUE("2008/1/1")}} *Expected:* evaluated value. *Actual:* An exception thrown like above.

    ZK-Tracker | 4 years ago | hawk
    org.zkoss.poi.ss.formula.eval.NotImplementedException: DATEVALUE, not in zk context
  3. 0

    h3. Problem description: when we enter a formula with miss required arguments, it throws NotImplementedException. {quote} >>org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell temp!J10 >>org.zkoss.poi.ss.formula.eval.NotImplementedException: ACCRINT, not in zk context >> at org.zkoss.zssex.formula.ELEvalFunction.evaluate(ELEvalFunction.java:109) >> at org.zkoss.zssex.formula.ELEvalFunction.evaluate(ELEvalFunction.java:159) >> 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:492) >> at org.zkoss.zss.model.sys.impl.BookHelper.reevaluate(BookHelper.java:319) >> at org.zkoss.zss.model.sys.impl.BookHelper.reevaluateAndNotify(BookHelper.java:478) >> at org.zkoss.zss.model.sys.impl.XRangeImpl.reevaluateAndNotify(XRangeImpl.java:422) >> at org.zkoss.zss.model.sys.impl.XRangeImpl.setEditText(XRangeImpl.java:386) >> at org.zkoss.zss.api.impl.RangeImpl.setCellEditText(RangeImpl.java:606) >> at org.zkoss.zss.ui.Spreadsheet.processStopEditing0(Spreadsheet.java:4370) >> at org.zkoss.zss.ui.Spreadsheet.processStopEditing(Spreadsheet.java:4333) >> at org.zkoss.zss.ui.Spreadsheet.access$43(Spreadsheet.java:4331) >> at org.zkoss.zss.ui.Spreadsheet$2.onEvent(Spreadsheet.java:324) {quote} h3. reproducing Steps: # open the spreadsheet # enter "=ACCRINT()" *Expected:* #VALUE! *Actual:* the exception shown above.

    ZK-Tracker | 4 years ago | hawk
    org.zkoss.poi.ss.formula.eval.NotImplementedException: ACCRINT, not in zk context
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    h3. Problem description: when we enter a formula with miss required arguments, it throws NotImplementedException. {quote} >>org.zkoss.poi.ss.formula.eval.NotImplementedException: Error evaluating cell temp!J10 >>org.zkoss.poi.ss.formula.eval.NotImplementedException: ACCRINT, not in zk context >> at org.zkoss.zssex.formula.ELEvalFunction.evaluate(ELEvalFunction.java:109) >> at org.zkoss.zssex.formula.ELEvalFunction.evaluate(ELEvalFunction.java:159) >> 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:492) >> at org.zkoss.zss.model.sys.impl.BookHelper.reevaluate(BookHelper.java:319) >> at org.zkoss.zss.model.sys.impl.BookHelper.reevaluateAndNotify(BookHelper.java:478) >> at org.zkoss.zss.model.sys.impl.XRangeImpl.reevaluateAndNotify(XRangeImpl.java:422) >> at org.zkoss.zss.model.sys.impl.XRangeImpl.setEditText(XRangeImpl.java:386) >> at org.zkoss.zss.api.impl.RangeImpl.setCellEditText(RangeImpl.java:606) >> at org.zkoss.zss.ui.Spreadsheet.processStopEditing0(Spreadsheet.java:4370) >> at org.zkoss.zss.ui.Spreadsheet.processStopEditing(Spreadsheet.java:4333) >> at org.zkoss.zss.ui.Spreadsheet.access$43(Spreadsheet.java:4331) >> at org.zkoss.zss.ui.Spreadsheet$2.onEvent(Spreadsheet.java:324) {quote} h3. reproducing Steps: # open the spreadsheet # enter "=ACCRINT()" *Expected:* #VALUE! *Actual:* the exception shown above.

    ZK-Tracker | 4 years ago | hawk
    org.zkoss.poi.ss.formula.eval.NotImplementedException: ACCRINT, not in zk context
  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
    org.zkoss.poi.ss.formula.eval.NotImplementedException: SERIESSUM

    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. org.zkoss.poi.ss.formula.eval.NotImplementedException

      DATEVALUE, not in zk context

      at org.zkoss.zssex.formula.ELEvalFunction.evaluate()
    2. org.zkoss.zssex
      ELEvalFunction.evaluate
      1. org.zkoss.zssex.formula.ELEvalFunction.evaluate(ELEvalFunction.java:109)
      1 frame
    3. org.zkoss.poi
      XSSFFormulaEvaluator.evaluate
      1. org.zkoss.poi.ss.formula.functions.NotImplementedFunction.evaluate(NotImplementedFunction.java:62)
      2. org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132)
      3. org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:539)
      4. org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:316)
      5. org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255)
      6. org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:266)
      7. org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:119)
      7 frames
    4. org.zkoss.zss
      Spreadsheet.service
      1. org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:492)
      2. org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1034)
      3. org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355)
      4. org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89)
      5. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3041)
      6. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2915)
      7. org.zkoss.zss.ui.Spreadsheet.updateSheetAttributes(Spreadsheet.java:839)
      8. org.zkoss.zss.ui.Spreadsheet.setSelectedSheetDirectly(Spreadsheet.java:778)
      9. org.zkoss.zss.ui.Spreadsheet.access$41(Spreadsheet.java:756)
      10. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.setSelectedSheetDirectly(Spreadsheet.java:3495)
      11. org.zkoss.zss.ui.au.in.SelectSheetCommand.process(SelectSheetCommand.java:87)
      12. org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:4760)
      12 frames