I am reporting 2 issues on sheet copy. Please see the attached solution to reproduce the problems.
- Chart data source incorrect
I have 2 workbooks with 1 sheet each. Both the source and target book’s sheet’s have multiple charts.
When I copy the sheet from the source book to the target book, one of the target sheet’s charts (Chart 3) has the data source change to one of the the source chart’s data source (Chart 8). Chart 8 also now appears blank and no longer has a data source reference.
image.png (7.5 KB)
Looking at the definedNames in the openxml definition, it appears that there are now duplicate xlChart definedNames.
image.png (435.5 KB)
- Secondary Axis on chart is multiplying percentages by 100 on Save.
image.png (3.9 KB)