GNOME Bugzilla – Bug 617603
OO Cell numbers not spoken
Last modified: 2010-05-06 07:39:22 UTC
In Calc, the empty cells are reported correct with there proper cell numbers 'A1 Cell' 'A2 Cell' etc. Spreadsheet cells with data are spoken without the cell number information which makes it hard for the blind. Orca reads populated cells as 'Data cell' without the cell number information. See attached debug log. OpenOffice 3.2 Orca 2.30 Ubuntu Lucid
Dear Sajjad, I think the reason for not having the coloumn/row information (a1 b1) automatically spoken when the cell has data, is that it might be hard for the user to hear the diffrence between actual content, and the co-ordinates. I believe that the information is still available if we stand on the cell that has data, and perform the 'Where Am I' function, orcaKey+enter, we get informed of which row/column we are on. Does this give the desired output for you? Thanks -Jon
Some users mentioned that having the column row information is a better idea as it gives them the location of the cursor. Perhaps, we can have an option to enable and disable this feature.
Hi, When you are in open office spreadsheet, press orcaKey+control+space, and the last tab should be the soffice tab. Maybe the "Speak spread sheet cell coordinates" checkbox is the one we are looking for, but on karmic it doesnt seem to do anything for me. Can you please confirm that this is true for you too? Havent looked at the code to see what is going on, will see if i can look into it this evening.
Hi Jon, The 'Speak spread sheet cell coordinates' checkbox does not have any effect on Lucid too. I just confirmed that. This would be a very good feature. We can have two options: ? 1. Speak all spread sheet cell coordinates (Both empty and populated). 2. Speak empty spread sheet cell coordinates. (for those who do not want the first option). Thanks!
I just double-checked (pardon the pun), that this checkbox and setting work as expected in OpenSolaris using both the shipping and the latest dev builds of OOo. I hear the cell numbers spoken just fine. I'll leave it to Jon to investigate the source of the problems in Ubuntu. However, any change to Orca in order to address this problem will need to be regression tested prior to being committed. Thanks!
Created attachment 160395 [details] [review] Seems to solve the issue for me. Attached patch seems to fix it for me. Also explains the other issue that Krishnakant described on the list (first letter not being spoken). :( Really feel like kicking something. There 'should' be a better way of detecting spreadsheet cells. Joanie, I dont think this one needs regression testing do you? :) -Jon
I agree about the kicking stuff. Shouting is therapeutic too. This is on my list of things to talk to the OOo a11y guys about. (Ways they can make our lives easier; not how to reduce stress through violence. <grin>) As for whether or not that one needs regression testing, having seen the solution, I'd agree with you. :-) Please feel free to commit this change to master as well as to the gnome-2-30 branch when you feel ready to do so. In my defense, since I couldn't reproduce the problem, I had no clue what you might need to do to fix it. And there has been at least one recent instance of your volunteering to commit code on behalf of someone else that I'd not even had the opportunity to glance at. If I've not seen it and/or it is not fully regression tested, I would ask that you do not commit it -- both as a sanity check, and because I'm working on several huge refactors designed to improve Orca's performance as well as make it way easier for others to contribute scripts, bug fixes, and new features. I appreciate your understanding. Once the transitional dust settles, I promise that I will be far less of a jerk about these sorts of things.
Hi Joanie, Commited to master and gnome-2-30. Sorry it was ment as a joke, it was not ment to be flippant, of course i would not commit unless it is obvious that it doesnt need regressioning. Thanks again. -Jon
*** Bug 607846 has been marked as a duplicate of this bug. ***