Can NVDA declare contains Data Validation in Excel cells?


Rowen Cary
 

Hi All,

As the title describes, when a cell contains data validation will NVDA users be able to get that information? I use arrows to navigate in cells NVDA doesn't report this, however Narrator reports "contains data validation", I also pressed NVDA+F to try to get that information without success. If NVDA doesn't have that feature then I'd like to know if anyone has made a feature request in Github.

Thanks


Quentin Christensen
 

If you have an "input message" set, then NVDA will read it when the cell gets focus.  If you have the data validation set to a list, then it will read that there is a submenu when you land on it.

If you have an error message set and try to set invalid data, then that will come up as an error dialog, and NVDA will read that when it appears.

If you don't have an input message or list set, then there is no visual indication that the cell contains data validation.  I just tested and yes, Narrator will report "contains data validation" on such a cell.

My feeling personally is that if Microsoft want users to know that then Excel should at least report it maybe in the status bar, but do feel free to create an issue for it.

Quentin.

On Thu, Jun 2, 2022 at 1:04 AM Rowen Cary <manchen_0528@...> wrote:

Hi All,

As the title describes, when a cell contains data validation will NVDA users be able to get that information? I use arrows to navigate in cells NVDA doesn't report this, however Narrator reports "contains data validation", I also pressed NVDA+F to try to get that information without success. If NVDA doesn't have that feature then I'd like to know if anyone has made a feature request in Github.

Thanks



--
Quentin Christensen
Training and Support Manager


Rowen Cary
 

Hello,

Thanks Quentin, I might create a feature request for this,

On Thu, Jun 2, 2022 at 11:33 AM, Quentin Christensen wrote:

If you have an "input message" set, then NVDA will read it when the cell gets focus. If you have the data validation set to a list, then it will read that there is a submenu when you land on it.

If you have an error message set and try to set invalid data, then that will come up as an error dialog, and NVDA will read that when it appears.

If you don't have an input message or list set, then there is no visual indication that the cell contains data validation. I just tested and yes, Narrator will report "contains data validation" on such a cell.

My feeling personally is that if Microsoft want users to know that then Excel should at least report it maybe in the status bar, but do feel free to create an issue for it.

Quentin.

On Thu, Jun 2, 2022 at 1:04 AM Rowen Cary wrote:

Hi All,

As the title describes, when a cell contains data validation will NVDA users be able to get that information? I use arrows to navigate in cells NVDA doesn't report this, however Narrator reports "contains data validation", I also pressed NVDA+F to try to get that information without success. If NVDA doesn't have that feature then I'd like to know if anyone has made a feature request in Github.

Thanks

-- Quentin Christensen Training and Support Manager

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 Twitter: @NVAccess https://twitter.com/NVAccess