Re: Automatic Column and Row Header Reading


Cearbhall O'Meadhra
 

Sam,

 

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,

 

Cearbhall

 

m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@...

 

 

From: nvda@nvda.groups.io <nvda@nvda.groups.io> On Behalf Of Sam Taylor via groups.io
Sent: Monday, July 13, 2020 11:47 PM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Automatic Column and Row Header Reading

 

Thanks Cearbhall,

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.

Thanks

Sam

 

On 13/07/2020 11:00 pm, Cearbhall O'Meadhra wrote:

Sam,

 

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.

 

All the best,

 

Cearbhall

 

m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@...

 

 

From: nvda@nvda.groups.io <nvda@nvda.groups.io> On Behalf Of Sam Taylor via groups.io
Sent: Monday, July 13, 2020 11:08 AM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Automatic Column and Row Header Reading

 

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.

 

Quentin

 

On Mon, Jul 13, 2020 at 5:30 PM Sam Taylor via groups.io <samtaylor9=me.com@groups.io> wrote:

Hi all,

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.

Cheers

Sam

 


 

--

Quentin Christensen
Training and Support Manager

 

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