Spread Windows Forms 10.0 Product Documentation
GetColumnAllowFilter Method
Example 


Column index
Gets whether this column contains a column filter definition.
Syntax
'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()); 
}

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

See Also

Reference

SheetView Class
SheetView Members

User-Task Documentation

Managing Filtering of Rows

 

 


Copyright © GrapeCity, inc. All rights reserved.