org.zkoss.poi.ss.formula.eval.EvaluationException: no matched type: org.zkoss.poi.ss.formula.eval.ErrorEval [#REF!]

ZK-Tracker | dennis | 3 years ago
  1. 0

    get console exception when running testcase 590-wrong-chart.zul Mar 7, 2014 2:45:35 AM org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl evaluate:283 SEVERE: no matched type: org.zkoss.poi.ss.formula.eval.ErrorEval [#REF!] when eval '#REF'!$B$13 org.zkoss.poi.ss.formula.eval.EvaluationException: no matched type: org.zkoss.poi.ss.formula.eval.ErrorEval [#REF!] at org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.getResolvedValue(FormulaEngineImpl.java:352) at org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.evaluateFormula(FormulaEngineImpl.java:337) at org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.evaluate(FormulaEngineImpl.java:269) at org.zkoss.zss.model.impl.chart.SeriesImpl.evalFormula(SeriesImpl.java:66) at org.zkoss.zss.model.impl.chart.SeriesImpl.getName(SeriesImpl.java:119) at org.zkoss.zssex.util.ChartHelper.prepareXYZModel(ChartHelper.java:369) at org.zkoss.zssex.util.ChartHelper.drawChart(ChartHelper.java:189) at org.zkoss.zssex.ui.widget.ChartWidget.initChart(ChartWidget.java:121) at org.zkoss.zssex.ui.widget.ChartWidget.<init>(ChartWidget.java:46) at org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.newChartWidget(DefaultBookWidgetLoader.java:414) at org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.newChartWidgetGroup(DefaultBookWidgetLoader.java:407) at org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.prepareChartWidgets(DefaultBookWidgetLoader.java:174) at org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.onSheetSelected(DefaultBookWidgetLoader.java:84) at org.zkoss.zss.ui.Spreadsheet.afterSheetSelected(Spreadsheet.java:4278) at org.zkoss.zss.ui.Spreadsheet.setSelectedSheet(Spreadsheet.java:889) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onSheetDelete(Spreadsheet.java:2278) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$3(Spreadsheet.java:2265) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$4.onEvent(Spreadsheet.java:2078) at org.zkoss.zss.model.ModelEventDispatcher.onEvent(ModelEventDispatcher.java:37) at org.zkoss.zss.model.impl.EventListenerAdaptorImpl.sendModelEvent(EventListenerAdaptorImpl.java:54) at org.zkoss.zss.model.impl.BookImpl.sendModelEvent(BookImpl.java:194) at org.zkoss.zss.range.impl.NotifyChangeHelper.notifySheetDelete(NotifyChangeHelper.java:117) at org.zkoss.zss.range.impl.RangeImpl$31.doNotifyPhase(RangeImpl.java:1100) at org.zkoss.zss.range.impl.RangeImpl$ModelUpdateTask.invoke(RangeImpl.java:1411) at org.zkoss.zss.model.util.ReadWriteTask.doInWriteLock(ReadWriteTask.java:34) at org.zkoss.zss.range.impl.RangeImpl.deleteSheet(RangeImpl.java:1103) at org.zkoss.zss.api.impl.RangeImpl.deleteSheet(RangeImpl.java:630) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597)

    ZK-Tracker | 3 years ago | dennis
    org.zkoss.poi.ss.formula.eval.EvaluationException: no matched type: org.zkoss.poi.ss.formula.eval.ErrorEval [#REF!]
  2. 0

    get console exception when running testcase 590-wrong-chart.zul Mar 7, 2014 2:45:35 AM org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl evaluate:283 SEVERE: no matched type: org.zkoss.poi.ss.formula.eval.ErrorEval [#REF!] when eval '#REF'!$B$13 org.zkoss.poi.ss.formula.eval.EvaluationException: no matched type: org.zkoss.poi.ss.formula.eval.ErrorEval [#REF!] at org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.getResolvedValue(FormulaEngineImpl.java:352) at org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.evaluateFormula(FormulaEngineImpl.java:337) at org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.evaluate(FormulaEngineImpl.java:269) at org.zkoss.zss.model.impl.chart.SeriesImpl.evalFormula(SeriesImpl.java:66) at org.zkoss.zss.model.impl.chart.SeriesImpl.getName(SeriesImpl.java:119) at org.zkoss.zssex.util.ChartHelper.prepareXYZModel(ChartHelper.java:369) at org.zkoss.zssex.util.ChartHelper.drawChart(ChartHelper.java:189) at org.zkoss.zssex.ui.widget.ChartWidget.initChart(ChartWidget.java:121) at org.zkoss.zssex.ui.widget.ChartWidget.<init>(ChartWidget.java:46) at org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.newChartWidget(DefaultBookWidgetLoader.java:414) at org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.newChartWidgetGroup(DefaultBookWidgetLoader.java:407) at org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.prepareChartWidgets(DefaultBookWidgetLoader.java:174) at org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.onSheetSelected(DefaultBookWidgetLoader.java:84) at org.zkoss.zss.ui.Spreadsheet.afterSheetSelected(Spreadsheet.java:4278) at org.zkoss.zss.ui.Spreadsheet.setSelectedSheet(Spreadsheet.java:889) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onSheetDelete(Spreadsheet.java:2278) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$3(Spreadsheet.java:2265) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$4.onEvent(Spreadsheet.java:2078) at org.zkoss.zss.model.ModelEventDispatcher.onEvent(ModelEventDispatcher.java:37) at org.zkoss.zss.model.impl.EventListenerAdaptorImpl.sendModelEvent(EventListenerAdaptorImpl.java:54) at org.zkoss.zss.model.impl.BookImpl.sendModelEvent(BookImpl.java:194) at org.zkoss.zss.range.impl.NotifyChangeHelper.notifySheetDelete(NotifyChangeHelper.java:117) at org.zkoss.zss.range.impl.RangeImpl$31.doNotifyPhase(RangeImpl.java:1100) at org.zkoss.zss.range.impl.RangeImpl$ModelUpdateTask.invoke(RangeImpl.java:1411) at org.zkoss.zss.model.util.ReadWriteTask.doInWriteLock(ReadWriteTask.java:34) at org.zkoss.zss.range.impl.RangeImpl.deleteSheet(RangeImpl.java:1103) at org.zkoss.zss.api.impl.RangeImpl.deleteSheet(RangeImpl.java:630) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597)

    ZK-Tracker | 3 years ago | dennis
    org.zkoss.poi.ss.formula.eval.EvaluationException: no matched type: org.zkoss.poi.ss.formula.eval.ErrorEval [#REF!]

    Root Cause Analysis

    1. org.zkoss.poi.ss.formula.eval.EvaluationException

      no matched type: org.zkoss.poi.ss.formula.eval.ErrorEval [#REF!]

      at org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.getResolvedValue()
    2. org.zkoss.zss
      SeriesImpl.getName
      1. org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.getResolvedValue(FormulaEngineImpl.java:352)
      2. org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.evaluateFormula(FormulaEngineImpl.java:337)
      3. org.zkoss.zss.model.impl.sys.formula.FormulaEngineImpl.evaluate(FormulaEngineImpl.java:269)
      4. org.zkoss.zss.model.impl.chart.SeriesImpl.evalFormula(SeriesImpl.java:66)
      5. org.zkoss.zss.model.impl.chart.SeriesImpl.getName(SeriesImpl.java:119)
      5 frames
    3. org.zkoss.zssex
      DefaultBookWidgetLoader.onSheetSelected
      1. org.zkoss.zssex.util.ChartHelper.prepareXYZModel(ChartHelper.java:369)
      2. org.zkoss.zssex.util.ChartHelper.drawChart(ChartHelper.java:189)
      3. org.zkoss.zssex.ui.widget.ChartWidget.initChart(ChartWidget.java:121)
      4. org.zkoss.zssex.ui.widget.ChartWidget.<init>(ChartWidget.java:46)
      5. org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.newChartWidget(DefaultBookWidgetLoader.java:414)
      6. org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.newChartWidgetGroup(DefaultBookWidgetLoader.java:407)
      7. org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.prepareChartWidgets(DefaultBookWidgetLoader.java:174)
      8. org.zkoss.zssex.ui.widget.DefaultBookWidgetLoader.onSheetSelected(DefaultBookWidgetLoader.java:84)
      8 frames
    4. org.zkoss.zss
      RangeImpl.deleteSheet
      1. org.zkoss.zss.ui.Spreadsheet.afterSheetSelected(Spreadsheet.java:4278)
      2. org.zkoss.zss.ui.Spreadsheet.setSelectedSheet(Spreadsheet.java:889)
      3. org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onSheetDelete(Spreadsheet.java:2278)
      4. org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$3(Spreadsheet.java:2265)
      5. org.zkoss.zss.ui.Spreadsheet$InnerDataListener$4.onEvent(Spreadsheet.java:2078)
      6. org.zkoss.zss.model.ModelEventDispatcher.onEvent(ModelEventDispatcher.java:37)
      7. org.zkoss.zss.model.impl.EventListenerAdaptorImpl.sendModelEvent(EventListenerAdaptorImpl.java:54)
      8. org.zkoss.zss.model.impl.BookImpl.sendModelEvent(BookImpl.java:194)
      9. org.zkoss.zss.range.impl.NotifyChangeHelper.notifySheetDelete(NotifyChangeHelper.java:117)
      10. org.zkoss.zss.range.impl.RangeImpl$31.doNotifyPhase(RangeImpl.java:1100)
      11. org.zkoss.zss.range.impl.RangeImpl$ModelUpdateTask.invoke(RangeImpl.java:1411)
      12. org.zkoss.zss.model.util.ReadWriteTask.doInWriteLock(ReadWriteTask.java:34)
      13. org.zkoss.zss.range.impl.RangeImpl.deleteSheet(RangeImpl.java:1103)
      14. org.zkoss.zss.api.impl.RangeImpl.deleteSheet(RangeImpl.java:630)
      14 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames