autofilter

How can I auto filter a HTML selectlist?

I have a HTML select list with quite a few (1000+) names. I have a javascript in place which will select the first matching name if someone starts typing. This matching looks at the start of the item: var optionsLength = dropdownlist.options.length; for (var n=0; n < optionsLength; n++) { var optionText = dropdownlist.options[n...

Coding Text Filters in Excel 2007

I am trying to use code to filter a spreadsheet dynamically, based on the current date. I am storing the date I need to filter on as "CurrDay" and I'm attempting to recall that stored date back into my filter algorithm. It is not working and I need to figure out how to do this to finish up this code. Everytime I run the code it retu...

ASP.NET AJAX "as you type" functionality

Although this is FAQ i still couldn't find a suitable solution. I'd like to filter out a list (rendered with ListView control placed to UpdatePanel) as user types something in TextBox. This blog post describes exactly what i need - raise a postback after a specified number of characters added. But the implementation has a few minor drawb...

Excel Autofilter in VB.NET

In my application I'm exporting an Excel file by getting the layout of a HTML page. So, in my codebehind, I'm modifying the HTML layout and inserting itens on it like if it was a webpage. Doing it that way, I don't need to use any external library and, as the data I'm exporting is just a table, I don't need nothing complex to handle it. ...

How to make the Excel broken autofilter indicator go away?

Excel 2003 Working with a large sheet which is typically autofiltered. However when autofilter is turned off the indicators are still all there, they just don't work. Not sure whether some vba was run which may have caused this. Other workbooks behave correctly on the same machine, and this workbook behaves this way on other machines. ...

Reordering Excel Table Columns with Filters Intact

I am running into an issue with Excel 2007 via VSTO 3.0. In my project, I need to shuffle columns around occasionally. Normally, this works fine but I have recently found that an issue arises when the data is filtered and the fitlered data is non-contiguous. For example, using this data set: Ohio Eastern Kentucky Eastern Ill...

POI Auto Filter

How do I use Apache POI to pre-define an auto-filter region in an Excel 2007 document? A small code example or link would be nice. ...

Excel Re-Apply all Workbook AutoFilters on Workbook_Open

I'm looking to update all of the auto filters on the Workbook_Open event, but not really sure where to begin and wondering if there is something as easy as refreshing the Pivot Tables which I had done with the. ThisWorkbook.RefreshAll ...

Is there any Java-Excel library that supports AutoFilter in Excel?

Last time I checked, Apache POI did not support this feature. If you know any solution that does, either free or commercial, please suggest. ...