Excel Dropdowns (i.e., submenu) - NVDA stops speaking after exiting these


Heather Campbell
 

Hello everyone, 

I'm experiencing an issue when using NVDA 2021.2 to interact with dropdowns/submenus in an Excel file (Office 365). I can press Alt + Down Arrow to expand the list, Down Arrow to the desired option, and then press Enter. However, if I then try to navigate in the sheet, NVDA stops talking. If I Alt + Tab to a different window and then Alt + Tab back to the Excel file, NVDA starts speaking again. Has anyone else experienced this issue? Are there any work arounds? I'm using Windows 10, version 21H1.

Thank you!

Heather 


Jujube
 

Hi, you can try going into NVDA's advanced settings (press NVDA control g, shift tab to the list of categories and press a for advanced), accept the warning and check "use UI automation with Excel" and see if that does anything. NVDA and Office 365 are not a dream team yet, UI automation will be the future for Office 365 users but there are still a number of bugs to sort out which is why UIA is not enabled by default for now. Hope this helps.


On Tue, Nov 2, 2021 at 10:35 AM Heather Campbell <heatherjeancampbell@...> wrote:

Hello everyone, 

I'm experiencing an issue when using NVDA 2021.2 to interact with dropdowns/submenus in an Excel file (Office 365). I can press Alt + Down Arrow to expand the list, Down Arrow to the desired option, and then press Enter. However, if I then try to navigate in the sheet, NVDA stops talking. If I Alt + Tab to a different window and then Alt + Tab back to the Excel file, NVDA starts speaking again. Has anyone else experienced this issue? Are there any work arounds? I'm using Windows 10, version 21H1.

Thank you!

Heather 


hurrikennyandopo ...
 

Hi


If that works can you let us know.


Thanks Gene nz


On 3/11/2021 6:31 am, Heather Campbell wrote:

Hello everyone, 

I'm experiencing an issue when using NVDA 2021.2 to interact with dropdowns/submenus in an Excel file (Office 365). I can press Alt + Down Arrow to expand the list, Down Arrow to the desired option, and then press Enter. However, if I then try to navigate in the sheet, NVDA stops talking. If I Alt + Tab to a different window and then Alt + Tab back to the Excel file, NVDA starts speaking again. Has anyone else experienced this issue? Are there any work arounds? I'm using Windows 10, version 21H1.

Thank you!

Heather 


Heather Campbell
 

Hi Jujube and Gene,
Thank you, Jujube, for your response. When I checked the "use UI automation with Excel," it did fix the issue that I described where NVDA stopped talking after choosing an item from a dropdown. Unfortunately, after I checked this checkbox, NVDA stopped reading column titles that I had defined using Excel's define name feature. I also could not press NVDA + Shift + C to set column titles or NVDA + Shift + R to set row titles. It just typed a C or R in the cell. 
Heather


From: nvda@nvda.groups.io <nvda@nvda.groups.io> on behalf of hurrikennyandopo ... <hurrikennyandopo@...>
Sent: Tuesday, November 2, 2021 8:06 PM
To: nvda@nvda.groups.io <nvda@nvda.groups.io>
Subject: Re: [nvda] Excel Dropdowns (i.e., submenu) - NVDA stops speaking after exiting these
 

Hi


If that works can you let us know.


Thanks Gene nz


On 3/11/2021 6:31 am, Heather Campbell wrote:

Hello everyone, 

I'm experiencing an issue when using NVDA 2021.2 to interact with dropdowns/submenus in an Excel file (Office 365). I can press Alt + Down Arrow to expand the list, Down Arrow to the desired option, and then press Enter. However, if I then try to navigate in the sheet, NVDA stops talking. If I Alt + Tab to a different window and then Alt + Tab back to the Excel file, NVDA starts speaking again. Has anyone else experienced this issue? Are there any work arounds? I'm using Windows 10, version 21H1.

Thank you!

Heather 


David Goldfield
 

Heather, I vaguely remember encountering this problem and I have a slightly simpler workaround. Once you select an item from a drop-down press the Windows key twice instead of pressing alt+tab twice. In fact, it’s likely that pressing the alt key twice will also force NVDA to begin reading as you navigate your spreadsheet. I think the trick is to move your focus away from and then back to the spreadsheet.

 

David Goldfield,

Blindness Assistive Technology Specialist

JAWS Certified, 2019

Subscribe to the Tech-VI announcement list to receive emails regarding news and events in the blindness assistive technology field.

Email: tech-vi+subscribe@groups.io

 

www.DavidGoldfield.org

 

 

 

From: nvda@nvda.groups.io <nvda@nvda.groups.io> On Behalf Of Heather Campbell
Sent: Tuesday, November 2, 2021 5:37 PM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Excel Dropdowns (i.e., submenu) - NVDA stops speaking after exiting these

 

Hi Jujube and Gene,
Thank you, Jujube, for your response. When I 
checked the "use UI automation with Excel," it did fix the issue that I described where NVDA stopped talking after choosing an item from a dropdown. Unfortunately, after I checked this checkbox, NVDA stopped reading column titles that I had defined using Excel's define name feature. I also could not press NVDA + Shift + C to set column titles or NVDA + Shift + R to set row titles. It just typed a C or R in the cell. 

Heather

 


From: nvda@nvda.groups.io <nvda@nvda.groups.io> on behalf of hurrikennyandopo ... <hurrikennyandopo@...>
Sent: Tuesday, November 2, 2021 8:06 PM
To: nvda@nvda.groups.io <nvda@nvda.groups.io>
Subject: Re: [nvda] Excel Dropdowns (i.e., submenu) - NVDA stops speaking after exiting these

 

Hi

 

If that works can you let us know.

 

Thanks Gene nz

 

On 3/11/2021 6:31 am, Heather Campbell wrote:

Hello everyone, 

I'm experiencing an issue when using NVDA 2021.2 to interact with dropdowns/submenus in an Excel file (Office 365). I can press Alt + Down Arrow to expand the list, Down Arrow to the desired option, and then press Enter. However, if I then try to navigate in the sheet, NVDA stops talking. If I Alt + Tab to a different window and then Alt + Tab back to the Excel file, NVDA starts speaking again. Has anyone else experienced this issue? Are there any work arounds? I'm using Windows 10, version 21H1.

Thank you!

Heather 


 

Heather,

If what's been offered here has still not gotten you the result you're looking for, consider joining the Microsoft Office Accessibility Discussion Group.  Alan Lemly, the group owner, is an Excel wiz and a number of other folks well versed in Excel participate there.
--

Brian - Windows 10, 64-Bit, Version 21H1, Build 19043  

The ignorance of one voter in a democracy impairs the security of all.

         ~ John F. Kennedy

 


David Goldfield
 

Hi. One minor correction in that I’m actually the group owner of the Office Accessibility list. However, Alan’s contributions are invaluable.

 

 

David Goldfield,

Blindness Assistive Technology Specialist

JAWS Certified, 2019

Subscribe to the Tech-VI announcement list to receive emails regarding news and events in the blindness assistive technology field.

Email: tech-vi+subscribe@groups.io

 

www.DavidGoldfield.org

 

 

 

From: nvda@nvda.groups.io <nvda@nvda.groups.io> On Behalf Of Brian Vogel
Sent: Tuesday, November 2, 2021 6:11 PM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Excel Dropdowns (i.e., submenu) - NVDA stops speaking after exiting these

 

Heather,

If what's been offered here has still not gotten you the result you're looking for, consider joining the Microsoft Office Accessibility Discussion Group.  Alan Lemly, the group owner, is an Excel wiz and a number of other folks well versed in Excel participate there.
--

Brian - Windows 10, 64-Bit, Version 21H1, Build 19043  

The ignorance of one voter in a democracy impairs the security of all.

         ~ John F. Kennedy

 


Jujube
 

Hi Heather, Yeah this is why office 365 and NVDA are a bit of a mess right now. A whole bunch of issues have been opened on GitHub and I think they're being fixed slowly but surely in upcoming NVDA releases. You can try NVDA 2021.3 beta1 which is now available and see if that helps anything. There has been some improvement in the upcoming 2021.3 release but still a fair ways to go.

Regarding the row and column header setting issue, I have experienced it myself and have reported it here: https://github.com/nvaccess/nvda/issues/12882

Excel does in fact have its own column and row header setting feature which is non screen reader specific. It involves pressing control F3 on the cell you want to make into a header, then alt N for new, and then typing Title.. for the name field (you can, for instance, type Title..H10 to specify that this will only affect cells between, say, A2 and H10), but even that doesn't work properly with UIA enabled. Unfortunately you may have to be turning UIA on and off regularly until all this gets fixed in upcoming builds of NVDA. Sorry this isn't great news at the moment, but it's the truth.

On Tue, Nov 2, 2021 at 2:41 PM David Goldfield <david.goldfield@...> wrote:

Heather, I vaguely remember encountering this problem and I have a slightly simpler workaround. Once you select an item from a drop-down press the Windows key twice instead of pressing alt+tab twice. In fact, it’s likely that pressing the alt key twice will also force NVDA to begin reading as you navigate your spreadsheet. I think the trick is to move your focus away from and then back to the spreadsheet.

 

David Goldfield,

Blindness Assistive Technology Specialist

JAWS Certified, 2019

Subscribe to the Tech-VI announcement list to receive emails regarding news and events in the blindness assistive technology field.

Email: tech-vi+subscribe@groups.io

 

www.DavidGoldfield.org

 

 

 

From: nvda@nvda.groups.io <nvda@nvda.groups.io> On Behalf Of Heather Campbell
Sent: Tuesday, November 2, 2021 5:37 PM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Excel Dropdowns (i.e., submenu) - NVDA stops speaking after exiting these

 

Hi Jujube and Gene,
Thank you, Jujube, for your response. When I 
checked the "use UI automation with Excel," it did fix the issue that I described where NVDA stopped talking after choosing an item from a dropdown. Unfortunately, after I checked this checkbox, NVDA stopped reading column titles that I had defined using Excel's define name feature. I also could not press NVDA + Shift + C to set column titles or NVDA + Shift + R to set row titles. It just typed a C or R in the cell. 

Heather

 


From: nvda@nvda.groups.io <nvda@nvda.groups.io> on behalf of hurrikennyandopo ... <hurrikennyandopo@...>
Sent: Tuesday, November 2, 2021 8:06 PM
To: nvda@nvda.groups.io <nvda@nvda.groups.io>
Subject: Re: [nvda] Excel Dropdowns (i.e., submenu) - NVDA stops speaking after exiting these

 

Hi

 

If that works can you let us know.

 

Thanks Gene nz

 

On 3/11/2021 6:31 am, Heather Campbell wrote:

Hello everyone, 

I'm experiencing an issue when using NVDA 2021.2 to interact with dropdowns/submenus in an Excel file (Office 365). I can press Alt + Down Arrow to expand the list, Down Arrow to the desired option, and then press Enter. However, if I then try to navigate in the sheet, NVDA stops talking. If I Alt + Tab to a different window and then Alt + Tab back to the Excel file, NVDA starts speaking again. Has anyone else experienced this issue? Are there any work arounds? I'm using Windows 10, version 21H1.

Thank you!

Heather 


Heather Campbell
 

Thank you.


On Nov 2, 2021, at 6:13 PM, David Goldfield <david.goldfield@...> wrote:



Hi. One minor correction in that I’m actually the group owner of the Office Accessibility list. However, Alan’s contributions are invaluable.

 

 

David Goldfield,

Blindness Assistive Technology Specialist

JAWS Certified, 2019

Subscribe to the Tech-VI announcement list to receive emails regarding news and events in the blindness assistive technology field.

Email: tech-vi+subscribe@groups.io

 

www.DavidGoldfield.org

 

 

 

From: nvda@nvda.groups.io <nvda@nvda.groups.io> On Behalf Of Brian Vogel
Sent: Tuesday, November 2, 2021 6:11 PM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Excel Dropdowns (i.e., submenu) - NVDA stops speaking after exiting these

 

Heather,

If what's been offered here has still not gotten you the result you're looking for, consider joining the Microsoft Office Accessibility Discussion Group.  Alan Lemly, the group owner, is an Excel wiz and a number of other folks well versed in Excel participate there.
--

Brian - Windows 10, 64-Bit, Version 21H1, Build 19043  

The ignorance of one voter in a democracy impairs the security of all.

         ~ John F. Kennedy

 


Pranav Lal
 

Hi Heather,

 

I can duplicate your experience about NVDA not reading row and column title and we losing the ability to define them after use uia is checked.

 

Pranav

 

 

From: nvda@nvda.groups.io <nvda@nvda.groups.io> On Behalf Of Heather Campbell
Sent: Wednesday, November 3, 2021 3:07 AM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Excel Dropdowns (i.e., submenu) - NVDA stops speaking after exiting these

 

Hi Jujube and Gene,
Thank you, Jujube, for your response. When I 
checked the "use UI automation with Excel," it did fix the issue that I described where NVDA stopped talking after choosing an item from a dropdown. Unfortunately, after I checked this checkbox, NVDA stopped reading column titles that I had defined using Excel's define name feature. I also could not press NVDA + Shift + C to set column titles or NVDA + Shift + R to set row titles. It just typed a C or R in the cell. 

Heather

 


From: nvda@nvda.groups.io <nvda@nvda.groups.io> on behalf of hurrikennyandopo ... <hurrikennyandopo@...>
Sent: Tuesday, November 2, 2021 8:06 PM
To: nvda@nvda.groups.io <nvda@nvda.groups.io>
Subject: Re: [nvda] Excel Dropdowns (i.e., submenu) - NVDA stops speaking after exiting these

 

Hi

 

If that works can you let us know.

 

Thanks Gene nz

 

On 3/11/2021 6:31 am, Heather Campbell wrote:

Hello everyone, 

I'm experiencing an issue when using NVDA 2021.2 to interact with dropdowns/submenus in an Excel file (Office 365). I can press Alt + Down Arrow to expand the list, Down Arrow to the desired option, and then press Enter. However, if I then try to navigate in the sheet, NVDA stops talking. If I Alt + Tab to a different window and then Alt + Tab back to the Excel file, NVDA starts speaking again. Has anyone else experienced this issue? Are there any work arounds? I'm using Windows 10, version 21H1.

Thank you!

Heather