Resize headless table without corrupting tables surrounding it

Aspose.Cells Product Family
1

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.

2

@dzmitry.martynau

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
3

@dzmitry.martynau

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.

4

@dzmitry.martynau,

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

Let us know your feedback.

5

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: Install Aspose Cells through NuGet|Documentation