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

Free Support Forum - aspose.com

Resize headless table without corrupting tables surrounding it

Please see the attached sample workbook: book1.zip (8.0 KB)

        var wb = new Workbook(GetFullPath("book1.xlsx"));
        var l = wb.Worksheets[0].ListObjects["Table1"];
        l.Resize(l.StartRow, l.StartColumn, l.EndRow + 1, l.EndColumn, false);
        wb.Save(GetFullPath("result.xlsx"), SaveFormat.Xlsx);

In the case of headless table (as Table1) ListObject.Resize inserts with shift down the range A2:B2 breaking the table below. What’s the alternative to ListObject.Resize? In other cases I insert a row using Cells.InsertRows, but it break the table on the right in this particular case.


Thanks for using Aspose APIs.

We were able to observe this issue and logged it 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-46131 - Resizing headless table corrupts the output Excel file


Thanks for using Aspose APIs.

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


Please try our latest hotfix/version: Aspose.Cells for .NET v18.5.1, it should fix your issue:

Let us know your feedback.

The issues you have found earlier (filed as CELLSNET-46131) have been fixed in Aspose.Cells for .NET 18.6. Please also check the document/article for your reference: https://docs.aspose.com/display/cellsnet/Installation