Spread Windows Forms 7.0 Product Documentation
GetFilteredColumnIndexes Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > DefaultRowFilter Class : GetFilteredColumnIndexes Method


Glossary Item Box

Gets an array of column indexes where row filters exist.

Syntax

Visual Basic (Declaration) 
Public Function GetFilteredColumnIndexes() As Integer()
Visual Basic (Usage)Copy Code
Dim instance As DefaultRowFilter
Dim value() As Integer
 
value = instance.GetFilteredColumnIndexes()
C# 
public int[] GetFilteredColumnIndexes()

Return Value

Integer array of column indexes

Example

This example returns an array of column indexes where row filters exist.
C#Copy Code
fpSpread1.ActiveSheet.Columns[0].AllowAutoFilter = true;

int[] i = fpSpread1.ActiveSheet.RowFilter.GetFilteredColumnIndexes;

MessageBox.Show("The number of columns filtered is " + i.Length.ToString());
Visual BasicCopy Code
FpSpread1.ActiveSheet.Columns(0).AllowAutoFilter = True
Dim i As Integer() = FpSpread1.ActiveSheet.RowFilter.GetFilteredColumnIndexes
MessageBox.Show("The number of columns filtered is " & i.Length.ToString())

Requirements

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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.