Hi, I have a C# software that's using the Spire.Xls nugets and in a specific case I want to create a copy of a sheet already present in the workbook and place it at the end of the same workbook, this worksheet contains some custom names for cells I need to update later on using the .Range[] method, when I use the AddCopy() method the new worksheet copy is created but the list of names inside is cleared, How can I duplicate a Worksheet object in the same Workbook transferring all the names as well?
For now I tried something like this:
Worksheet temp = workbook.Worksheets[j];
workbook.Worksheets.Add("CopySheetName");
workbook.Worksheets[workbook.Worksheets.Count() - 1 ].CopyFrom(temp);
And
workbook.Worksheets.AddCopy(temp, WorksheetCopyType.CopyAll);
And
workbook.Worksheets.Add("CopySheetName");
workbook.Worksheets[workbook.Worksheets.Count - 1].CopyFrom(workbook.Worksheets[j]);
But neither of these options copies the cell names in the new sheet, I'm using Spire.Xls 14.2.1