Re: Excel reads numeric cells in column E as exponents rather than cell value


Matthew Horspool
 

Hi Quentin,

Doing something with how the string is formatted would do wonders for me! I'm a long time JAWS user and technically minded, but I still cannot come to terms with how NVDA "gabbles" out all of its information in one go. Perhaps I've got too used to my creature comforts, but having differentiation between things like this is such a big deal for me that I simply cannot switch to NVDA full-time. If it was improved I would consider a switch much more viable.

Inserting a comma between the cell data and its coordinates would be a good step in the right direction. Could the same be done, please, for table cell coordinates generally, table header information, access keys in menus, the name of a menu and the first control in that menu, etc?

It is only a quick fix though. Longer term, you could do worse than to implement something akin to the JAWS model, e.g. by introducing a message voice which could read coordinates, access keys and suchlike. If this is set differently, a pause will occur naturally as the voice changes. If it's set the same, pauses could be eliminated for those who like the way NVDA does things currently.

Even longer term, something like the Speech and Sounds Manager would be simply fantastic! I have perfect pitch and so, in JAWS, I currently have heading level 1 play a note C, heading level 2 play a D, level 3 an E and so on. Switching to NVDA which must report to heading and its level in speech, because what else is it supposed to do other than not report it at all, feels very sluggish. I also have sounds for buttons, radio buttons, combo and list boxes, tree views and so on and some of this can be replicated in an add-on, but not as neatly. I heard somewhere about something nicknamed "Speech Refactor" which might make some of this stuff possible? Where are we with that?

Thanks,

Matthew

 

From: nvda@nvda.groups.io [mailto:nvda@nvda.groups.io] On Behalf Of Quentin Christensen
Sent: 19 November 2018 23:14
To: nvda@nvda.groups.io
Subject: Re: [nvda] Excel reads numeric cells in column E as exponents rather than cell value

 

Rick,

 

Well spotted, and interesting pickup.  This is exactly why NVDA itself doesn't try to interpret information, but simply present it as it is displayed.  Many synthesizers do try to interpret data, which is where you end up with St being read as "street" when it is actually used in the context of "saint" or dr for Doctor instead of drive.

 

In this case, it is processing the whole string (value and cell coordinates) as one piece of information: 1.24E4 is read as the scientific formatted number "1.24 times 10 to the power of 4".  If the value was in the cell above it is read as "1.24 times 10 cubed" or in E2 as "1.24 times 10 squared".  It is interesting to note that this affects the OneCore voices, and even then only some of them.  On my system, I have ten OneCore voices.  Of those:

- David, Zira and Mark interpret the coordinates as you encountered

- George, Catherine, Hazel, Susan, Linda, Richard or James, simply read it as it should be read: 1.24 E4

 

I just checked and of the David, Hazel and Zira Microsoft Speech API version 5 voices I have, David reads it as a scientific number, but Hazel and Zira both read 1.24 E4.

 

I will raise this with Microsoft and look to see if we can do anything with how we format the string, maybe we can put a comma in-between the pieces of information.

 

On Mon, Nov 19, 2018 at 9:47 PM Rick <softwarethatworks@...> wrote:

Hello NVDA List:

 

The other day I was reading an Excel  spreadsheet sent to me by a colleague. It had numeric values in column E. When reading these cells with Microsoft One Core voices (I am using Microsoft David) the cell name was read as an exponent to the power of 10. For instance, if the value 1.24 was present in cell E4, the speech produced, “1.24 time 10 to the power of 4” rather than 1.24 E4. This does not happen when using Espeak voices or SAPI 5 voices. Note, if the number in the cell is the result of a formula and not a direct value, the phrase, “has formula” is inserted between the number and the cell name, so it works as expected (i.e. 1.24 has formula E4).

 

Note: This does not happen using Narrator, since Narrator reads the cell name first.

 

I am running the latest released copy of NVDA, Office 365 desktop apps and Windows 10 Professional.

 

Rick

 


 

--

Quentin Christensen
Training and Support Manager

 

Official NVDA Training modules and expert certification now available: http://www.nvaccess.org/shop/

 

Facebook: http://www.facebook.com/NVAccess 
Twitter: @NVAccess 

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