Hi,
We have a worksheet with 2 pie charts that is being copied from one workbook to another and it does not accurately preserve the location or lines of the chart labels.
I have attached a zip file with the source file and a sample of the output in “incorrect_pie_chart.xlsx”.
The 3rd worksheet in the source file named “Regional Exposure” is where the 2 pie charts live. If you compare what’s in the source file to the “incorrect_pie_chart” file, you can see the labels have been misaligned and overlap one another.
The following code will copy that sheet to a new workbook and reproduce the issue:
Workbook wbSource = new Workbook(“C:\WIP\source.xlsx”);
Workbook wbDest = new Workbook();
Worksheet destinationWorksheet = wbDest.getWorksheets().get(0);
destinationWorksheet.copy(wbSource.getWorksheets().get(“Regional Exposure”));
wbDest.save(“C:\WIP\incorrect_pie_chart.xlsx”);