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

ZK-Tracker | hawk | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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

    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