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