Re: Glitches with Excel in Leopard

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Thanks Bob! Your long experience with Excel is, as always, invaluable! Your
thoughts on this issue are really valuable, and we'll take them into
consideration before making any further changes to cell double-clicking
behavior.

FWIW, I've heard (both on this newsgroup and elsewhere) from probably a
dozen customers about this "problem" as they see it. That's not at all to
say that it demands to be changed. At least now I have a better
understanding of the problem and we can educate people better about how this
feature works.

Thanks again,

Pat


On 7/20/08 11:00 PM, in article C4A99E3C.3F64D%onlygeneraltaz1@xxxxxxxxxxxx,
"CyberTaz" <onlygeneraltaz1@xxxxxxxxxxxx> wrote:

Hi Patrick -

Some interjections below;

On 7/21/08 1:02 AM, in article C4A96692.24106%patmcmil@xxxxxxxxxxxxx, "Pat
McMillan" <patmcmil@xxxxxxxxxxxxx> wrote:

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.

More completely:

Dbl-clicking the top/bottom cell wall is a shortcut for getting to the
top/bottom of a consecutively filled column of cells. Dbl-clicking the
left/right cell wall takes the selector to the respective end of
consecutively filled cells in the row.

I'm honestly
not sure why it was ever developed that way, but there may have been a
legitimate reason at some point.

He "legitimate reason" is that it's a very useful *feature* :-) Far more
expeditious than having to use the keyboard shortcuts when reviewing,
quicker & more accurate than scrolling, and significantly more convenient
than most other navigation techniques for getting to the start/end of a
row/column.

The problem in Excel 2008 is that, for some
reason, we increased the thickness of our cell borders by a pixel or two,

Probably because the advent of higher res displays made the "old" cell walls
virtually invisible :-) Personally, I'd rather see you folks grab the cell
wall color option from your Win counterparts.

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!

Yeah - kinda like having to be cognizant of pointer appearance when dragging
to select cells so as to avoid Drag 'n' Drop or AutoFill.


We're actually hoping to fix this in a future update,

I - for one - would hate to see that happen. Removing useful features to
accommodate inattentiveness seems rather counterproductive :-) In more than
4 years in these groups this is the first mention I've ever seen on the
matter. In fact, now that Matt is aware of what's going on perhaps he'll
find it as useful as I do. Apparently it isn't a widespread issue - possibly
related to...

but until we do, the
best advice is to take as much care as possible to avoid cell borders when
double-clicking on cells.

Exactly!

Another, though less than perfect, workaround, is
to select the desired cell with a single click, then press Control + U to go
into edit mode.

"Less than perfect", perhaps, but pretty close. "Perfect" - IMHO - is
editing in the Formula Bar rather than in the body of the data in the first
place :-) In fact, I keep the Pref for double-clicking to edit in cells
cleared so I *don't* get into edit mode accidentally.


Thanks,

Pat

Just another perspective :-)

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



On 7/19/08 6:00 PM, in article ee7fdb7.126@xxxxxxxxxxxxxxxxxxxxxxx, "Matt"
<Matt> wrote:

I am not sure whether this is a glitch or a UI change. In Excel, double
clicking a cell to change the contents will make it jump to a seemingly
random
row in that same column. At times it will jump to the nearest empty cell,
other times it will jump to a populated cell that is different in some
respect, color, shading, or something else.

Please don't say UI enhancement. UI 'enhancements' drove me back to
Word2004.
:)

- anon - too lazy to create an account.


--
Pat McMillan
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.


.

Relevant Pages

  • Re: Output form to excel with range ????
    ... here is a long post with lots of useful code for exporting to excel. ... Dim varGetFileName As Variant 'File Name with Full Path ... Set objXLws = objXLWkb.ActiveSheet ... For Each cell In objXLws.Range ...
    (microsoft.public.access.formscoding)
  • Re: Access to Excel
    ... by cell I mean the cell in the excel sheet in this case cell G8 I am trying ... By form I mean an excel sheet that has been designed with lines and boxes ... "John Nurick" wrote: ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.externaldata)
  • RE: More Help Needed..please
    ... Call SeeDiff ... Private Sub Workbook_Open ... By the way, if for some reason you ever select a cell in column A, the above ... I was going to use both Worksheet_Change & Workbook_Open in an Excel file ...
    (microsoft.public.excel.programming)
  • Re: Getting around Dependency Tree Performance Problems
    ... Bug in Excel VBA that causes the VBE title bar to be refreshed each time ... unless the calculation is initated from VBA: ... VBA UDFs are called by Excel even when their arguments are uncalculated. ... Using these techniques will reduce the worst-case timing for the 14000 cell ...
    (microsoft.public.excel.programming)
  • Re: VBA: For Count, when count changes from cell to cell
    ... with Excel 2000. ... reporting Macro being unavailable. ... Sub CalculateI3() ... means that you can refer to it in a cell just like a built-in Excel function. ...
    (microsoft.public.excel.misc)