Activate spreadsheet "auto-filter" in code

[Thys]

We are building a spreadsheet from values received from a database and would like to automatically enable the filter on that. We can execute the SetFilterRange command, but how can one select the used cell range in code before calling this command?

Any other solution would be appreciated, but essentially we just need the spreadsheet on its own to be displayed, but with filtering enabled on all used columns.

[Nikolay Demirev]

Hello Thys,

The following code snippet will set the filter range to the entire used cell range of the Worksheet:

this.radSpreadsheet.ActiveWorksheet.Filter.FilterRange = this.radSpreadsheet.ActiveWorksheet.UsedCellRange;

Regards,
Nikolay Demirev
Telerik by Progress