java.lang.RuntimeException: Internal error while trying to call public abstract java.util.List<org.raml.v2.api.model.v08.parameters.Parameter> org.raml.v2.api.model.v08.methods.MethodBase.queryParameters()

GitHub | nidi3 | 4 months ago
  1. 0

    Default type of parameters in v0.8 should be string

    GitHub | 4 months ago | nidi3
    java.lang.RuntimeException: Internal error while trying to call public abstract java.util.List<org.raml.v2.api.model.v08.parameters.Parameter> org.raml.v2.api.model.v08.methods.MethodBase.queryParameters()
  2. 0

    If we input a formula with non-existed name into cell, there will be two issues: # its value should be evaluated to *#NAME?*, but it's *#VALUE!* # the non-existed name will be generated into file after exporting reproduce steps: # open a empty file # input formula *=SUM(ABC)* into A1 # it should be *#NAME?* but *#VALUE!* # export to xlsx file and extract *workbook.xml* from file #* the xml contains *<definedName name="ABC"/>* exception stack trace {noformat} Dec 20, 2013 6:38:10 PM org.zkoss.zss.model.sys.impl.BookHelper evaluate SEVERE: error evaluating formula: SUM(ABC) at A1 java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValue(MultiOperandNumericFunction.java:224) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValues(MultiOperandNumericFunction.java:164) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.getNumberArray(MultiOperandNumericFunction.java:129) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.evaluate(MultiOperandNumericFunction.java:91) at org.zkoss.poi.ss.formula.functions.OverridableFunction.evaluate(OverridableFunction.java:65) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:573) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:318) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:257) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:267) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120) at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:510) at org.zkoss.zss.model.sys.impl.BookHelper.reevaluate(BookHelper.java:326) at org.zkoss.zss.model.sys.impl.BookHelper.reevaluateAndNotify(BookHelper.java:496) at org.zkoss.zss.model.sys.impl.XRangeImpl.reevaluateAndNotify(XRangeImpl.java:443) at org.zkoss.zss.model.sys.impl.XRangeImpl.setEditText(XRangeImpl.java:397) at org.zkoss.zss.api.impl.RangeImpl.setCellEditText(RangeImpl.java:599) at org.zkoss.zss.ui.impl.undo.CellEditTextAction.applyAction(CellEditTextAction.java:51) at org.zkoss.zss.ui.impl.undo.AbstractEditTextAction.doAction(AbstractEditTextAction.java:82) at org.zkoss.zssex.ui.impl.UndoableActionManagerImpl.doAction(UndoableActionManagerImpl.java:50) at org.zkoss.zss.ui.Spreadsheet.processStopEditing0(Spreadsheet.java:4554) at org.zkoss.zss.ui.Spreadsheet.processStopEditing(Spreadsheet.java:4507) at org.zkoss.zss.ui.Spreadsheet.access$47(Spreadsheet.java:4505) at org.zkoss.zss.ui.Spreadsheet$2.onEvent(Spreadsheet.java:354) at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2743) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2714) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2655) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720) at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215) at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:601) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Dec 20, 2013 6:38:10 PM org.zkoss.zss.model.sys.impl.BookHelper evaluate SEVERE: error evaluating formula: SUM(ABC) at A1 java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValue(MultiOperandNumericFunction.java:224) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValues(MultiOperandNumericFunction.java:164) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.getNumberArray(MultiOperandNumericFunction.java:129) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.evaluate(MultiOperandNumericFunction.java:91) at org.zkoss.poi.ss.formula.functions.OverridableFunction.evaluate(OverridableFunction.java:65) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:573) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:318) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:257) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:267) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120) at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:510) at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1074) at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:343) at org.zkoss.zss.ui.impl.CellFormatHelper.getInnerHtmlStyle(CellFormatHelper.java:303) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3233) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3087) at org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2676) at org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2645) at org.zkoss.zss.ui.Spreadsheet.access$13(Spreadsheet.java:2598) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2293) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2278) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2042) at org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43) at org.zkoss.zssex.engine.impl.RefBookImpl$DelegateListener.onEvent(RefBookImpl.java:117) at org.zkoss.zk.ui.event.impl.DesktopEventQueue$QueueListener.onEvent(DesktopEventQueue.java:150) at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2743) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2714) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2655) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720) at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215) at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:601) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Dec 20, 2013 6:38:10 PM org.zkoss.zss.model.sys.impl.BookHelper evaluate SEVERE: error evaluating formula: SUM(ABC) at A1 java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValue(MultiOperandNumericFunction.java:224) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValues(MultiOperandNumericFunction.java:164) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.getNumberArray(MultiOperandNumericFunction.java:129) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.evaluate(MultiOperandNumericFunction.java:91) at org.zkoss.poi.ss.formula.functions.OverridableFunction.evaluate(OverridableFunction.java:65) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:573) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:318) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:257) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:267) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120) at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:510) at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1074) at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:343) at org.zkoss.zssex.ui.impl.XUtils.getRichCellHtmlText(XUtils.java:44) at org.zkoss.zssex.ui.impl.CellDisplayLoaderImpl.getCellHtmlText(CellDisplayLoaderImpl.java:34) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3255) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3087) at org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2676) at org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2645) at org.zkoss.zss.ui.Spreadsheet.access$13(Spreadsheet.java:2598) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2293) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2278) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2042) at org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43) at org.zkoss.zssex.engine.impl.RefBookImpl$DelegateListener.onEvent(RefBookImpl.java:117) at org.zkoss.zk.ui.event.impl.DesktopEventQueue$QueueListener.onEvent(DesktopEventQueue.java:150) at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2743) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2714) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2655) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720) at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215) at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:601) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Dec 20, 2013 6:38:10 PM org.zkoss.zss.model.sys.impl.BookHelper evaluate SEVERE: error evaluating formula: SUM(ABC) at A1 java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValue(MultiOperandNumericFunction.java:224) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValues(MultiOperandNumericFunction.java:164) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.getNumberArray(MultiOperandNumericFunction.java:129) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.evaluate(MultiOperandNumericFunction.java:91) at org.zkoss.poi.ss.formula.functions.OverridableFunction.evaluate(OverridableFunction.java:65) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:573) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:318) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:257) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:267) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120) at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:510) at org.zkoss.zss.model.sys.impl.BookHelper.getHyperlink(BookHelper.java:1043) at org.zkoss.zss.ui.impl.XUtils.getHyperlink(XUtils.java:339) at org.zkoss.zssex.ui.impl.XUtils.getRichCellHtmlText(XUtils.java:54) at org.zkoss.zssex.ui.impl.CellDisplayLoaderImpl.getCellHtmlText(CellDisplayLoaderImpl.java:34) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3255) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3087) at org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2676) at org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2645) at org.zkoss.zss.ui.Spreadsheet.access$13(Spreadsheet.java:2598) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2293) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2278) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2042) at org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43) at org.zkoss.zssex.engine.impl.RefBookImpl$DelegateListener.onEvent(RefBookImpl.java:117) at org.zkoss.zk.ui.event.impl.DesktopEventQueue$QueueListener.onEvent(DesktopEventQueue.java:150) at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2743) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2714) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2655) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720) at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215) at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:601) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Dec 20, 2013 6:38:10 PM org.zkoss.zss.model.sys.impl.BookHelper evaluate SEVERE: error evaluating formula: SUM(ABC) at A1 java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValue(MultiOperandNumericFunction.java:224) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValues(MultiOperandNumericFunction.java:164) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.getNumberArray(MultiOperandNumericFunction.java:129) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.evaluate(MultiOperandNumericFunction.java:91) at org.zkoss.poi.ss.formula.functions.OverridableFunction.evaluate(OverridableFunction.java:65) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:573) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:318) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:257) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:267) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120) at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:510) at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1074) at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:343) at org.zkoss.zss.ui.impl.XUtils.getCellFormatText(XUtils.java:88) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3258) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3087) at org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2676) at org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2645) at org.zkoss.zss.ui.Spreadsheet.access$13(Spreadsheet.java:2598) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2293) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2278) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2042) at org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43) at org.zkoss.zssex.engine.impl.RefBookImpl$DelegateListener.onEvent(RefBookImpl.java:117) at org.zkoss.zk.ui.event.impl.DesktopEventQueue$QueueListener.onEvent(DesktopEventQueue.java:150) at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2743) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2714) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2655) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720) at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215) at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:601) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) {noformat}

    ZK-Tracker | 3 years ago | paowang
    java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval)
  3. 0

    If we input a formula with non-existed name into cell, there will be two issues: # its value should be evaluated to *#NAME?*, but it's *#VALUE!* # the non-existed name will be generated into file after exporting reproduce steps: # open a empty file # input formula *=SUM(ABC)* into A1 # it should be *#NAME?* but *#VALUE!* # export to xlsx file and extract *workbook.xml* from file #* the xml contains *<definedName name="ABC"/>* exception stack trace {noformat} Dec 20, 2013 6:38:10 PM org.zkoss.zss.model.sys.impl.BookHelper evaluate SEVERE: error evaluating formula: SUM(ABC) at A1 java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValue(MultiOperandNumericFunction.java:224) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValues(MultiOperandNumericFunction.java:164) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.getNumberArray(MultiOperandNumericFunction.java:129) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.evaluate(MultiOperandNumericFunction.java:91) at org.zkoss.poi.ss.formula.functions.OverridableFunction.evaluate(OverridableFunction.java:65) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:573) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:318) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:257) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:267) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120) at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:510) at org.zkoss.zss.model.sys.impl.BookHelper.reevaluate(BookHelper.java:326) at org.zkoss.zss.model.sys.impl.BookHelper.reevaluateAndNotify(BookHelper.java:496) at org.zkoss.zss.model.sys.impl.XRangeImpl.reevaluateAndNotify(XRangeImpl.java:443) at org.zkoss.zss.model.sys.impl.XRangeImpl.setEditText(XRangeImpl.java:397) at org.zkoss.zss.api.impl.RangeImpl.setCellEditText(RangeImpl.java:599) at org.zkoss.zss.ui.impl.undo.CellEditTextAction.applyAction(CellEditTextAction.java:51) at org.zkoss.zss.ui.impl.undo.AbstractEditTextAction.doAction(AbstractEditTextAction.java:82) at org.zkoss.zssex.ui.impl.UndoableActionManagerImpl.doAction(UndoableActionManagerImpl.java:50) at org.zkoss.zss.ui.Spreadsheet.processStopEditing0(Spreadsheet.java:4554) at org.zkoss.zss.ui.Spreadsheet.processStopEditing(Spreadsheet.java:4507) at org.zkoss.zss.ui.Spreadsheet.access$47(Spreadsheet.java:4505) at org.zkoss.zss.ui.Spreadsheet$2.onEvent(Spreadsheet.java:354) at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2743) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2714) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2655) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720) at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215) at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:601) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Dec 20, 2013 6:38:10 PM org.zkoss.zss.model.sys.impl.BookHelper evaluate SEVERE: error evaluating formula: SUM(ABC) at A1 java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValue(MultiOperandNumericFunction.java:224) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValues(MultiOperandNumericFunction.java:164) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.getNumberArray(MultiOperandNumericFunction.java:129) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.evaluate(MultiOperandNumericFunction.java:91) at org.zkoss.poi.ss.formula.functions.OverridableFunction.evaluate(OverridableFunction.java:65) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:573) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:318) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:257) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:267) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120) at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:510) at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1074) at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:343) at org.zkoss.zss.ui.impl.CellFormatHelper.getInnerHtmlStyle(CellFormatHelper.java:303) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3233) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3087) at org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2676) at org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2645) at org.zkoss.zss.ui.Spreadsheet.access$13(Spreadsheet.java:2598) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2293) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2278) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2042) at org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43) at org.zkoss.zssex.engine.impl.RefBookImpl$DelegateListener.onEvent(RefBookImpl.java:117) at org.zkoss.zk.ui.event.impl.DesktopEventQueue$QueueListener.onEvent(DesktopEventQueue.java:150) at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2743) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2714) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2655) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720) at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215) at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:601) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Dec 20, 2013 6:38:10 PM org.zkoss.zss.model.sys.impl.BookHelper evaluate SEVERE: error evaluating formula: SUM(ABC) at A1 java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValue(MultiOperandNumericFunction.java:224) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValues(MultiOperandNumericFunction.java:164) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.getNumberArray(MultiOperandNumericFunction.java:129) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.evaluate(MultiOperandNumericFunction.java:91) at org.zkoss.poi.ss.formula.functions.OverridableFunction.evaluate(OverridableFunction.java:65) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:573) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:318) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:257) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:267) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120) at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:510) at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1074) at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:343) at org.zkoss.zssex.ui.impl.XUtils.getRichCellHtmlText(XUtils.java:44) at org.zkoss.zssex.ui.impl.CellDisplayLoaderImpl.getCellHtmlText(CellDisplayLoaderImpl.java:34) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3255) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3087) at org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2676) at org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2645) at org.zkoss.zss.ui.Spreadsheet.access$13(Spreadsheet.java:2598) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2293) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2278) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2042) at org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43) at org.zkoss.zssex.engine.impl.RefBookImpl$DelegateListener.onEvent(RefBookImpl.java:117) at org.zkoss.zk.ui.event.impl.DesktopEventQueue$QueueListener.onEvent(DesktopEventQueue.java:150) at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2743) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2714) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2655) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720) at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215) at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:601) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Dec 20, 2013 6:38:10 PM org.zkoss.zss.model.sys.impl.BookHelper evaluate SEVERE: error evaluating formula: SUM(ABC) at A1 java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValue(MultiOperandNumericFunction.java:224) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValues(MultiOperandNumericFunction.java:164) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.getNumberArray(MultiOperandNumericFunction.java:129) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.evaluate(MultiOperandNumericFunction.java:91) at org.zkoss.poi.ss.formula.functions.OverridableFunction.evaluate(OverridableFunction.java:65) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:573) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:318) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:257) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:267) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120) at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:510) at org.zkoss.zss.model.sys.impl.BookHelper.getHyperlink(BookHelper.java:1043) at org.zkoss.zss.ui.impl.XUtils.getHyperlink(XUtils.java:339) at org.zkoss.zssex.ui.impl.XUtils.getRichCellHtmlText(XUtils.java:54) at org.zkoss.zssex.ui.impl.CellDisplayLoaderImpl.getCellHtmlText(CellDisplayLoaderImpl.java:34) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3255) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3087) at org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2676) at org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2645) at org.zkoss.zss.ui.Spreadsheet.access$13(Spreadsheet.java:2598) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2293) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2278) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2042) at org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43) at org.zkoss.zssex.engine.impl.RefBookImpl$DelegateListener.onEvent(RefBookImpl.java:117) at org.zkoss.zk.ui.event.impl.DesktopEventQueue$QueueListener.onEvent(DesktopEventQueue.java:150) at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2743) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2714) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2655) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720) at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215) at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:601) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Dec 20, 2013 6:38:10 PM org.zkoss.zss.model.sys.impl.BookHelper evaluate SEVERE: error evaluating formula: SUM(ABC) at A1 java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValue(MultiOperandNumericFunction.java:224) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValues(MultiOperandNumericFunction.java:164) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.getNumberArray(MultiOperandNumericFunction.java:129) at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.evaluate(MultiOperandNumericFunction.java:91) at org.zkoss.poi.ss.formula.functions.OverridableFunction.evaluate(OverridableFunction.java:65) at org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:573) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:318) at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:257) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:267) at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120) at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:510) at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1074) at org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:343) at org.zkoss.zss.ui.impl.XUtils.getCellFormatText(XUtils.java:88) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3258) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3087) at org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2676) at org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2645) at org.zkoss.zss.ui.Spreadsheet.access$13(Spreadsheet.java:2598) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2293) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2278) at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2042) at org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43) at org.zkoss.zssex.engine.impl.RefBookImpl$DelegateListener.onEvent(RefBookImpl.java:117) at org.zkoss.zk.ui.event.impl.DesktopEventQueue$QueueListener.onEvent(DesktopEventQueue.java:150) at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2743) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2714) at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2655) at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720) at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215) at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:601) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) {noformat}

    ZK-Tracker | 3 years ago | paowang
    java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [ZSS-349] When adding a chart, if selected cells contains errors, spreadsheet throw a runtime exception - ZK-Tracker

    zkoss.org | 1 year ago
    java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval)
  6. 0

    h3. Problem Description: When adding a chart, if selected cells contains errors, e.g. #NAME? or #VALUE!, spreadsheet throw a runtime exception. The message is hard to understand. [1] Selected cells contains *#VALUE!*. Reproducing steps: # load attached file *chart-data.xlsx* # select cells from *A3* to *D6* # insert any chart #* throw exception: "*Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval)*" Stack trace: {noformat} Jun 28, 2013 3:47:55 PM org.zkoss.zk.ui.impl.UiEngineImpl handleError:1359 SEVERE: >>java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval) >> at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValue(MultiOperandNumericFunction.java:224) >> at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValues(MultiOperandNumericFunction.java:164) >> at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.getNumberArray(MultiOperandNumericFunction.java:129) >> at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.evaluate(MultiOperandNumericFunction.java:91) >> 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:267) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120) >> at org.zkoss.poi.ss.usermodel.charts.DataSources$AbstractCellRangeDataSource.getCellValueAt(DataSources.java:149) >> at org.zkoss.poi.ss.usermodel.charts.DataSources$1.getPointAt(DataSources.java:44) >> at org.zkoss.poi.ss.usermodel.charts.DataSources$1.getPointAt(DataSources.java:1) >> at org.zkoss.poi.xssf.usermodel.charts.XSSFChartUtil.fillNumCache(XSSFChartUtil.java:123) >> at org.zkoss.poi.xssf.usermodel.charts.XSSFChartUtil.buildNumRef(XSSFChartUtil.java:89) >> at org.zkoss.poi.xssf.usermodel.charts.XSSFChartUtil.buildNumDataSource(XSSFChartUtil.java:80) >> at org.zkoss.poi.xssf.usermodel.charts.XSSFBarChartData$Serie.addToChart(XSSFBarChartData.java:141) >> at org.zkoss.poi.xssf.usermodel.charts.XSSFBarChartData.fillChart(XSSFBarChartData.java:172) >> at org.zkoss.poi.xssf.usermodel.XSSFChart.plot(XSSFChart.java:233) >> at org.zkoss.zssex.model.impl.DrawingManagerImpl.addChartX(DrawingManagerImpl.java:333) >> at org.zkoss.zss.model.sys.impl.XRangeImpl.addChart(XRangeImpl.java:2254) >> at org.zkoss.zss.api.impl.RangeImpl.addChart(RangeImpl.java:754) >> at org.zkoss.zss.api.SheetOperationUtil.addChart(SheetOperationUtil.java:155) >> at org.zkoss.zssex.ui.DefaultExUserActionHandler.doChart(DefaultExUserActionHandler.java:305) >> at org.zkoss.zssex.ui.DefaultExUserActionHandler.doColumnChart(DefaultExUserActionHandler.java:312) >> at org.zkoss.zssex.ui.DefaultExUserActionHandler.dispatchAction(DefaultExUserActionHandler.java:215) >> at org.zkoss.zss.ui.DefaultUserActionHandler.onEvent(DefaultUserActionHandler.java:1387) >> at org.zkoss.zssex.ui.DefaultExUserActionHandler.onEvent(DefaultExUserActionHandler.java:83) >> at org.zkoss.zss.ui.Spreadsheet$3.onEvent(Spreadsheet.java:343) >> at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2748) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2719) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2660) >> at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) >> at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1717) >> at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1502) >> at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1212) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:600) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:482) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:491) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) >> at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) >> at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) >> at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) >> at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) >> at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) >> at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) >> at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) >> at org.mortbay.jetty.Server.handle(Server.java:326) >> at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) >> at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) >> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) >> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) >> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) >> at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) >> at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) {noformat} [2] Selected cells contains *#NAME?*. Reproducing steps: # load attached file *chart-data.xlsx* # select cells from *A7* to *D9* # insert any chart #* throw exception: "*Unexpected eval class (org.zkoss.poi.ss.formula.eval.NameEval)*" Stack trace: {noformat} 2013/6/19 下午 04:07:30 org.zkoss.zk.ui.impl.UiEngineImpl handleError:1359 Jun 28, 2013 3:55:02 PM org.zkoss.zk.ui.impl.UiEngineImpl handleError:1359 SEVERE: >>java.lang.RuntimeException: Unexpected eval class (org.zkoss.poi.ss.formula.eval.NameEval) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.getCellValueByValueEval(XSSFFormulaEvaluator.java:310) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:268) >> at org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120) >> at org.zkoss.poi.ss.usermodel.charts.DataSources$AbstractCellRangeDataSource.getCellValueAt(DataSources.java:149) >> at org.zkoss.poi.ss.usermodel.charts.DataSources$1.getPointAt(DataSources.java:44) >> at org.zkoss.poi.ss.usermodel.charts.DataSources$1.getPointAt(DataSources.java:1) >> at org.zkoss.poi.xssf.usermodel.charts.XSSFChartUtil.fillNumCache(XSSFChartUtil.java:123) >> at org.zkoss.poi.xssf.usermodel.charts.XSSFChartUtil.buildNumRef(XSSFChartUtil.java:89) >> at org.zkoss.poi.xssf.usermodel.charts.XSSFChartUtil.buildNumDataSource(XSSFChartUtil.java:80) >> at org.zkoss.poi.xssf.usermodel.charts.XSSFLineChartData$Serie.addToChart(XSSFLineChartData.java:102) >> at org.zkoss.poi.xssf.usermodel.charts.XSSFLineChartData.fillChart(XSSFLineChartData.java:131) >> at org.zkoss.poi.xssf.usermodel.XSSFChart.plot(XSSFChart.java:233) >> at org.zkoss.zssex.model.impl.DrawingManagerImpl.addChartX(DrawingManagerImpl.java:333) >> at org.zkoss.zss.model.sys.impl.XRangeImpl.addChart(XRangeImpl.java:2254) >> at org.zkoss.zss.api.impl.RangeImpl.addChart(RangeImpl.java:754) >> at org.zkoss.zss.api.SheetOperationUtil.addChart(SheetOperationUtil.java:155) >> at org.zkoss.zssex.ui.DefaultExUserActionHandler.doChart(DefaultExUserActionHandler.java:305) >> at org.zkoss.zssex.ui.DefaultExUserActionHandler.doLineChart(DefaultExUserActionHandler.java:320) >> at org.zkoss.zssex.ui.DefaultExUserActionHandler.dispatchAction(DefaultExUserActionHandler.java:219) >> at org.zkoss.zss.ui.DefaultUserActionHandler.onEvent(DefaultUserActionHandler.java:1387) >> at org.zkoss.zssex.ui.DefaultExUserActionHandler.onEvent(DefaultExUserActionHandler.java:83) >> at org.zkoss.zss.ui.Spreadsheet$3.onEvent(Spreadsheet.java:343) >> at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2748) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2719) >> at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2660) >> at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136) >> at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1717) >> at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1502) >> at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1212) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:600) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:482) >> at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:491) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) >> at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) >> at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) >> at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) >> at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) >> at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) >> at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) >> at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) >> at org.mortbay.jetty.Server.handle(Server.java:326) >> at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) >> at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945) >> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756) >> at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218) >> at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) >> at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) >> at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) {noformat} If we insert a chart using those cells in Excel 2007, it will work fine and error cell will be zero: !excel.png!

    ZK-Tracker | 3 years ago | hawk
    java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval)

    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.RuntimeException

      Invalid node for type creation class org.raml.yagi.framework.nodes.KeyValueNodeImpl

      at org.raml.v2.internal.impl.commons.model.factory.TypeDeclarationModelFactory.create()
    2. org.raml.v2
      TypeDeclarationModelFactory.create
      1. org.raml.v2.internal.impl.commons.model.factory.TypeDeclarationModelFactory.create(TypeDeclarationModelFactory.java:81)
      2. org.raml.v2.internal.impl.commons.model.factory.TypeDeclarationModelFactory.create(TypeDeclarationModelFactory.java:60)
      2 frames
    3. org.raml.yagi
      ModelProxyBuilder$SimpleProxy.invoke
      1. org.raml.yagi.framework.model.ModelProxyBuilder$SimpleProxy.resolveValue(ModelProxyBuilder.java:192)
      2. org.raml.yagi.framework.model.ModelProxyBuilder$SimpleProxy.resolveValue(ModelProxyBuilder.java:164)
      3. org.raml.yagi.framework.model.ModelProxyBuilder$SimpleProxy.fromNodeKey(ModelProxyBuilder.java:88)
      4. org.raml.yagi.framework.model.ModelProxyBuilder$SimpleProxy.invoke(ModelProxyBuilder.java:70)
      4 frames
    4. com.sun.proxy
      $Proxy9.queryParameters
      1. com.sun.proxy.$Proxy9.queryParameters(Unknown Source)
      1 frame
    5. guru.nidi.ramltester
      HeaderTest.undefinedRequestHeader
      1. guru.nidi.ramltester.HeaderTest.undefinedRequestHeader(HeaderTest.java:47)
      1 frame
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    7. JUnit
      JUnitCore.run
      1. org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
      2. org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
      3. org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
      4. org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
      5. org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
      6. org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
      7. org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
      8. org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
      9. org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
      10. org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
      11. org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
      12. org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
      13. org.junit.rules.Verifier$1.evaluate(Verifier.java:35)
      14. org.junit.rules.RunRules.evaluate(RunRules.java:20)
      15. org.junit.runners.ParentRunner.run(ParentRunner.java:363)
      16. org.junit.runner.JUnitCore.run(JUnitCore.java:137)
      16 frames
    8. IntelliJ junit4 module
      JUnit4IdeaTestRunner.startRunnerWithArgs
      1. com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:119)
      2. com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:42)
      2 frames
    9. IDEA
      JUnitStarter.main
      1. com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:234)
      2. com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:74)
      2 frames