Re: Automatic Column and Row Header Reading
toggle quoted messageShow quoted text
Are you able to edit text in each individual cell? If not, that might be a pointer to an Excel option that need to be set
We used to have to make sure that “Allow editing in cells” under the advanced tab in Excel > Options in order to make NVDA work while editing, for example.
All the best,
m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@...
From: firstname.lastname@example.org <email@example.com> On Behalf Of Sam Taylor via groups.io
Sent: Monday, July 13, 2020 11:47 PM
Subject: Re: [nvda] Automatic Column and Row Header Reading
I have constructed a test workbook without any blank lines. Still I cannot get NVDA to read the coordinates as it should. I have tested with NVDA 2019 and 2017 with the same result, so I am beginning to wonder whether there is some type of setting in Excel itself which is causing this to happen.
On 13/07/2020 11:00 pm, Cearbhall O'Meadhra wrote:
Have you any blank columns separating blocks of columns. If so, you would need to set the column headings on the first cell in the heading row of each block to make NVDA call out the column headings for that block.
Yep, I did that also, but still nothing appears to change. I followed the example in the Excel with NVDA study material.
On 13/07/2020 6:00 pm, Quentin Christensen wrote:
You need to tell NVDA where the headers are for it to read them. Press NVDA+shift+c to set column headers and NVDA+shift+r to set row headers. Note that you need to be in the first cell you want headers read.
11.2.1 of the NVDA user guide mentions that NVDA is able to automatically announce appropriate row and column headers when navigating around Excel worksheets.
I used to be able to achieve this but it doesn't appear to work for me any more, and indeed as of NVDA 2019.3.
The cell coordinates just appear to read as usual, rather than reading any additional cell references.
I have enabled the Report Table row / column headers option in NVDA's Document Formatting settings.
y duCan anybodyplicate or suggest anything? This is highly likely to be user error.
Training and Support Manager
Join firstname.lastname@example.org to automatically receive all group messages.