In Aspose.Cells Cut and Paset doesn't work the same way as in MS Excel

Aspose.Cells Product Family
1

In Excel the cut and paste move formulas and named ranges to the new target location.

But in Aspose.Cell, it is not moving the formula and Named ranges. See the code and sample xls file below. I am using the range.MoveTo method.

Workbook book = new Workbook();

book.Open(@"C:\temp\test.xls");

Worksheet sheet = book.Worksheets[0];

Range r1 = book.Worksheets.GetRangeByName("Start");

Range r2 = book.Worksheets.GetRangeByName("End");

Range r3 = book.Worksheets.GetRangeByName("NewStart");

Range r4 = sheet.Cells.CreateRange(r1.FirstRow, r1.FirstColumn, r2.FirstRow - r1.FirstRow + 1, r2.FirstColumn - r1.FirstColumn + 1);

r4.MoveTo(r3.FirstRow, r3.FirstColumn);

book.Save(@"C:\temp\test.xls");

2

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

I checked your issue with the attached latest version of Aspose.Cells and found the issue regarding the named ranges (formulas are working fine). Your issue has been registered in our internal issue tracking system with issue id: CELLSNET-15520. We will look into it and get back to you soon.

Thank You & Best Regards,

3

Hi,

We have fixed your issue, kindly try the attached version.

Thank you.

4

The issues you have found earlier (filed as 15520) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.
5

Thanks for the Quick response. Looks like the update fixed the issue.

6

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan