We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Copying a sheet into new sheet . With formula's

Thread ID:





128356 Jan 16,2017 08:26 PM UTC Jan 18,2017 11:42 AM UTC ASP.NET Web Forms 3
Tags: XlsIO
Todd J
Asked On January 16, 2017 08:26 PM UTC

Hello ,

I'm trying to copy a sheet into a new sheet using the  sheet.addcopy(sheetnumber). I'm getting everything but the formula fields are referring to cells in the source sheet not in the destination sheet . Is there a way to do this . We cannot do the range because we don't how range with the sheet has .  Below is the code i used to copying into new sheets 


i'm using VB.net 

Sridhar Sukumar [Syncfusion]
Replied On January 17, 2017 10:32 AM UTC

Hi Todd, 


Thank you for using Syncfusion products. 


We are unable to reproduce the issue from our side. We have shared a simple sample for your reference can be downloaded from following location. 


Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/AddCopy174158613.zip 


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


Please let us know if you have any concerns. 



Sridhar S. 

Todd J
Replied On January 17, 2017 02:40 PM UTC

Hello sridhar, 

I'm attaching the input file i'm using and i can reproduce the issue. I am attaching the code used with my input file When i ran the input file with code you gave me it produced the same issue. It is copying everything but the formula . I am also attaching the formula screenshots explaining the issue in  the output folder. 

Attachment: AddCopy174158613_(2)_c6f9f199.zip

Sridhar Sukumar [Syncfusion]
Replied On January 18, 2017 11:42 AM UTC

Hi Todd, 


We were able to reproduce the problem and have logged defect report regarding this. A support incident to track the status of this defect has been created under your account. Please log on to our support website to check for further updates 




Please let me know if you have any questions. 



Sridhar S. 



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon