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 Basic | Copy 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