I've hit upon a problem with 3D cell references: if a worksheet within the 3D range is deleted the reference returns a #REF! error. This differs from the behaviour of Excel which allows worksheets to be added or removed if they are between the first and last worksheets of the reference. To see how Excel behaves:
- Open a new workbook with 4 worksheets.
- In cell A1 on Sheet1, enter the formula =SUM(Sheet2:Sheet4!A1)
- Delete Sheet3 - the formula will not be affected.
Unfortunately Aspose.Cells behaves differently. Opening the same 4-sheet workbook as above, with the same formula in Sheet1!A1, if Sheet3 is deleted using wb.Worksheets.RemoveAt("Sheet3"), the formula on Sheet1 becomes =SUM(#REF!) which is incorrect. This should only happen if the first or last worksheet of the range is deleted.
I would appreciate if you could look into this.
Many thanks, Glynn