Bug 63901 - Method XSSFDrawing.importChart(XSSFChart srcChart) throws XmlValueDisconnectedException
Summary: Method XSSFDrawing.importChart(XSSFChart srcChart) throws XmlValueDisconnecte...
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 4.1.1-FINAL
Hardware: PC Linux
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-11-03 19:58 UTC by Martin
Modified: 2021-02-01 00:47 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
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