How to control AutoFilter positioning?

Aspose.Cells Product Family
1

Hi,

I have a sheet that I create an AutoFilter range on. The data and corresponding column headings start on A3 and ranges up to BW77.
I now assign AutoFilter.Range = “A3:BW77”, however the filter is located at A1, ie the filter drop down cells show up on row 1 and selections include column headings.

Any help would be appreciated

Regards

Kai Iske

2

Hi Kai,

Please try the latest hotfix.

It’s fixed.

3

Thanks Laurence, that did it

4

@Kai_Iske,
Aspose.Excel is discontinued and a new product Aspose.Cells is introduced which is much more advanced and rich in features. This new product supports multiple ways to implement data filtering as shown in the following example:

// Instantiating a Workbook object
// Opening the Excel file through the file stream
Workbook workbook = new Workbook(dataDir + "book1.xls");

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Creating AutoFilter by giving the cells range of the heading row
worksheet.AutoFilter.Range = "A1:B1";

// Saving the modified Excel file
workbook.Save(dataDir + "output.out.xls");

Following article provides more details along with examples for filtering data:
Data Filtering

You can download the latest version of this product here:
Aspose.Cells for .NET (Latest Version)

You can download a working solution here to test the features of this product.