Moving the array results in an unopenable file that crashes excel on startup

Aspose.Cells Product Family
1

Hi. One more case that seems to fail - arrays.


In input.xlsx, the reference in the array doesn’t update when the referenced cells are moved.
In input2.xlsx, moving the array results in an unopenable file that crashes excel on startup - see output.xlsx.
2

Hi,


Thanks for your posting and using Aspose.Cells.

Please share your sample code which generated your output excel file so that we could replicate this issue at our end and log it in our database for a fix.


3
The same code I posted regarding the other issues with Range.MoveTo:
Workbook workbook = new Workbook("input2.xlsx");
Range blockRange = workbook.Worksheets.GetRangeByName("range");
blockRange.MoveTo(15, 1);
workbook.Save("output.xlsx");
4

Hi,


Thanks for your posting and using Aspose.Cells.

We were able to observe both of your issues and logged them in our database for a fix. Once, there is some fix for you, we will let you know asap.

These issues have been logged as

  • CELLSNET-45214 - Reference in the array does not update when the referenced cells are moved in Input.xlsx
  • CELLSNET-45215 - Moving the array in Input2.xlsx results in an unopenable file that crashes excel on startup

C#
String fileName = “input.xlsx”;
//fileName = “input2.xlsx”;

Workbook workbook = new Workbook(fileName);
Range blockRange = workbook.Worksheets.GetRangeByName(“range”);
blockRange.MoveTo(15, 1);
workbook.Save(“out_” + fileName);

5
Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issues CELLSNET-45214 and CELLSNET-45215 now. We will soon provide the fix after performing QA and including other enhancements and fixes.
6
Hi,

Thanks for using Aspose.Cells.

Please download and try the following latest fix

Aspose.Cells for .NET v17.03.1 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v17.03.1 (.NET 4.0) compiled in .NET Framework 4.0.

and let us know your feedback.
7

The issues you have found earlier (filed as CELLSNET-45215;CELLSNET-45214) have been fixed in Aspose.Cells for .NET 17.4.0.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.