Archive for the ‘General’ Category

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:
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.


Blog Post One!

June 22, 2009

Having had a blog on his business card for the past year, he finally decided it was time to put something at the link.  Initially most the iPhone SDK stuff was all under NDA.   This restriction has eased somewhat, and now that iPhone OS 3.0 is out he *thinks* he can blog some things about that too.

Failing that, there is always cheesemaking, and all the other esoteric “I should write that down so i don’t forget it” things which frequently pop into his head.   OH!    And interesting Pictures, etc.