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

Free Support Forum - aspose.com

Copying formulas from another sheet

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 : =I3
10000, =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:
http://docs.aspose.com/display/cellsnet/Setting+Shared+Formula

Thank you.