I get some problems when using worksheets.addcopy. Sometimes formula's complete get messed up. I attached my input and output file.
As you see on sheet 'demo' the formula in Cell C23 ( and others ) gets corrupted. And the formula from A7 get removed. In my project also the formula's in cells A5 and A6 ( and A7) completely get corrupted but I can't reproduce it in my testproject. In my project sheets get copied,moved and /or deleted. Maybe that makes the problem worse, but it has no effect in the testproject.
Code : ( VB.Net on Asp.net 2.0 )
Dim sFile As String
Dim cXl As Aspose.Cells.Excel
Dim iIndexNew As Integer
Dim iSIndexOrig As Integer
cXl = New Aspose.Cells.Excel
sFile = Me.Server.MapPath("Test3.xlt")
sFile = Me.Server.MapPath("TestOut.xls")
iSIndexOrig = cXl.Worksheets("No Segments").Index
iIndexNew = cXl.Worksheets.AddCopy(iSIndexOrig)
cXl.Worksheets(iIndexNew).Name = "Demo"
In the original sheet there is no problem, only in the copy.
I'm using version 126.96.36.199