Coping range from source to target workbook does not copy data properly

rasmi.mishra · January 2, 2023, 4:18am

Hi ,
I am trying to copy data from source workbook to target workbook by referring data via it’s name range, but target workbook looks not having data correctly . Here data are few charts refer by range name .Attached sample c# code , please correct me if code has to modify …CopyRange.zip (347.0 KB)

Thanks

Amjad_Sahi · January 2, 2023, 8:38am

@rasmi.mishra,

Sorry for the delay.

We are looking into your issue and get back to you soon.

Amjad_Sahi · January 2, 2023, 9:07am

@rasmi.mishra,

Thanks for the template file and details.

Please notice, I am able to reproduce the issue as you mentioned by using your sample file. I found by copying range from source to target workbook does not copy data/objects properly. I have logged a ticket with an id “CELLSNET-52501” for your issue. We will look into the details of your issue.

Once we have an update on it, we will let you know.

simon.zhao · January 3, 2023, 5:09am

@rasmi.mishra，
The range ‘E & D’!$B$71:$O$124 only contains some charts and the data referred by charts is out of the range. The data referred by charts are changed as external links when copying the range in MS Excel, but Aspose.Cells still refer to the same worksheet.
We will try to works as MS Excel later.