toggle quoted messageShow quoted text
Thinking on it a bit further, and looking back at the ribbon in Word and Excel, the key word is "split button". A split button, visually, is a button where you activate the main part of it to do the most common action. An arrow coming off the right side opens a menu of other related options. The most common example of a split button is the start menu item for a program such as Word in Windows 7. When you arrow to Word in the start menu in Windows 7, you can either press ENTER to go into a blank document (or the backstage) in Word. Alternatively, you can press the right arrow to open a "jump list" of recent documents you have used in Word.
Insert, Delete and Format cells in Excel are setup the same way. When you press ENTER on the insert button, for me it inserts a cell and pushes the rest down. If I have multiple cells selected, it inserts multiple cells, pushing either right or down, depending on what was selected.
Merge and Centre, Font Colour, Accounting number format, and sum all do the same thing on the home ribbon in Excel, They all have an action they perform if you activate them, and a list of related actions you can get to if you alt+down arrow on them. It might not be obvious, but there you go.
On Sat, Feb 18, 2017 at 9:46 PM, Brian's Mail list account <bglists@...>
However playing devils advocate a little here, can one be sure that the original menu version of this worked or did it only work via mouse selection or direct shortcut?
This sounds to me like an issue with the software in that the keyboard action of getting the dialogue or whatever to focus enough to get at the options simply won't work in that case. As such it needs to be sorted by Microsoft if it has Jaws and nvda giving similar results.
Its not that the function is not there, it is, but in an illogical place and seemingly not selectable from the ribbon route, only by mouse or keyboard shortcuts.
Sent via blueyonder.
Please address personal email to:-
briang1@..., putting 'Brian Gaff'
in the display name field.
----- Original Message ----- From: "Ron Canazzi" <aa2vm@...>
Sent: Saturday, February 18, 2017 6:37 AM
Subject: [nvda] Significant Area Of Excel Where Ribbons simply Make No Sense and Don't Work
I have started a new thread on this ribbon business since some have complained that the other thread had drifted away from the original intent.
Here's one big issue with ribbons and Excel.
If one wants to insert a structural element of a work book such as a row, column area or sheet, one cannot do this by navigating the ribbons. The short cut which I will describe does work, but this was given to me by someone who figured it out with sighted help.
First of all, try looking for the items under the insert portion of the ribbon. They simply aren't there. Then via experimentation and observation, you find a separate insert item under the home portion of the ribbon under general. There's a problem, if you simply navigate to the insert item, and press either enter or space bar, nothing happens. somehow if you use the shortcut alt + h, I, you do get a list of items. You can then pick the desired item and press enter and follow the prompts or whatever. If you don't know the designated shortcut sequence, you simply can't find this item and get it to work with screen readers: JAWS or NVDA.
I know I have seen this in other Microsoft programs such as Access and Power Point as well.
I'm sorry folks, using ribbons does not give full access to screen reader users in many programs as we used to have under the standard drop down or pull down menus.
They Ask Me If I'm Happy; I say Yes.
They ask: "How Happy are You?"
I Say: "I'm as happy as a stow away chimpanzee on a banana boat!"
Training Material Developer