Moving range with formula issue

Aspose.Cells Product Family
1

In the input file the last cell in the range sums the other cells. After moving the range, the formula only refers to the first cell of the range.

input.zip (6.6 KB)

        Workbook workbook = new Workbook("input.xlsx");

        Range range = workbook.Worksheets.GetRangeByName("range");
        range.MoveTo(range.FirstRow+10, range.FirstColumn);

        workbook.Save("output.xlsx");
2

@valuepro,

Thanks for using Aspose APIs.

We were able to observe this issue as per your sample code and description. We have logged this issue in our database for investigation and for a fix. Once, the issue is resolved or we have some other news for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-45544 - While moving the range, the formula only refers to the first cell of the range
3

@valuepro

Thanks for using Aspose APIs.

This is to inform you that we have fixed your issue CELLSNET-45544 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

4

@valuepro,

Please try our latest version/fix: Aspose.Cells for .NET v17.7.5:

Your issue should be fixed in it.

Let us know your feedback.

Thank you.

5

The issues you have found earlier (filed as CELLSNET-45544) have been fixed in latest version of Aspose.Cells for .NET (Download | NuGet).