I have a designer file with two worksheets. The second worksheet (worksheet(1))contains data for several charts. This worksheet is hidden from the user. I would like to have the charts on this worksheet and at runtime copy them to worksheet(0). In one case I would move two of the charts, in the other only one.
Before I spend a lot of time trying to figure this out, can this be done with the MemberwiseClone Method?
Now you can only use Worksheets.AddCopy method to copy a worksheet, including all charts in it. Aspose.Excel doesn’t support to copy a specific chart in the designer file.