ListObject.Resize changes format and sets filter

Aspose.Cells Product Family
1

Hi,

the newest version 17.7.0.0 (including 17.7.2.0) changes format of cells and activates filter, when resizing a table (ListObject).
Does not occur with version 17.6.X.X.

Line 19 in attached file BeforeResize.xlsx is dark grey, and it has to be dark grey in AfterResize.xlsx, but it isn’t.

I’m using .Net 4.0.ResizeTable.zip (15.2 KB)

Here is the code to reproduce the mentioned phenomenon:

    private static void Test19_ResizeTable()
    {
        string srcFilePath = @"C:\temp\DataTest\AsposeTest\ResizeTable\BeforeResize.xlsx";
        string tgtFilePath = @"C:\temp\DataTest\AsposeTest\ResizeTable\AfterResize.xlsx";

        Workbook wbSource = new Workbook(srcFilePath);
        Worksheet sheet = wbSource.Worksheets["Test"];

        ListObject table = sheet.ListObjects[0];

        table.Resize(table.StartRow, table.StartColumn, sheet.Cells.MaxDataRow, sheet.Cells.MaxDataColumn, true);

        wbSource.Save(tgtFilePath);
    }
2

@sabrinaluedtke

We were able to observe this issue in newer versions. This issue does not occur with older versions.

We have logged this issue 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-45529.- ListObject.Resize changes format and sets filter
3

@sabrinaluedtke,

This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-45529”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

Keep in touch.

Thank you.

4

Thank you.

I’m on holiday the next 3 weeks, so there is no possibility to test your fix in this period of time.

5

@sabrinaluedtke,

No worries, we will attach the fix here in the next week or so and you may test your issue with the fix when you will come back from holidays.

happy holidays :slight_smile:

6

@sabrinaluedtke

Thanks for using Aspose APIs.

Please download and try the following fix and let us know your feedback.

7

The issues you have found earlier (filed as CELLSNET-45529) have been fixed in latest version of Aspose.Cells for .NET (Download | NuGet).

8

Hi,

New version works fine, thanks.

9

@sabrinaluedtke,

Good to know that your issue is sorted out by the new version/fix. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.