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

AutoFilter

Thread ID:

Created:

Updated:

Platform:

Replies:

34291 Sep 7,2005 11:03 AM Sep 13,2005 03:10 AM Windows Forms 4
loading
Tags: XlsIO
Brian N. Wright
Asked On September 7, 2005 11:03 AM

Hello Syncfusion''s great support team. How do I add an AutoFilter to my spreadsheet? I see that the IWorksheet has an AutoFilters collection but I do not see how to add to the collection. Thanks, Brian

Brian N. Wright
Replied On September 7, 2005 11:04 AM

I have ExcelRW Version 3.201.1.0

Administrator [Syncfusion]
Replied On September 12, 2005 09:09 AM

Hi Brian, I put together a sample based on your requirements. Please take a look at this sample and let me know if you have any questions. writeautofilters.zip Best Regards, Seetha. >I have ExcelRW Version 3.201.1.0

Brian N. Wright
Replied On September 12, 2005 11:51 AM

Thank you so much. This is great. Exactly what I needed. However, I do have one minor detail I was wondering about... Typically when you add an AutoFilter to an Excel spreadsheet, it shows the color of the drop down arrow on each filter cell as black. If you pick an item from the filter list then that particular drop down arrow will be colored blue. This makes it easy to tell which filters are actually being used. In this example, every filter cell is colored blue with no way to make them black. It is confusing as it looks as though every column is being filtered in some way when in fact it may or may not be. Is there anyway to fix this?

Administrator [Syncfusion]
Replied On September 13, 2005 03:10 AM

Hi Brian, I was able to see the issue and have filed a bug report with the development team. Defect #745 - AutoFilter Dropdown arrow color does not change. Thanks, Seetha >Thank you so much. This is great. Exactly what I needed. > >However, I do have one minor detail I was wondering about... > >Typically when you add an AutoFilter to an Excel spreadsheet, it shows the color of the drop down arrow on each filter cell as black. If you pick an item from the filter list then that particular drop down arrow will be colored blue. This makes it easy to tell which filters are actually being used. > >In this example, every filter cell is colored blue with no way to make them black. It is confusing as it looks as though every column is being filtered in some way when in fact it may or may not be. > >Is there anyway to fix this? > >

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

;