SetColumnAllowFilter(Int32,Int32,Boolean) Method

Sets whether the specified columns on this sheet allow filtering.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetColumnAllowFilter( _
   ByVal column As Integer, _
   ByVal count As Integer, _
   ByVal allowFilter As Boolean _
)

'Usage
 
Dim instance As SheetView
Dim column As Integer
Dim count As Integer
Dim allowFilter As Boolean
 
instance.SetColumnAllowFilter(column, count, allowFilter)

public void SetColumnAllowFilter( 
   int column,
   int count,
   bool allowFilter
)

Parameters

column: Column index of first column to set
count: Number of columns to set
allowFilter: Whether to allow filtering for the specified columns

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	Specified column index is out of range; must be between -1 and the total number of columns

Remarks

The default is for columns not to allow filtering.

Example

This example uses the SetColumnAllowFilter method.

fpSpread1.Sheets[0].SetColumnAllowFilter(0, 2, true);

Visual Basic

fpSpread1.Sheets(0).SetColumnAllowFilter(0, 2, True)

Reference

SheetView Class
SheetView Members
Overload List