Corrupt Excel file when using AutoFilter based on named range

Laurence,

we found a problem with either a named range used for auto filtering or with our Workbook, I don’t know. When you execute the attached sample (a slightly modified Aspose.Cells sample) and click on “View”, you will notice (at least we do) that Excel 2000 is unable to open the Workbook properly. It gives us a couple of errors.

You must copy Northwind.mdb to the sample’s Database folder.

Thanks

Kai

Hi Kai,

I ran your project with v4.0.3 and it worked fine to open file in Excel2000. Please check the attached file.

Laurence, yes 4.0.3.0 does ist. We still were using 4.1.9.0 and will not slowly migrate to the latest release.

Thanks

Kai