Archive for April, 2010

Another Cool Golf Feature

April 1, 2010

So i didn’t spring for the tracking Xenon Headlights package on my 2010 Golf.   Maybe the Xenon package doesn’t even track when you turn in the US… I don’t really know since it didn’t come on my Golf.    In any case, even without that package… when turning the steering wheel at slow speeds, with headlights on, the Golf actually turns on the Fog lamp on the side of the car where you’re turning towards to increase illumination.

It then fades the foglight out again once the wheel reaches nadir again.     Nice touch.

I finally parked behind a car with the correct reflectivity to confirm the behavior.    Not sure yet how I’ll get a picture to add to the post.

Advertisements

Excel Cell Double Click Shenanigans

April 1, 2010

For some inane reason last fall, I bought the latest version of Microsoft Office for OS X.   (2008 is it? )    Anyways, I was disappointed by iWork’s flakiness in Numbers (Apple’s spreadsheet) and Pages (import from Word is lossy), so I thought I’d pony up and buy the office “standard” used world round.

Now it’s like I’m back in 1990 running the spreadsheet on the Mac SE.    Seriously.    It feels like all UI development stopped on Excel decades ago.    The interluding years have been devoted to developing lots of features I don’t need, and window dressing it up to make it look like maybe it was updated for Aqua circa 2001.

I don’t think any convincing thought has gone into this program since the development of the laptop trackpad. Case and point: the most annoying thing in Excel seems to be that double clicking on a cell to edit it half the time scrolls the spreadsheet unpredictably.     After a few weeks of annoyance, and many unsuccessful searches on the web, I finally intuited the Google search terms to find others griping about the issue, and then a comment on the post with the fix.
That post is here:  Betalogue

Thanks the images and the fix in the comments…    (can’t get the cursor in the mac screen shots anymore.)

Contrary to my whining so far this post is more about the fix than the gripe.

HONEST.      So the thing I didn’t notice initially was that that is that the cursor changes from the Excel “+” cursor to the Excel “Hand Cursor” immediately before the offending scroll to the bottom of my thousand row spreadsheet.

Archaic Excel Plus Cursor

Archaic Hand Cursor
Aside from the fact that the Cursors are the exact bitmaps from 1990, the main problem here is that you get about 5 pixels in the middle which can be used to double click the cell.     Double clicking on the Macbook trackpad invariably skips to the bottom of the column, because the act of clicking moves the pointer enough to cause the cursor to change.
So to fix:
Excel->Preferences
Search on “Drag”  this will highlight the “Edit” tab
Uncheck “Enable fill handle and cell drag and drop”  (OBVIOUS! NOT!)

The Offending Setting

Now it’s nearly usable again.

Now If I could just make =a+b realize I’m trying to do math without having to set the column format to number, then edit and click return again.