GetColumnAllowFilter Method

Gets whether this column contains a column filter definition.

Syntax

Visual Basic
C#

'Declaration
 
Public Function GetColumnAllowFilter( _
   ByVal column As Integer _
) As Boolean

'Usage
 
Dim instance As SheetView
Dim column As Integer
Dim value As Boolean
 
value = instance.GetColumnAllowFilter(column)

public bool GetColumnAllowFilter( 
   int column
)

Parameters

column: Column index

Return Value

Boolean: true if the specified column allows filtering; false otherwise

Remarks

The default is for a column not to allow filtering. Use this method to allow the user to perform filtering of rows by clicking on the filter indicator in a column header.

Example

This example returns the column number.

fpSpread1.ActiveSheet.Columns[2].AllowAutoFilter = true;
fpSpread1.ActiveSheet.AutoFilterColumn(2, "London", 1);

private void button1_Click(object sender, System.EventArgs e)
{
bool b = fpSpread1.ActiveSheet.GetColumnAllowFilter(2);
MessageBox.Show("The column can be filtered is " + b.ToString()); 
}

Visual Basic

FpSpread1.ActiveSheet.Columns(2).AllowAutoFilter = True
FpSpread1.ActiveSheet.AutoFilterColumn(2, "London", 1)

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim b As Boolean = FpSpread1.ActiveSheet.GetColumnAllowFilter(2)
MessageBox.Show("The column can be filtered is " & b.ToString())
End Sub

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

SheetView Class
SheetView Members

User-Task Documentation

Managing Filtering of Rows