Re: Glitches with Excel in Leopard

No Offense intended, Matt - I wasn't referring to you or anyone in
particular. Just a general observation about inattention of many to the
availability of features software has to offer, not intended to suggest
carelessness on anyone's part. In fact, I concur fully about the fact that
the feature is more sensitive in 2008 for the same reasons you cite.

The abominably disrespectful way the Formula Bar has been treated in this
version is a source of aggravation for just about everyone I know. I'm
afraid you've missed no checkbox. Your best bet [IMHO] is to dock it
directly beneath the Menu Bar rather than leave it floating - at least it
has been fixed to the point that it doesn't any longer automatically splay
out the way it originally did in the initial release :-)

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 7/21/08 7:02 PM, in article ee7fdb7.130@xxxxxxxxxxxxxxxxxxxxxxx, "Matt"
<Matt> wrote:

Hello! Thanks for the quick responses.

Well, this isn't a UI enhancement. In fact, what you're seeing is that
when you double-click on a cell *border*, Excel moves the selection to
the top cell in that column. This is actually how Excel 2004 works too.
I'm honestly not sure why it was ever developed that way, but there may
have been a legitimate reason at some point.




Ah, I had a suspicion that it was intentional, however I had never
inadvertently activated it in Excel2004..

The problem in Excel 2008 is that, for some reason, we increased the
thickness
of our cell borders by a pixel or two, which seems just enough to make
it more likely that you will double click on a border when you're
intending
to double-click on a cell!




That would explain it, Thanks! That has turned a 1% occurrence into 80% for me
and others that use Excel2008 in my office.

I challenge Mr. Jones' opinion - it is not a matter of inattentiveness as it
is a combination of pointing device, resolution and cell size. I propose that
the selection area for the borders would become a tweakable item rather than a
permanent change, since not all Excel users have the same use case as Mr.
Jones. The border-click feature appears to overlap entirely with the
Apple-(cursor movement) keys. I would accept the formula bar option, however
it seems that it's appearance on the display is XORed with the display of the
Formatting Palette, despite how many places the "Show Formula Bar" preference
is checked. I am assuming that I have missed a hidden checkbox somewhere
though..

Thanks again!

.