Bug 63901

Summary: Method XSSFDrawing.importChart(XSSFChart srcChart) throws XmlValueDisconnectedException
Product: POI Reporter: Martin <marcin.jendrasik>
Component: XSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 4.1.1-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Linux   

Description Martin 2019-11-03 19:58:06 UTC
Hi,
When I want import the srcChart to the new drawing. 
Method XSSFDrawing.importChart(XSSFChart srcChart) throws org.apache.xmlbeans.impl.values.XmlValueDisconnectedException. Maybe I do something wrong. This is my code snippet: 

Workbook workbook = new XSSFWorkbook(new File("/test.xlsx"));
Sheet sheet = workbook.getSheet("Arkusz1");
XSSFDrawing drawing = ((XSSFSheet)sheet).createDrawingPatriarch();

Workbook workbook2 = new XSSFWorkbook(new File("/test2.xlsx"));
Sheet sheet2 = workbook2.getSheet("Arkusz1");
XSSFDrawing drawing2 = ((XSSFSheet)sheet2).createDrawingPatriarch();

drawing
   .getCharts()
   .forEach(xssfChart -> {
          try {
               drawing2.importChart(xssfChart);
           } catch (IOException e) {
               e.printStackTrace();
          } catch (XmlException e) {
               e.printStackTrace();
      }
   });

This is very strange and I don't see any solution.
I read some about this exception and he is thrown when try to write more then one time the same workbook. These two lines generate exception.

destChart.getCTChartSpace().set(srcChart.getCTChartSpace().copy());
destChart.getCTChart().set(srcChart.getCTChart().copy());

When I do this on the same workbook I have the same result.

Did I do something wrong or this is a bug? This is my first post in ASF Bugzilla.
Thx
Comment 1 Dominik Stadler 2019-11-16 16:43:23 UTC
Can you attach the sample files as well so this can be reproduced by others?
Comment 2 Alain Fagot Bearez 2019-11-28 22:36:41 UTC
If I remember correctly the patch from [54470](https://bz.apache.org/bugzilla/show_bug.cgi?id=54470), that I merged last year, the code was intended to copy a chart from the same workbook.

Unfortunately, your other bug report (63902) points to some issue in that part also...
Comment 3 Alain Fagot Bearez 2021-02-01 00:47:47 UTC
Fixed by r1886087