SpreadsheetGear 2017
AutoFilterMode Property (IWorksheet)






SpreadsheetGear Namespace > IWorksheet Interface : AutoFilterMode Property
Gets or sets the property which specifies whether this worksheet is in autofilter mode.
Syntax
'Declaration
 

Property AutoFilterMode As System.Boolean
'Usage
 

Dim instance As IWorksheet
Dim value As System.Boolean
 
instance.AutoFilterMode = value
 
value = instance.AutoFilterMode
System.bool AutoFilterMode {get; set;}
read-write property AutoFilterMode: System.Boolean; 
function get,set AutoFilterMode : System.boolean
__property System.bool get_AutoFilterMode();
__property void set_AutoFilterMode( 
   System.bool value
);
property System.bool AutoFilterMode {
   System.bool get();
   void set (    System.bool value);
}
Remarks

Set this property to false to clear autofilters associated with this worksheet.

Use IRange.AutoFilter to enable autofilter mode for this worksheet.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

IWorksheet Interface
IWorksheet Members
AutoFilter Method
AutoFilter Property

 

 

See our live ASP.NET Excel Reporting, Excel Charting, Dashboards from Charts and Ranges, Excel Calculation and Excel to DataGrid Samples.

Copyright © 2003-2020 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear® is a registered trademark and Spreadsheet Gear is a trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel, Visual Studio and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Send Feedback