If you have multiple row headers then you can specify in which row to display the filter indicators. By default they appear in the bottom of the column header rows. You can specify which row with the AutoFilterIndex property of the ColumnHeader class.

Using Code

Here is an example of setting the AutoFilterIndex property in code.

Example

C#	Copy Code
fpSpread1.ActiveSheet.ColumnHeaderRowCount = 3; fpSpread1.ActiveSheet.ColumnHeader.AutoFilterIndex = 1;

VB	Copy Code
FpSpread1.ActiveSheet.ColumnHeaderRowCount = 3 FpSpread1.ActiveSheet.ColumnHeader.AutoFilterIndex = 1

Return to Setting the Appearance of Filter Indicators.