Re: NVDA problems with excel when editing form fill


William
 

Well, I have tried using the define name function, but NVDA would not read out the columns by its defined title.


Brian Vogel 於 31/1/2021 0:17 寫道:

Regardless of the screen reader being used, I strongly encourage the use of Excel's built-in column and row designation so that the burden is not on the screen reader, nor any other screen reader user, to set this up if the workbook is handled by someone else.

What follows is an excellent tutorial, with background information, written by Alan Lemly on the Microsoft Office Accessibility Discussion Group regarding how to do what I've just mentioned.
-------------------------

Reading Row and Column Headers Using Excel Defined Titles – A Tutorial

by Alan Lemly

 

Original text can be found at:  https://groups.io/g/office-accessibility/topic/77311167

As someone else posted, Freedom Scientific has a document explaining the use of row and column headers in Excel at this website:

https://doccenter.freedomscientific.com/doccenter/doccenter/rs25c51746a0cc/2013-09-25_ExcelAndWordHeaders/02_HeadersInExcel.htm

While that site has an excellent explanation of the process, it has a major omission which prevents defined name titles from speaking when set up. As explained at that site, users of Excel with JAWS have two different options if they'd like to create row and column headers that can be saved and accessed:

1.   Titles (i.e., row headers and column headers) created using the define name feature of Excel. This is the preferred method because these titles can be created by those not even using JAWS and accessed at a later time by anyone with JAWS because they are saved with the spreadsheet.

2.   Titles created using JAWS quick settings dialog box. These titles are saved in a workbook-specific JSI file located in your personal settings folder, a separate file that is created and has to accompany the workbook everywhere it goes.

This tutorial will explain option 1 since its titles can be saved with the workbook, transferred to another JAWS user, and does not require use of a separate JSI file to work. What this method does require that is omitted from the Freedom Scientific explanation is a change to a default setting for Defined name column and row titles override so that title reading of these defined ranges will occur. Therefore, the default override must be set to off instead of on. You can access this setting by:

·        Pressing Insert + V to access the quick settings

·        Typing Title reading in the search box

·        Arrow down through the search results to the first one which is Define name column and row titles override and making sure it is set to off. By default, mine was originally set to on which causes this preferred title reading method not to work.

 

My thanks to Ann Byrne of the main@jfw.groups.io list who originally explained defined titles to me and the need to turn off the override so they will read properly with JAWS.

I'm creating a sample Excel spreadsheet for this post to help with my explanation. I'll include a Dropbox download link at the end for those who want it. This sample spreadsheet is for tracking books which I've read. It contains the following column headings beginning in cell A1 and continuing through cell H1. 

Title

Author

Narrator

Date Finished

NLS Book Number

Book Length

Rating

Comments

This spreadsheet will end up containing many rows since I read a lot so when defining the range which will include the column and row headers, I'm going to estimate the number of rows it should contain to include future expansion. I've made the first column be the title of the book since it makes since as I arrow up and down the various rows in the sheet that the book title be announced as I land on a new row. The intersection of the column headers and row headers that I want Excel to red as I navigate through the sheet is cell A1 so focus should be there when the defined range is created. To create the range, with focus on cell A1:

1.   Press alt + m + m. This will place you on the ribbon bar on the define name button and you should press enter.

2.   You will be in a text box where you create the defined name of your column and row headers. I almost exclusively use both column and row headers for most of my spreadsheets since they normally contain multiple rows and columns.  In this case, your defined name should begin with the word Title. If you only want row headers, your defined name should begin with RowTitle. If you only want column headers, your defined name should begin with ColumnTitle. You should have no spaces in the defined title text box so if your spreadsheet has multiple regions for which you want separate defined titles, I'd suggest you use Region1, Region2, etc. after title with no spaces to distinguish your defined title ranges. Use a period to separate the name of the defined title from the cell range comprising it. In my example spreadsheet, my columns run from A1 through H1 and I'm estimating 1000 rows so my defined title will be TitleRegion1.A1.H1000. I could have omitted Region1 since I don't expect more regions on this sheet but included it for reference purposes.

3.   Press tab until you get to the Ok button and hit enter to complete the creation of your defined title range. If you later need to edit it, open the range manager by pressing alt + m + n and select the range you want to edit and press alt + e. You will be placed in a text box where you can make changes.

After you've entered book info of the titles you've red, arrowing up and down in the sheet will result in JAWS reading the book title of the particular row. Arrowing right and left through the various columns will result in JAWS reading the column heading of that column. Provided you turned off the title reading of defined range override mentioned earlier in this document, your row and column title headers should be read by JAWS. Also, you can give a copy of your workbook to anyone else using JAWS and those row and column headers will also be read for them provided they turn off the defined title reading override.

Here is a Dropbox download link to Books read sample spreadsheet mentioned above:

https://www.dropbox.com/s/z16eb63i679t6b0/Books%20read%20for%20OA.xlsx?dl=1

I hope this helps.

Alan Lemly

 

--

Brian - Windows 10 Pro, 64-Bit, Version 20H2, Build 19042  

The depths of denial one can be pushed to by outside forces of disapproval can make you not even recognize yourself to yourself.

       ~ Brian Vogel

 

Join nvda@nvda.groups.io to automatically receive all group messages.