java.lang.RuntimeException: Invalid ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval)

ZK-Tracker | paowang | 3 years ago
  1. 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)
  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

    [ZSS-269] error evaluating some financial formulas - ZK-Tracker

    zkoss.org | 1 year ago
    java.lang.RuntimeException: Unexpected arg eval type (org.zkoss.poi.ss.formula.eval.MissingArgEval)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    h3. problem description: not found formula: ISPMT, LOGEST, MIRR, VDB {code} java.lang.AssertionError: =ISPMT(B71/12,C71,D71*12,E71) failed, at row 70 in xsheet: formula-financial Expected: "-64814.81" but: was "#NAME?" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20) {code} \\ \\ \\ ---- error in evaluating PV(0.08/12,20*12,500, ,0) {code} java.lang.AssertionError: =PV(0.08/12,20*12,500, ,0) failed, at row 99 in xsheet: formula-financial Expected: "-59777.15" but: was "Unexpected arg eval type (org.zkoss.poi.ss.formula.eval.MissingArgEval)" 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.testFinancial(FormulaTest.java:96) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) {code} Exception stack trace: {code} 嚴重的: >>java.lang.RuntimeException: Unexpected arg eval type (org.zkoss.poi.ss.formula.eval.MissingArgEval) >> at org.zkoss.poi.ss.formula.eval.OperandResolver.coerceValueToDouble(OperandResolver.java:233) >> at org.zkoss.poi.ss.formula.functions.NumericFunction.singleOperandEvaluate(NumericFunction.java:38) >> at org.zkoss.poi.ss.formula.functions.FinanceFunction.evaluate(FinanceFunction.java:53) >> at org.zkoss.poi.ss.formula.functions.FinanceFunction.evaluate(FinanceFunction.java:69) >> 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:476) >> at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1018) >> 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:3066) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2940) >> at org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2609) >> at org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2557) >> at org.zkoss.zss.ui.Spreadsheet.access$12(Spreadsheet.java:2506) >> at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2266) >> at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2256) >> at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2015) >> at org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43) {code} \\ \\ \\ ---- some formula evaluation results are slightly different from expected (one more space character than expected): *DDB, FV, NPV, SLN, SYD, PMT, PPMT* {code} java.lang.AssertionError: =DDB(B43,C43,D43*365,1) failed, at row 42 in xsheet: formula-financial Expected: "1.32" but: was "1.32 " java.lang.AssertionError: =FV(B58/12,C58,D58,E58,F58) failed, at row 57 in xsheet: formula-financial Expected: "2581.40" but: was "2581.40 " java.lang.AssertionError: =NPV(0.08,8000,9200,10000,12000,14500) failed, at row 87 in xsheet: formula-financial Expected: "41922.06" but: was "41922.06 " java.lang.AssertionError: =PMT(0.08/12,10,10000) failed, at row 89 in xsheet: formula-financial Expected: "-1037.03" but: was "-1037.03 " java.lang.AssertionError: =PPMT(0.1/12,1,2*12,2000) failed, at row 91 in xsheet: formula-financial Expected: "-75.62" but: was "-75.62 " {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.RuntimeException: Unexpected arg eval type (org.zkoss.poi.ss.formula.eval.MissingArgEval)
  6. 0

    h3. problem description: not found formula: ISPMT, LOGEST, MIRR, VDB {code} java.lang.AssertionError: =ISPMT(B71/12,C71,D71*12,E71) failed, at row 70 in xsheet: formula-financial Expected: "-64814.81" but: was "#NAME?" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20) {code} \\ \\ \\ ---- error in evaluating PV(0.08/12,20*12,500, ,0) {code} java.lang.AssertionError: =PV(0.08/12,20*12,500, ,0) failed, at row 99 in xsheet: formula-financial Expected: "-59777.15" but: was "Unexpected arg eval type (org.zkoss.poi.ss.formula.eval.MissingArgEval)" 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.testFinancial(FormulaTest.java:96) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) {code} Exception stack trace: {code} 嚴重的: >>java.lang.RuntimeException: Unexpected arg eval type (org.zkoss.poi.ss.formula.eval.MissingArgEval) >> at org.zkoss.poi.ss.formula.eval.OperandResolver.coerceValueToDouble(OperandResolver.java:233) >> at org.zkoss.poi.ss.formula.functions.NumericFunction.singleOperandEvaluate(NumericFunction.java:38) >> at org.zkoss.poi.ss.formula.functions.FinanceFunction.evaluate(FinanceFunction.java:53) >> at org.zkoss.poi.ss.formula.functions.FinanceFunction.evaluate(FinanceFunction.java:69) >> 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:476) >> at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1018) >> 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:3066) >> at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2940) >> at org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2609) >> at org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2557) >> at org.zkoss.zss.ui.Spreadsheet.access$12(Spreadsheet.java:2506) >> at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2266) >> at org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2256) >> at org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2015) >> at org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43) {code} \\ \\ \\ ---- some formula evaluation results are slightly different from expected (one more space character than expected): *DDB, FV, NPV, SLN, SYD, PMT, PPMT* {code} java.lang.AssertionError: =DDB(B43,C43,D43*365,1) failed, at row 42 in xsheet: formula-financial Expected: "1.32" but: was "1.32 " java.lang.AssertionError: =FV(B58/12,C58,D58,E58,F58) failed, at row 57 in xsheet: formula-financial Expected: "2581.40" but: was "2581.40 " java.lang.AssertionError: =NPV(0.08,8000,9200,10000,12000,14500) failed, at row 87 in xsheet: formula-financial Expected: "41922.06" but: was "41922.06 " java.lang.AssertionError: =PMT(0.08/12,10,10000) failed, at row 89 in xsheet: formula-financial Expected: "-1037.03" but: was "-1037.03 " java.lang.AssertionError: =PPMT(0.1/12,1,2*12,2000) failed, at row 91 in xsheet: formula-financial Expected: "-75.62" but: was "-75.62 " {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.RuntimeException: Unexpected arg eval type (org.zkoss.poi.ss.formula.eval.MissingArgEval)

    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 ValueEval type passed for conversion: (class org.zkoss.poi.ss.formula.eval.NameEval)

      at org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValue()
    2. org.zkoss.poi
      XSSFFormulaEvaluator.evaluate
      1. org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValue(MultiOperandNumericFunction.java:224)
      2. org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.collectValues(MultiOperandNumericFunction.java:164)
      3. org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.getNumberArray(MultiOperandNumericFunction.java:129)
      4. org.zkoss.poi.ss.formula.functions.MultiOperandNumericFunction.evaluate(MultiOperandNumericFunction.java:91)
      5. org.zkoss.poi.ss.formula.functions.OverridableFunction.evaluate(OverridableFunction.java:65)
      6. org.zkoss.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:132)
      7. org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:573)
      8. org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:318)
      9. org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:257)
      10. org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:267)
      11. org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120)
      11 frames
    3. org.zkoss.zss
      EventDispatchListener.onEvent
      1. org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:510)
      2. org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1074)
      3. org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:343)
      4. org.zkoss.zss.ui.impl.CellFormatHelper.getInnerHtmlStyle(CellFormatHelper.java:303)
      5. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3233)
      6. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3087)
      7. org.zkoss.zss.ui.Spreadsheet.responseUpdateCell(Spreadsheet.java:2676)
      8. org.zkoss.zss.ui.Spreadsheet.updateCell(Spreadsheet.java:2645)
      9. org.zkoss.zss.ui.Spreadsheet.access$13(Spreadsheet.java:2598)
      10. org.zkoss.zss.ui.Spreadsheet$InnerDataListener.onContentChange(Spreadsheet.java:2293)
      11. org.zkoss.zss.ui.Spreadsheet$InnerDataListener.access$6(Spreadsheet.java:2278)
      12. org.zkoss.zss.ui.Spreadsheet$InnerDataListener$7.onEvent(Spreadsheet.java:2042)
      13. org.zkoss.zss.engine.event.EventDispatchListener.onEvent(EventDispatchListener.java:43)
      13 frames
    4. org.zkoss.zssex
      RefBookImpl$DelegateListener.onEvent
      1. org.zkoss.zssex.engine.impl.RefBookImpl$DelegateListener.onEvent(RefBookImpl.java:117)
      1 frame
    5. ZK Kernel
      DHtmlUpdateServlet.doPost
      1. org.zkoss.zk.ui.event.impl.DesktopEventQueue$QueueListener.onEvent(DesktopEventQueue.java:150)
      2. org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2743)
      3. org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2714)
      4. org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2655)
      5. org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
      6. org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1720)
      7. org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1505)
      8. org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1215)
      9. org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:601)
      10. org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483)
      11. org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492)
      11 frames
    6. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      2 frames
    7. Jetty Server
      SelectChannelEndPoint.run
      1. org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
      2. org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401)
      3. org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
      4. org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
      5. org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
      6. org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
      7. org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
      8. org.mortbay.jetty.Server.handle(Server.java:326)
      9. org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
      10. org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945)
      11. org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
      12. org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
      13. org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
      14. org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
      14 frames
    8. Jetty Util
      QueuedThreadPool$PoolThread.run
      1. org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
      1 frame