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 |