Unable to set row or column headers in Excel
|
Luke Robinett
NVDA Version: 2021.3.1 MS Office (Version 2112 Build 16.0.14729.20254) 64-bit Windows 10 Pro, version 10.0.19042 Build 19042
Issue: Pressing the NVDA shortcut keys to mark the start of row and column headers in Excel is not working. Expected: Pressing shift+NVDA+R or shift+NVDA+C sets the current cell as the start of row or column headings, respectively. Actual: These shortcut keys are not recognized by NVDA and end up modifying the value of the selected cell. Previous Steps:
|
|
|
|
Luke
Although this is not likely the central issue, you're on Windows 10 Version 20H2, which is now two full feature updates behind. It would make sense to get up-to-date there. Also, all of the versions of Excel since Excel 2016 have a version number of 16 dot something. It's better to specify the commercial version number, e.g., Excel 2019 or Excel 365, than the embedded version number. Bless you for including a version number, but very few techs even try to memorize that particular version number when it comes to Office. -- Brian - Windows 10, 64-Bit, Version 21H2, Build 19044 The instinctive need to be the member of a closely-knit group fighting for common ideals may grow so strong that it becomes inessential what these ideals are. ~ Konrad Lorenz (1903-1989)
|
|
|
|
Luke Robinett
Hi Brian, Thank you for the response. My mistake —I actually meant to include that this is Office 365. This is my work laptop and I believe Windows is set to update automatically but I will manually upgrade to the latest version if that’s not the case. Any other ideas? Oh, I also checked to make sure that I was using the desktop layout which indeed I am. That’s the correct layout because I’m using an external full-size keyboard. Thanks again! Luke On Feb 1, 2022, at 3:00 PM, Brian Vogel <britechguy@...> wrote:
|
|
|
|
Quentin Christensen
The main things I can think of are: - are you SURE you are pressing the right keys? EG if using the numpad insert, is numlock off? - Are you in edit mode? EG when you start typing in a cell or press F2 to edit it, you are in edit mode and can change the contents of the cell - but you CAN'T set column and row headers - you need to finish editing either with enter / tab / control+enter (to stay on that cell) or escape. THEN you can set column and row headers. - Are the headers already set - importantly, what is NVDA saying when you press NVDA+shift+r or NVDA+shift+c? Otherwise, I'm using the same version of NVDA and Office and a slightly newer Windows build by the look of it and all working here: NVDA 2021.3.1 Windows 10 (64-bit) Version: 21H2 (2009), Build: 19044.1466 Office 365 (64-bit) Version: 16.0.14729.20254 Last thing - are you using any NVDA add-ons? If you disable those - press NVDA+q then down arrow to "restart with add-ons disabled" and enter, does it make a difference? Quentin. On Wed, Feb 2, 2022 at 10:05 AM Luke Robinett <lukelistservs@...> wrote:
--
Quentin Christensen Training and Support Manager Training: https://www.nvaccess.org/shop/ Certification: https://certification.nvaccess.org/ User group: https://nvda.groups.io/g/nvda Facebook: http://www.facebook.com/NVAccess Twitter: @NVAccess |
|
|
|
benmoxey@...
Hi Luke
Also, make sure you haven’t enabled the UI automation for Excel controls in the Advanced section of NVDA settings.
Cheers
Ben
From: nvda@nvda.groups.io <nvda@nvda.groups.io> On Behalf Of Quentin Christensen
Sent: Wednesday, 2 February 2022 10:58 AM To: nvda@nvda.groups.io Subject: Re: [nvda] Unable to set row or column headers in Excel
The main things I can think of are:
- are you SURE you are pressing the right keys? EG if using the numpad insert, is numlock off? - Are you in edit mode? EG when you start typing in a cell or press F2 to edit it, you are in edit mode and can change the contents of the cell - but you CAN'T set column and row headers - you need to finish editing either with enter / tab / control+enter (to stay on that cell) or escape. THEN you can set column and row headers. - Are the headers already set - importantly, what is NVDA saying when you press NVDA+shift+r or NVDA+shift+c?
Otherwise, I'm using the same version of NVDA and Office and a slightly newer Windows build by the look of it and all working here:
NVDA 2021.3.1
Last thing - are you using any NVDA add-ons? If you disable those - press NVDA+q then down arrow to "restart with add-ons disabled" and enter, does it make a difference?
Quentin.
On Wed, Feb 2, 2022 at 10:05 AM Luke Robinett <lukelistservs@...> wrote:
-- Quentin Christensen
Web: www.nvaccess.org Training: https://www.nvaccess.org/shop/ Certification: https://certification.nvaccess.org/ User group: https://nvda.groups.io/g/nvda Facebook: http://www.facebook.com/NVAccess |
|
|
|
I have no idea whether Live Preview could play into this or not, but even if not, it's still worth reading through the recent topic:
NVDA glitches when reporting cells and their data in Microsoft Excel--Brian - Windows 10, 64-Bit, Version 21H2, Build 19044 The instinctive need to be the member of a closely-knit group fighting for common ideals may grow so strong that it becomes inessential what these ideals are. ~ Konrad Lorenz (1903-1989)
|
|
|
|
Luke Robinett
Thanks for the additional suggestions, everybody. I’ve got basically the same setup on my home desktop computer and I tried that last night and it worked exactly as expected. Obviously something is up with the work laptop and this isn’t an NVDA issue specifically. Who knows? Perhaps today when I logon it will magically start working. That happens sometimes. :) On Feb 2, 2022, at 6:54 AM, Brian Vogel <britechguy@...> wrote:
|
|
|
|
Luke Robinett
Well, luck wasn’t on my side because the issue still persists today on my work laptop. I was absolutely slammed at work today so I haven’t really had much of a chance to troubleshoot, but I will review the suggestions I received here when I get a chance and report back on what I find. Very strange. On Feb 2, 2022, at 7:57 AM, Luke Robinett via groups.io <lukelistservs@...> wrote:
|
|
|
|
enes sarıbaş
Hi, I am able to reproduce this, latest Office 365, latest Win11
with January 2022 patches, and alpha build of NVDA. On 2/1/2022 5:05 PM, Luke Robinett
wrote:
|
|
|
|
Before I go any further, be aware:
1. I am aware what follows does not solve the actual problem reported, whether it has NVDA or Excel 365 as its root. 2. The tutorial referenced is for JAWS, but what is covered is screen reader agnostic, because it is using Excel's own built-in column heading and row heading function 3. Regardless of screen reader, and its ability to define row/column headers in the screen reader, I prefer using Excel's native marking capability, as it carries with the workbook. See if using the Excel definition method will serve as a workaround for the current issue. It very well may. From the Office Accessibility Group: Reading row and column headers using Excel defined titles tutorial As the old saying goes: There's more than one way to skin a cat! (And, no, I do not hate cats; I've owned many.) -- Brian - Windows 10, 64-Bit, Version 21H2, Build 19044 I neither need nor want to be appeased, but apprised. Inconvenient truth is preferable to convenient (for the liar) lies. ~ Brian Vogel
|
|
|