We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

While Importing how to check spreadsheet is filtered

Thread ID:

Created:

Updated:

Platform:

Replies:

31289 Jul 5,2005 08:54 AM UTC Jul 13,2005 08:42 PM UTC WinForms 1
loading
Tags: XlsIO
Administrator [Syncfusion]
Asked On July 5, 2005 08:54 AM UTC

Hi, I am opening an excel file, I want to check whether there is a filter on the worksheet? I tried using IWorksheet.AutoFilters.Count but the problem with it is that once all the filter is removed from the sheet, it still gives count greater than zero. Is there any other way to find out if the sheet is filtered? MTK

Administrator [Syncfusion]
Replied On July 13, 2005 08:42 PM UTC

Hi, This has been identified as a bug . You can track the live status of this issue here http://www.syncfusion.com/support/issues/excelrw/Default.aspx?ToDo=view&questId=482 We will try to address this issue as soon as possible. Thanks, Stephen. >Hi, > > I am opening an excel file, I want to check whether there is a filter on the worksheet? >I tried using >IWorksheet.AutoFilters.Count but the problem with it is that once all the filter is removed from the sheet, it still gives count greater than zero. >Is there any other way to find out if the sheet is filtered? > >MTK

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;