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...
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...
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...
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. ...
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. ...
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...
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. ...
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 ...
Last time I checked, Apache POI did not support this feature. If you know any solution that does, either free or commercial, please suggest. ...