Using Touch Support with Filtering

You can use touch gestures when filtering.

Use the ZoomFactor property to increase the size of the drop-down list. The AllowAutoFilter property must be true to allow filtering with touch gestures.

Note: If the user selects a column that contains sorting and filtering indicators, the resize gripper is displayed. The gripper has a higher priority than the filter list or sort operation. Set the HeaderIndicatorPositionAdjusting property to specify the distance between the sorting and filtering indicators and the right edge of the column so that the user can sort or filter the column while the gripper is displayed.

Using Code

The following example sets the AllowAutoFilter and ZoomFactor properties.

CS	Copy Code
fpSpread1.ActiveSheet.Columns[1].AllowAutoFilter = true; fpSpread1.ActiveSheet.ZoomFactor = 2;

VB	Copy Code
fpSpread1.ActiveSheet.Columns(1).AllowAutoFilter = True fpSpread1.ActiveSheet.ZoomFactor = 2