Converted from .xlsx with filters XML file can not be opened by Excel

Aspose.Cells Product Family
1

Hi,

We have an Excel file with configured in it filter by several columns.



We are converting this file to XML using SpreadsheetML format and then trying to open the result in Excel. Excel reports a problem and file can’t be opened.



While the converted from xslx file with filter by one column only is opened correctly.



Please find the source and converted files in attachment.



Valeriy

2
Hi,

Thanks for your posting and using Aspose.Cells.

Please download and try the following latest version

Aspose.Cells for .NET v17.4.5 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v17.4.5 (.NET 4.0) compiled in .NET Framework 4.0.

We do find issue in the output spreadsheet xml relating to auto filters (see the screenshot), but it is different than yours. Please check your issue with the recent version and let us know if you get the same issue, so that we log it in our database for a fix.

3

Hi,


Thanks for your posting and using Aspose.Cells.

We are working over your issue and logged it in our database for investigation and for a fix.

This issue has been logged as

  • CELLSNET-45341 - Converting Xls to SpreadsheetML having Filters Corrupts the Output File

4

Hi,


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

Once the fix is available for public use, we will share the Download link here.

Thank you.
5
Hi,

Thanks for using Aspose.Cells.

Please download and try the following latest fix

Aspose.Cells for .NET v17.4.6 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v17.4.6 (.NET 4.0) compiled in .NET Framework 4.0.

and let us know your feedback.
6

The issues you have found earlier (filed as CELLSNET-45341) have been fixed in Aspose.Cells for .NET 17.5.

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