Syncfusion.XlsIO.Base CopyTo(IRange) Method not working as expected?

[Robert Pouleijn]

Hi,

In the below code fragment there are 3 columns inserted and the content of a precending column is copied to the inserted columns.

The problem is that the first inserted column never gets the copied content. Although the local addresses (in the debug output) of the target and source match exactly?! Any ideas?

var woningen = 3;

var column = 4;

worksheet.InsertColumn(column + 1, woningen - 1);

for (var i = 1; i < woningen; i++) {

Debug.WriteLine($"source {worksheet.Columns[column - 1].AddressLocal}");

Debug.WriteLine($"destination {worksheet.Columns[column + i - 1].AddressLocal}");

worksheet.Columns[column-1] .CopyTo(worksheet.Columns[column + i - 1], ExcelCopyRangeOptions.All);

}

[Mohan Chandran]

Hi Robert, 

  

Thank you for contacting Syncfusion support. 

  

We have tried in different possible scenarios to reproduce the issue but, we are unable to reproduce it. We have shared a simple sample which can be downloaded from the following location. 

  

Sample link: http://www.syncfusion.com/downloads/support/directtrac/134718/ze/CreateSpreadsheet1793309118  

  

Kindly modify the sample to reproduce the issue and share us the modified sample along with the issue reproducing input files (If there is any) which will be helpful for us to give you a prompt solution at the earliest.  

  

Regards, 

Mohan Chandran. 

[Robert Pouleijn]

Hi Mohan,

Thx for your time, see the attachment. Apparently there is something strange going on in the excel file....

grt

Attachment: Syncfusion_ae815882.zip

[Mohan Chandran]

Hi Robert, 

  

Thank you for contacting Syncfusion support. 

  

A support incident to track the status of this query has been created under your account. Please log on to our support website to check for further updates. 

  

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents  

  

Please let me know if you have any other queries. 

  

Regards, 

Mohan Chandran.