Monday, October 19, 2009

Excel AutoFilter status bar displays "Filter Mode" instead of Filtered Count

I work with quite a few spreadsheets and couldn't figure out why autofiltered data would not consistently show filtered count, instead showing "Filter Mode".

Lo & Behold there's a knowledgebase article for this issue (2 actually).

For Excel 5.0, 95, 97

For Excel 97, 2000, 2002, 2003

Soooo the problem has existed for a really long time, with no Real solution.

Workaround (from 2nd kb article) is as follows:

To temporarily work around this problem, prevent the formulas from calculating when you run a filter. To do this, follow these steps:

1. On the Tools menu, click Options.
2. In the Options dialog box, click the Calculation tab.
3. On the Calculation tab, click Manual under Calculation.
4. Filter the list to see the filter results in the status bar.

To restore calculation, on the Tools menu, click Options. Click the Calculation tab, and then click Automatic under Calculation.


Labels: , ,

Monday, August 24, 2009

Tech Support Self Service Email

I originally sent as an email, ergo, last line.
Check out for more simply brillant, math/tech based hilarity.


In the unlikely even you do not find this Helpful AND/OR Hilarious
(which means you fail at computers & humor), please see form below....


Addendum: Notice how you only see my name on this email? It's called BCC. Use It! ;p

Labels: ,

Friday, June 12, 2009

Can I post again yet?

Just wondering


Thursday, October 23, 2008

Jazz w/ a GeneraL Problem

Tuesday, July 15, 2008

Diablo III

Yeah, I'm a bit late on this. I've been busy >p

Labels: , ,

Wednesday, March 12, 2008

Damned if you Do Damned if you Don't

Wasting hours on a non-problem is frustrating to say the least.
Such is the case of not knowing about the CancelSelectOnNullParameter property of the ASP.NET 2.0 SqlDataSource control.

There was a time when if I wanted use a language / IDE I'd study a couple manuals cover to cover and Then dive in. While this was time and energy consuming, there was nothing like understanding your tools in their entirety to really solve problems in the most efficient manner. Well, I've gotten older and have a lot less time. My current method of solution discovery is trial and error. While frustrating & rewarding, it saves time in that I'm focused on the areas I believe I need to be in. I've used the SqlDataSource, GridView, FormView and most recently Telerik RadGrid Many times and never ran into a situation where the CancelSelectOnNullParameter was relevant. Now 2+ hours after I should have been on to the next section of the project I'm finally able to adequately test the BASICS of Data Access. I swear I thought I was losing it when the data grid wasn't showing up on a tested and working SqlDataSource. Why does the test work differently than the actual implementation?!?! No more bitching, but a HUGE thanks to ecbruck from the ASP.NET forums.

I'd post a thank you there, but they have the Most RETARDED (that is a medical and technical term not to be confused with salnder again the mentally challenged) non-passport login system! I forgot my password. Send me a link to a page to reset it, except I'm Denied Access to the reset page. WTF!!?!!? Ok. Now, no more bitching... for now.

So, in summary:

If your Gridview, RadGrid, DataReader, etc is not returning data when you KNOW it should be and its DataSource is a SqlDataSource (or AccessDataSource) and there are parameters with no value (null) being passed to it, it's probably because the CancelSelectOnNullParameter property is set to True (the default). Set to false and let the data flow again. I'm so frustrated right now.

Labels: , , , ,

Thursday, February 14, 2008

I LOVE O'Reilly Safari Video

Another year and I Still Love my virtual bookshelf. In addition to adding publishers,
they've added Video! Currently over 600 hours.

It's gotten to the point where It's not about available content, but managing the available content. With over 300 books in my favorites (at this point I think of them as marked for perusal) it's getting a bit more difficult to even open existing favs before a whole new set is coming down the pipe. Mmmmm, Information Overload (*Homeresque Gargle...*)

I still can't help but recommend this service (can't just call it a site) to anyone that consumes technical books and has an internet connection. For those that prefer real books for the type and layout, there's now an option on many title for reading in print fidelity.

I'm still not a fan of the token system. I use them because I have them, but have no real interest in creating a collection of random chapters. However, this feature is completely obscured by the overall awesomeness of the service.

Labels: , ,