org.zkoss.poi.ss.formula.FormulaParseException: Unused input [(10)] after attempting to parse the formula [LOG11(10)]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via ZK-Tracker by paowang, 1 year ago
Unused input [(10)] after attempting to parse the formula [LOG11(10)]
via ZK-Tracker by paowang, 1 year ago
Unused input [(10)] after attempting to parse the formula [LOG11(10)]
org.zkoss.poi.ss.formula.FormulaParseException: Unused input [(10)] after attempting to parse the formula [LOG11(10)]
at org.zkoss.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1603)
at org.zkoss.poi.ss.formula.FormulaParser.parse(FormulaParser.java:194)
at org.zkoss.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:158)
at org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:314)
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.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:497)
at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1043)
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:3062)
at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2921)
at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1652)
at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1812)
at org.zkoss.zk.ui.AbstractComponent.redrawChildren(AbstractComponent.java:1889)
at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1831)
at org.zkoss.zul.impl.PageRenderer.renderDesktop(PageRenderer.java:104)
at org.zkoss.zul.impl.PageRenderer.render(PageRenderer.java:56)
at org.zkoss.zk.ui.impl.PageImpl.redraw(PageImpl.java:856)
at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:497)
at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:316)
at org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215)
at org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
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.headerComplete(HttpConnection.java:928)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.