We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Copy sheet changing text box colour

I’m building a report from a template where the template is copied for each row returned from a sql query. This template has a textbox at the top which has some text in red but each time the sheet is copied it turns orange.


I’ve commented out all the other code so I know for certain the copy is the issue:

Dim copySheet As Worksheet = wb.Worksheets(0)
Dim sheet As Worksheet = wb.Worksheets(wb.Worksheets.Add())
sheet.Copy(copySheet)

Is there any way I could set the text box back to red after the sheet has been copied to bypass this issue?

Hi,


Thanks for providing us some details.

Could you try our latest version/fix: Aspose.Cells for .NET v8.3.0.4 if it makes any difference.

If you still find the issue, I am afraid, we need a console application (runnable) to reproduce the issue on our end. Kindly create a stand alone application using Aspose.Cells component only, please use dynamic dataset/data tables and remove any dependencies to other data sources (e.g SQL Server etc.) or any other component/APIs, zip the project and post us here, so we could evaluate your issue properly. Also attach the template Excel file(s). We will check it soon.

Thank you.