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

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

    If a file contains #REF! cells, it will throw a exception and can't be rendered when importing such file. Reproducing: * just load attached file *ref-error.xlsx* Stack trace: {noformat} Jun 28, 2013 3:28:03 PM org.zkoss.zss.model.sys.impl.BookHelper evaluate SEVERE: error evaluating formula: LOG11(10) at A1 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.zk.ui.sys.HtmlPageRenders.outPageContent(HtmlPageRenders.java:614) 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) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) {noformat}

    ZK-Tracker | 3 years ago | paowang
    org.zkoss.poi.ss.formula.FormulaParseException: Unused input [(10)] after attempting to parse the formula [LOG11(10)]
  2. 0

    If a file contains #REF! cells, it will throw a exception and can't be rendered when importing such file. Reproducing: * just load attached file *ref-error.xlsx* Stack trace: {noformat} Jun 28, 2013 3:28:03 PM org.zkoss.zss.model.sys.impl.BookHelper evaluate SEVERE: error evaluating formula: LOG11(10) at A1 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.zk.ui.sys.HtmlPageRenders.outPageContent(HtmlPageRenders.java:614) 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) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) {noformat}

    ZK-Tracker | 3 years ago | paowang
    org.zkoss.poi.ss.formula.FormulaParseException: Unused input [(10)] after attempting to parse the formula [LOG11(10)]
  3. 0

    Enable autofilter at some cells will throw a formula error message such as "*The specified formula 'cell!$A$16:$D$0' contains an error. Expects number, string, or defined name.*" But, if enable other cells's autofilter successfully before enabling the cell, that won't get any error and enabled autofilter normally. Reproducing steps: # load the attached file *OperationTest2007.xlsx* # select cell *D:18* and *right click* to popup menu # click menu *Filter* > *Filter* #* it will show an error message and won't enable autofilter #* !error.png! But enable other cell before enabling *D:18* won't get error: # load the attached file *OperationTest2007.xlsx* # select cell *D:4* #* enable autofilter and then disable autofilter # select cell *D:18* and enable autofilter #* it enabled autofilter normally #* !success.png! stack trace: {noformat} Jun 28, 2013 11:21:37 AM org.zkoss.zk.ui.impl.UiEngineImpl handleError:1359 SEVERE: >>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) >> at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) {noformat}

    ZK-Tracker | 3 years ago | paowang
    org.zkoss.poi.ss.formula.FormulaParseException: The specified formula 'cell!$A$16:$D$0' contains an error. Expects number, string, or defined name.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Enable autofilter at some cells will throw a formula error message such as "*The specified formula 'cell!$A$16:$D$0' contains an error. Expects number, string, or defined name.*" But, if enable other cells's autofilter successfully before enabling the cell, that won't get any error and enabled autofilter normally. Reproducing steps: # load the attached file *OperationTest2007.xlsx* # select cell *D:18* and *right click* to popup menu # click menu *Filter* > *Filter* #* it will show an error message and won't enable autofilter #* !error.png! But enable other cell before enabling *D:18* won't get error: # load the attached file *OperationTest2007.xlsx* # select cell *D:4* #* enable autofilter and then disable autofilter # select cell *D:18* and enable autofilter #* it enabled autofilter normally #* !success.png! stack trace: {noformat} Jun 28, 2013 11:21:37 AM org.zkoss.zk.ui.impl.UiEngineImpl handleError:1359 SEVERE: >>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) >> at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) {noformat}

    ZK-Tracker | 3 years ago | paowang
    org.zkoss.poi.ss.formula.FormulaParseException: The specified formula 'cell!$A$16:$D$0' contains an error. Expects number, string, or defined name.

    Root Cause Analysis

    1. 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()
    2. org.zkoss.poi
      XSSFFormulaEvaluator.evaluate
      1. org.zkoss.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1603)
      2. org.zkoss.poi.ss.formula.FormulaParser.parse(FormulaParser.java:194)
      3. org.zkoss.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:158)
      4. org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:314)
      5. org.zkoss.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:255)
      6. org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:267)
      7. org.zkoss.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluate(XSSFFormulaEvaluator.java:120)
      7 frames
    3. org.zkoss.zss
      Spreadsheet.renderProperties
      1. org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:497)
      2. org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1043)
      3. org.zkoss.zss.ui.impl.XUtils.getFormatText(XUtils.java:355)
      4. org.zkoss.zss.ui.impl.CellFormatHelper.getHtmlStyle(CellFormatHelper.java:89)
      5. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getCellAttr(Spreadsheet.java:3062)
      6. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:2921)
      7. org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1652)
      7 frames
    4. ZK Kernel
      HtmlPageRenders.outPageContent
      1. org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1812)
      2. org.zkoss.zk.ui.AbstractComponent.redrawChildren(AbstractComponent.java:1889)
      3. org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1831)
      4. org.zkoss.zk.ui.sys.HtmlPageRenders.outPageContent(HtmlPageRenders.java:614)
      4 frames
    5. ZK XUL Components
      PageRenderer.render
      1. org.zkoss.zul.impl.PageRenderer.renderDesktop(PageRenderer.java:104)
      2. org.zkoss.zul.impl.PageRenderer.render(PageRenderer.java:56)
      2 frames
    6. ZK Kernel
      DHtmlLayoutServlet.doGet
      1. org.zkoss.zk.ui.impl.PageImpl.redraw(PageImpl.java:856)
      2. org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:497)
      3. org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:316)
      4. org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:215)
      5. org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:136)
      5 frames
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      2 frames
    8. 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.headerComplete(HttpConnection.java:928)
      11. org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
      12. org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
      13. org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
      14. org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
      14 frames
    9. Jetty Util
      QueuedThreadPool$PoolThread.run
      1. org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
      1 frame