How to copy a chart

[dfense]

Hello.

How can i copy a chart from one sheet to another?

Regards

[Jason.Tan]

Hello,

Thank you for your inquiry.
Please check post attachment for your reference.
Please let me know if you have any questions and concerns.

Best Regards

[dfense]

Hello.

I'm sorry, but this not want i wanted to do. I just want to copy a single chart from sheet1 to sheet2.

Regards

[Jason.Tan]

Hello,

Sorry for confused to you.
For copying a single chart from sheet1 to sheet2, please check attachment for new demostration.
Please let me know if you have any questions and concerns.

Best Regards

[dfense]

Hello Jason.

The code looks good, but i cant use it. I didnt have the option to pass a chart as a parameter to the charts.Add function. The only possible parameter for this function is the excel version.

I think the reason is that i use an old version of the spire.xls library. As per file version info, i use the 3.0.0.0 version.

Regards,
Steve

[blastdoman]

Hello,

Sorry for confused to you.
For copying a single chart from sheet1 to sheet2, please check attachment for new demostration.
Please let me know if you have any questions and concerns.

Best Regards

Good morning.
This example does not work with version 10.1.0 of FreeSpire.XLS. When you execute the

Code: Select all

srcChart.Clone(chartEmpty.Parent)

statement you get the following error: "Reference to object not set as an instance of an object"

Ideas?

A greeting

[rachel.lei]

Hi blastdoman,

Thanks for your post.
I did an initial test and did reproduce your issue. I have logged it in our bug tracking system with the ticket SPIREXLS-3023. We will let you know if there is any update. Sorry for the inconvenience caused.

Sincerely,
Rachel
E-iceblue support team

[rachel.lei]

Hello,

Hope you are doing well.
Glad to inform that we just released Spire.XLS Pack(Hotfix) Version:11.2.3 which fixed the issue SPIREXLS-3023, please download it from the following links and refer to the code below to test.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget link: https://www.nuget.org/packages/Spire.XLS/11.2.3

Code: Select all

            Workbook workbook = new Workbook();
            workbook.LoadFromFile("ChartSample1.xlsx");
            Chart srcChart = workbook.Worksheets[0].Charts[0];
            workbook.Worksheets[1].Charts.Add(srcChart.Clone(workbook.Worksheets[1]));
            workbook.SaveToFile("result.xlsx");

Sincerely,
Rachel
E-iceblue support team