Formula's not updated correctly by CopyRow method

Hi,

We are using a trial version of Aspose.Cells to see if this product fits our needs. When implementing the Aspose.Cells component a difference with MS-Excel occured.

When a row is copied, formula's are not always updated correctly. After some more investigation I found out it fails when the formula points to another worksheet and the relative formula has negative indexes (ie. =Sheet2!R[-5]C[1])

Attached the result of 3 CopyRow actions (see Sheet2). The following code is used to copy those rows:

mWorksheet.Cells.CopyRow(mWorksheet.Cells, 0, 1)
mWorksheet.Cells.CopyRow(mWorksheet.Cells, 6, 7)
mWorksheet.Cells.CopyRow(mWorksheet.Cells, 10, 11)

Worksheet points to Sheet2 in the workbook. As can be seen in the result the first 2 rows are copied correctly, but the last row is not. The original formula (Cell A11 in Sheet2) = "=Sheet1!A3". The formula in the copied row = "Sheet1!A11".

This behaviour is seen only when copying formula's with a negative relative formula. As in this test: Original formula in A11 in Sheet 2: "=Sheet1!R[-8]C"; Copied formula: "=Sheet1!R[-1]C"

Can this bug be solved quickly or is there a work-around? This would be a showstopper for us to use Aspose.Cells when this cannot be resolved.

Thanks in advance,

Timo

Hi Timo,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. I tested your scenario with it and it works fine.

Thank You & Best Regards,

Thanks it works perfect!