Reported by sumandogra on 2013-03-04 11:23
If there are groups of data in a sheet separated by blank rows and columns, we can select a set of data that can be defined under a name range with CTRL+A. This selection is not announced by NVDA.
Steps to reproduce:
Open a workbook that has groups of data arranged and separated by blank rows and columns.
Go to a set of data that is separate from any set of data on the sheet and press CTRL+A.
No indication is given by NVDA that the set of data has been selected.
for an example pls see the attached sheet.
Attachment Example sheet for different sets of data.xlsx added by sumandogra on 2013-03-04 11:28
just an example sheet to show the presence of different sets of data present in an excel sheet.
Comment 2 by vrdhn on 2013-09-18 11:41
The Fix of this is to add 'Control+A' to the list of selection change gestures in excel.py.
The changes can be picked from:
Link to DIFF: https://bitbucket.org/manish_agrawal/nvda/commits/413c63a1bda00107c1c2522bf2728afce49a3476#chg-source/NVDAObjects/window/excel.py
Comment 4 by Michael Curran <mick@... on 2013-10-01 06:48
```CommitTicketReference repository="" revision="729545897dbc0d0ab2d1e117e6ada2431843f4cc"
Excel worksheet NVDAObject: control+a should be treeted as a selection change. Re #3043
Comment 5 by Michael Curran <mick@... on 2013-10-01 06:48
```CommitTicketReference repository="" revision="3926b55fb42696134036a12500f46a9494873fd0"
Merge branch 't3043' into next. Incubates #3043
Added labels: incubating
Comment 6 by mdcurran on 2013-10-01 06:49
Milestone changed from None to next
Comment 7 by Michael Curran <mick@... on 2013-10-15 09:43
```CommitTicketReference repository="" revision="2d22641630e4fe0cf94f65c3e81159b658039834"
Merge branch 't3043'. Fixes #3043
Removed labels: incubating
Comment 8 by mdcurran on 2013-10-15 09:43
Milestone changed from next to 2013.3
Comment 9 by ragb on 2013-11-24 12:25
Just noticed a small problem with the approach taken on this ticket. When office is in portuguese (probably other languages too) the key bindings are changed: control+a stands for open and control+t for select-all. We may solve this using a locale gestures file, however, the control+a should be unbound somehow.
Shall I open another ticket? (don't think this blocks the 2013.3 release).
Comment 10 by jteh on 2013-11-25 02:16
Damn. I was always worried about something like this happening. Binding scripts to keys like this is ugly, but there really isn't a reliable event we can use here. Using locale bindings will work for most, but it breaks if the user has different NVDA and Ms Office languages.
Btw, you can unbind a key using a locale gesture map (just specify the script as None), so that isn't a problem.
Please do open another ticket for this and mention that it was spun off this one. Thanks.