Spread ASP.NET 6.0 Product Documentation
AutoFilterIndex Property
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > ColumnHeader Class : AutoFilterIndex Property


Glossary Item Box

Gets or sets which column header row displays the row filter indicator when there are multiple column header rows.

Syntax

Visual Basic (Declaration) 
Public Property AutoFilterIndex As Integer
Visual Basic (Usage)Copy Code
Dim instance As ColumnHeader
Dim value As Integer
 
instance.AutoFilterIndex = value
 
value = instance.AutoFilterIndex
C# 
public int AutoFilterIndex {get; set;}

Property Value

Integer number representing the zero-based row index

Remarks

If your header has multiple column header rows, you can specify which row displays the filtering indicator by setting this property. To specify the index, set the property to a value between 0 and n-1, where 0 is the top row and n is the number of header rows. Any value above n-1 simply puts the filtering indicator in the bottom row.

If you set this property to specify a row to display the filtering indicator, for example, header row 3, and then later change the number of column header rows to be less than 3, the filtering indicator is displayed in the bottom row, as if the RowCount property is set to -1. However, if you then change the number of header rows to 3 or greater, the ;filtering indicator is again displayed in header row 3. Use the RowCount property  to specify how many column header rows the component displays.

This property does not have an effect unless the Visible property (or the SheetView ColumnHeaderVisible property) is set to true and the column header rows are not hidden.

Example

This examples shows the use of the property to select the second row down from the top (the top being zero).
C#Copy Code
 FpSpread1.ActiveSheetView.ColumnHeader.AutoFilterIndex = 1;
Visual BasicCopy Code
 FpSpread1.ActiveSheetView.ColumnHeader.AutoFilterIndex = 1

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.