Hi,
I’m migrating some interop applications to Aspose.Cells.
I have a case, in which I’m doing something like this :
iColumnIndex = 13
oSourceRange = aFormatSheet.Cells.CreateRange(1, iColumnIndex, 1, iColumnIndex)
For i As Integer = 6 To 6 + iSourceRangeRowsCount - 2
oDestinationRange = aDstSheet.Cells.CreateRange(i, iColumnIndex, i, iColumnIndex)
oDestinationRange.Copy(oSourceRange, oPasteFormulasOptions)
Next
As you can see I’m copying formulas.
Those formulas are for example like this : =I210000
When I copy them, since there are no “$”, I expect those formulas to slide. And so become like this : =I310000, =I4*10000, …
But actually, they’re not sliding.
What am I missing ? what can I do to make them slide ?
Thank you
Hi,
Could you try to use Shared Formulas feature that Aspose.Cells for .NET provides for your case, see the document for your reference:
Thank you.