java.lang.IllegalStateException: Master cell of a shared formula with sid=0 was not found

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

    h3. Reproducing Steps # load attached file, shared-formula.xlsx, with zssapp # delete the cell C3 # save the file # open it again *Expected:* The file is open correctly. *Actual:* IllegalStateException is thrown. {quote} java.lang.IllegalStateException: Master cell of a shared formula with sid=0 was not found at org.zkoss.poi.xssf.usermodel.XSSFCell.convertSharedFormula(XSSFCell.java:386) at org.zkoss.poi.xssf.usermodel.XSSFCell.getCellFormula(XSSFCell.java:370) at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:518) at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1073) 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:3232) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3086) at org.zkoss.zss.ui.Spreadsheet.createActiveRange(Spreadsheet.java:1690) at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1650) at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1807) at org.zkoss.zk.ui.impl.UiVisualizer.redraw(UiVisualizer.java:978) at org.zkoss.zk.ui.impl.UiVisualizer.getResponses(UiVisualizer.java:675) at org.zkoss.zk.ui.impl.UiEngineImpl.getResponses(UiEngineImpl.java:1420) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1232) 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:755) at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:686) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:370) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489) at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:960) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1021) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:668) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:662) {quote} h3. Extra: shared-formula-error.xlsx is the file contains the error. (shared formula is deleted)

    ZK-Tracker | 3 years ago | hawk
    java.lang.IllegalStateException: Master cell of a shared formula with sid=0 was not found
  2. 0

    h3. Reproducing Steps # load attached file, shared-formula.xlsx, with zssapp # delete the cell C3 # save the file # open it again *Expected:* The file is open correctly. *Actual:* IllegalStateException is thrown. {quote} java.lang.IllegalStateException: Master cell of a shared formula with sid=0 was not found at org.zkoss.poi.xssf.usermodel.XSSFCell.convertSharedFormula(XSSFCell.java:386) at org.zkoss.poi.xssf.usermodel.XSSFCell.getCellFormula(XSSFCell.java:370) at org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:518) at org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1073) 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:3232) at org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3086) at org.zkoss.zss.ui.Spreadsheet.createActiveRange(Spreadsheet.java:1690) at org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1650) at org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1807) at org.zkoss.zk.ui.impl.UiVisualizer.redraw(UiVisualizer.java:978) at org.zkoss.zk.ui.impl.UiVisualizer.getResponses(UiVisualizer.java:675) at org.zkoss.zk.ui.impl.UiEngineImpl.getResponses(UiEngineImpl.java:1420) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1232) 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:755) at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:686) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:370) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489) at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:960) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1021) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:668) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) at java.lang.Thread.run(Thread.java:662) {quote} h3. Extra: shared-formula-error.xlsx is the file contains the error. (shared formula is deleted)

    ZK-Tracker | 3 years ago | hawk
    java.lang.IllegalStateException: Master cell of a shared formula with sid=0 was not found
  3. 0

    [PATCH] Exception occurs while try getErrorCellString() from XSSFCell

    Apache Bugzilla | 7 years ago | Petr.Udalau
    java.lang.IllegalStateException: Cannot get a error value from a formula cell
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    POI: setCellType(Cell.CELL_TYPE_FORMULA) fails beacause of Cell.CELL_TYPE_ERROR

    Stack Overflow | 2 years ago | Victor
    java.lang.IllegalStateException: Cannot get a numeric value from a error formula cell
  6. 0

    user-poi.apache.org - Re: please help with java.lang.VerifyError - msg#00129 - Recent Discussion OSDir.com

    osdir.com | 5 months ago
    java.lang.IllegalStateException: Cannot get a text value from a numeric formula cell

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

      Master cell of a shared formula with sid=0 was not found

      at org.zkoss.poi.xssf.usermodel.XSSFCell.convertSharedFormula()
    2. org.zkoss.poi
      XSSFCell.getCellFormula
      1. org.zkoss.poi.xssf.usermodel.XSSFCell.convertSharedFormula(XSSFCell.java:386)
      2. org.zkoss.poi.xssf.usermodel.XSSFCell.getCellFormula(XSSFCell.java:370)
      2 frames
    3. org.zkoss.zss
      Spreadsheet.renderProperties
      1. org.zkoss.zss.model.sys.impl.BookHelper.evaluate(BookHelper.java:518)
      2. org.zkoss.zss.model.sys.impl.BookHelper.getFormatText(BookHelper.java:1073)
      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:3232)
      6. org.zkoss.zss.ui.Spreadsheet$ExtraCtrl.getRangeAttrs(Spreadsheet.java:3086)
      7. org.zkoss.zss.ui.Spreadsheet.createActiveRange(Spreadsheet.java:1690)
      8. org.zkoss.zss.ui.Spreadsheet.renderProperties(Spreadsheet.java:1650)
      8 frames
    4. ZK Kernel
      DHtmlUpdateServlet.doPost
      1. org.zkoss.zk.ui.AbstractComponent.redraw(AbstractComponent.java:1807)
      2. org.zkoss.zk.ui.impl.UiVisualizer.redraw(UiVisualizer.java:978)
      3. org.zkoss.zk.ui.impl.UiVisualizer.getResponses(UiVisualizer.java:675)
      4. org.zkoss.zk.ui.impl.UiEngineImpl.getResponses(UiEngineImpl.java:1420)
      5. org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1232)
      6. org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:601)
      7. org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:483)
      8. org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:492)
      8 frames
    5. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
      2 frames
    6. Jetty
      AsyncHttpConnection.handle
      1. org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:686)
      2. org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501)
      3. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
      4. org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557)
      5. org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
      6. org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086)
      7. org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428)
      8. org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
      9. org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020)
      10. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
      11. org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
      12. org.eclipse.jetty.server.Server.handle(Server.java:370)
      13. org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)
      14. org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:960)
      15. org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1021)
      16. org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865)
      17. org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
      18. org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
      18 frames
    7. GWT dev
      SelectChannelEndPoint$1.run
      1. org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:668)
      2. org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
      2 frames
    8. Jetty
      QueuedThreadPool$3.run
      1. org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
      2. org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
      2 frames
    9. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame