Copy sheet changing text box colour

Aspose.Cells Product Family
1

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?
2

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.