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

Free Support Forum - aspose.com

When copying cell containing an array formula ABOVE the original row results in a corrupt Excel file

When Celll J10 contains an array formula and you try to copy it ABOVE the original row, Aspose creates a corrupt Excel file.

Cells cells = workbook.getWorksheets().get("Shearwater").getCells();

//Copy row above original row, makes Aspose create corrupt excel file

cells.copyRow(cells, 9, 8);

cells.copyRow(cells, 9, 10);

Code for reproducing, input spreadsheet and result spreadsheet attached.

Aspose version


Thanks for your posting and using Aspose.Cells for Java.

We were able to replicate this issue using your source file and sample code. The generated file is corrupt. We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSJAVA-40584.

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

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