org.zkoss.poi.ss.formula.FormulaParseException: The specified formula 'cell!$A$16:$D$0' contains an error. Expects number, string, or defined name.

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

Solutions on the web

via ZK-Tracker by paowang, 1 year ago
The specified formula 'cell!$A$16:$D$0' contains an error. Expects number, string, or defined name.
via ZK-Tracker by paowang, 1 year ago
The specified formula 'cell!$A$16:$D$0' contains an error. Expects number, string, or defined name.
org.zkoss.poi.ss.formula.FormulaParseException: The specified formula 'cell!$A$16:$D$0' contains an error. Expects number, string, or defined name.
at org.zkoss.poi.ss.formula.FormulaParser.expected(FormulaParser.java:1625)
at org.zkoss.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:569)
at org.zkoss.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:447)
at org.zkoss.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:291)
at org.zkoss.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1149)
at org.zkoss.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1109)
at org.zkoss.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1096)
at org.zkoss.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1456)
at org.zkoss.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1556)
at org.zkoss.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1540)
at org.zkoss.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1497)
at org.zkoss.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1477)
at org.zkoss.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1598)
at org.zkoss.poi.ss.formula.FormulaParser.parse(FormulaParser.java:194)
at org.zkoss.poi.xssf.usermodel.XSSFName.setRefersToFormula(XSSFName.java:195)
at org.zkoss.poi.xssf.usermodel.XSSFSheet.setAutoFilter(XSSFSheet.java:3409)
at org.zkoss.zss.model.sys.impl.XRangeImpl.autoFilter(XRangeImpl.java:2070)
at org.zkoss.zss.api.impl.RangeImpl.enableAutoFilter(RangeImpl.java:552)
at org.zkoss.zss.api.SheetOperationUtil.toggleAutoFilter(SheetOperationUtil.java:45)
at org.zkoss.zss.ui.DefaultUserActionHandler.doFilter(DefaultUserActionHandler.java:1168)
at org.zkoss.zss.ui.DefaultUserActionHandler.dispatchAction(DefaultUserActionHandler.java:255)
at org.zkoss.zssex.ui.DefaultExUserActionHandler.dispatchAction(DefaultExUserActionHandler.java:240)
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)

Users with the same issue

You are the first who have seen this exception.

Write tip

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