Implement Autofilter in Excel2003 format after conversion from SpreadSheetML using Aspose.Cells for .NET (Framework 2.0) and C#

Aspose.Cells Product Family
1

Hi, I am trying to convert a SpreadSheetML document to Excel2003 format by saving the file using Excel2003 FileFormatType option. On conversion AutoFilter drop down does not respond. Hence unable to use autofilter functionality. Please help.

2

Hi,

Could you try our latest version: https://downloads.aspose.com/cells

If you still find the issue, kindly post your template spreadsheetml file here, we will check it soon.

Thank you.

3

Hi,

Am using Evaluation version of v 4.7.1. We specifically require autofilter option to be copied into converted Excel sheet.

Please find the SSML (SSMLBook.xml) and converted Excel (Excel2003Book.xls) attached. In sheet1 of Excel2003Book.xls, although the autofilter dropdown are visible they do not respond on clicking. Hence hence we can not filter data using these dropdowns.

The code am using is as follows,

Version .Net framework 2.0

Workbook wb = new Workbook();

wb.Open("SSMLBook.xml", FileFormatType.SpreadsheetML);

wb.Save("Excel2003Book.xls", FileFormatType.Excel2003);

Thanks,

Subhash

4

Hi Subhash,

Thanks for providing us the template files.

Well, if you select _FilterDatabase range in the name box, then it works. Anyways, we will look into it and get back to you soon.

Thank you.

5

Hi,

Please try the attached version, we have fixed the issue.

Thank you.

6

Thanks for the quick response. Autofilter is working fine in the version provided by you.

7

Hi,

We have a license for Aspose which we got for 4.6.0 version of Aspose Cells. But since this fix is available in 4.7.1.2, we are unable to use this DLL along with available license. Is it possible that we get this feature as a part of 4.6.0. Else please suggest the available options.

Thanks,

Subhash

8

Hi Subhash,

Well, I am afraid, you have to upgrade your subscription to use latest versions of Aspose.Cells for .NET. We cannot embed a feature to some older versions of Aspose.Cells for .NET, you have to use the new/latest version only.

Alternatively, if you are not in a position to upgrade at the moment and you are thinking that may be after some time you can upgrade your subscription, you may demand a 30 days temporary license this time and after its expiry, you can upgrade your subscription.

Thank you.