0

ZK Spreadsheet on export throws org.apache.xmlbeans.impl.values.XmlValueDisconnectedException!

asked 2012-04-29 10:55:09 +0800

isah gravatar image isah
42 1

updated 2012-04-29 10:55:36 +0800

Hi guys. I'm exporting a spreadsheet to

ByteArrayOutputStream 
through:
 Exporter c = Exporters.getExporter("excel");
ByteArrayOutputStream baos = new ByteArrayOutputStream();
c.export(spreadsheet.getBook(), baos);
ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());

It exports fine but if I add dynamic rows to spreadsheet such as

Ranges.range(spreadsheet.getSelectedSheet(), 10, 1).insert(Range.SHIFT_UP, Range.FORMAT_LEFTABOVE);

it sometimes(not always!!!!!) throws:
org.apache.xmlbeans.impl.values.XmlValueDisconnectedException
>>	at org.apache.xmlbeans.impl.values.XmlObjectBase.check_orphaned(XmlObjectBase.java:1213)
>>	at org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTCellImpl.getR(Unknown Source)
>>	at org.zkoss.poi.xssf.usermodel.XSSFRow.onDocumentWrite(XSSFRow.java:460)
>>	at org.zkoss.poi.xssf.usermodel.XSSFSheet.write(XSSFSheet.java:2725)
>>	at org.zkoss.poi.xssf.usermodel.XSSFSheet.commit(XSSFSheet.java:2694)
>>	at org.zkoss.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:313)
>>	at org.zkoss.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:317)
>>	at org.zkoss.poi.POIXMLDocument.write(POIXMLDocument.java:173)
>>	at org.zkoss.zss.model.impl.ExcelExporter.export(ExcelExporter.java:36)
>>	at com.pespa.ctrl.OfferItemsCtrl.onClick$btnPrint(OfferItemsCtrl.java:62)
>>	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>	at java.lang.reflect.Method.invoke(Method.java:597)
>>	at org.zkoss.zk.ui.event.GenericEventListener.onEvent(GenericEventListener.java:82)
>>	at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2741)
>>	at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2712)
>>	at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2653)
>>	at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
>>	at org.zkoss.zk.ui.event.Events.sendEvent(Events.java:308)
>>	at org.zkoss.zk.ui.event.Events.sendEvent(Events.java:331)
>>	at org.zkoss.zk.ui.AbstractComponent$ForwardListener.onEvent(AbstractComponent.java:3179)
>>	at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2741)
>>	at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2712)
>>	at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2653)
>>	at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
>>	at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1699)
>>	at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1484)
>>	at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1201)
>>	at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:558)
>>	at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:456)
>>	at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:464)
>>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
>>	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
>>	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
>>	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
>>	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
>>	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
>>	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)
>>	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
>>	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
>>	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
>>	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>>	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:394)
>>	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
>>	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
>>	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:166)
>>	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
>>	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>>	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>>	at java.lang.Thread.run(Thread.java:662)


What's wrong? I couldn't figure out for days! Help kindly appreciated.

delete flag offensive retag edit

1 Reply

Sort by ยป oldest newest

answered 2012-04-30 03:56:29 +0800

samchuang gravatar image samchuang
4084 4

hi, which version do you use, could you provide sample code and xlsx file for test ?

link publish delete flag offensive edit
Your reply
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools

Follow
3 followers

RSS

Stats

Asked: 2012-04-29 10:55:09 +0800

Seen: 281 times

Last updated: Apr 30 '12

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More