Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-342

When a ZK defined formula has missing required arguments, it throws NotImplementedException

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 3.0.0 RC
    • Fix Version/s: 3.0.0 RC
    • Component/s: ZSS Component
    • Labels:

      Description

      Problem description:

      when we enter a formula with miss required arguments, it throws NotImplementedException.

      >>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)

      reproducing Steps:

      1. open the spreadsheet
      2. enter "=ACCRINT()"

      Expected:
      #VALUE!

      Actual:
      the exception shown above.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                hawk hawk
                Reporter:
                hawk hawk
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: