Lost column sort after save

Aspose.Cells Product Family
1

Hi!

I have an excel file with a table and a sorted column. If I open and save with Aspose Cell, the column lost its sort. I attached the sample files (Andoc_s sheet -> andoc_t table -> column H).

Another question. :) How can I resize the andoc_t table without InsertRow and CopyRow, because that way corrupt the formulas (Andoc_s sheet -> andoc_t table -> column I,J,K... formulas) ?

I report an issue 5 months ago (ID = CELLSNET-22509). Can you give me any information about it?

Thx

Tom

2

Hi,

Thanks for considering Aspose.Cells.

I am afraid, your issue with id CELLSNET-22509 is still unresolved. Anyway, I have increased its priority.

3

Hi,

I was able to reproduce the sort problem with the latest Aspose.Cells
for .NET v5.3.2.6.

Please see the screenshot and output xlsx file. Also see the code below.

This issue has been logged as CELLSNET-26884.

C#


string filePath = @“F:\Downloads\sort_test.xlsx”;

Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(filePath);


wb.Save(filePath+".out.xlsx",SaveFormat.Xlsx);


Screenshot:
4

Hi,

We have fixed this issue. Please download Aspose.Cells for .NET v5.3.3.3.

5

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.