We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Datatable doesn't shift down

Hi. Found an issue where inserting a range above a datatable causes odd behaviour where the datatable doesn't shift down with the rest of the cells.

Workbook workbook = new Workbook("input4.xlsx");
CellArea ca = new CellArea();
ca.StartRow = 0;
ca.EndRow = 2;
ca.StartColumn = 0;
ca.EndColumn = 2;

workbook.Worksheets[0].Cells.InsertRange(ca, ShiftType.Down);


Hi Piers,

Thank you for contacting support. We managed to replicate the problem of improper shifting of the Datatable. It has been logged under ticket ID CELLSNET-45237 in our bug tracking system. Your post has also been linked to this ticket. We shall keep you informed regarding any available updates. We are sorry for the inconvenience caused.

Hi Piers,

In reference to the ticket ID CELLSNET-45237, our product team has resolved this bug. If there is no issue in the QA phase, then this fix will be included in the next version 17.4.0 of Aspose.Cells for .NET API. We shall notify you via this forum thread as soon as the new release is published.


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

Aspose.Cells for .NET v17.3.3 (.NET 2.0)
Aspose.Cells for .NET v17.3.3 (.NET 4.0)
(Note: please choose any of the fixes for your underlying .NET framework version)

Your issue should be fixed in it.

Let us know your feedback.

Thank you.

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

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