ChartObject.CopyTo(Worksheet) Method

Creates a copy of the chart in another worksheet.

Namespace : DevExpress.Spreadsheet.Charts

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

C#
VB.NET

csharp

Chart CopyTo(
    Worksheet worksheet
)

Function CopyTo(
    worksheet As Worksheet
) As Chart

Parameters

Name	Type	Description
worksheet	Worksheet

A Worksheet object that is the destination worksheet for copying a chart.

Returns

Type	Description
Chart

A newly created Chart or null ( Nothing in Visual Basic), if the chart cannot be copied.

Remarks

A chart cannot be copied to the same worksheet using the CopyTo method.

You can copy a chart to a worksheet in another workbook if the source and destination worksheets have different internal IDs (defined in OpenXML standard as sheetId element).

All cell references used to specify chart data, labels etc. are copied unchanged. If a cell reference is invalid in a newly created chart (e.g., if a destination workbook does not contain a worksheet with the name used in a reference), an exception is thrown.