Excel and sort data


William
 

Hello,


1. Open any excel file

2. filled the worksheet with some data with the first row as the header

3. select all existing data by ctrl +a

4. go to data tab, press sort button

5. tab to any of the dropdown menu

6. press up or down arrow, everytime when I press up or down arrow, nvda will say list box  list xxxx

7. after I have selected one of the item and press tab, nvda will repeat the name of the current worksheet and says excel unavailable, followed by the next item.


Would you please comment on whether this is a nvda or excel problem? Thanks.

William


Quentin Christensen
 

I can replicate the first part - although just to confirm, the data itself is still read, it's just that you get the extra unnecessary list box list item information as well, correct?

For the next part, step 7, I couldn't replicate that, but maybe I was doing it slightly differently.

Would you be able to write it up at https://github.com/nvaccess/nvda/issues please?

Kind regards

Quentin.

On Tue, May 10, 2022 at 10:03 PM William <xsuper.sillyx@...> wrote:
Hello,


1. Open any excel file

2. filled the worksheet with some data with the first row as the header

3. select all existing data by ctrl +a

4. go to data tab, press sort button

5. tab to any of the dropdown menu

6. press up or down arrow, everytime when I press up or down arrow, nvda
will say list box  list xxxx

7. after I have selected one of the item and press tab, nvda will repeat
the name of the current worksheet and says excel unavailable, followed
by the next item.


Would you please comment on whether this is a nvda or excel problem? Thanks.

William












--
Quentin Christensen
Training and Support Manager


William
 

>I can replicate the first part - although just to confirm, the data itself is still read, it's just that you get the extra unnecessary list box list item information as well, correct?
Correct.


> For the next part, step 7, I couldn't replicate that, but maybe I was doing it slightly differently.
Hmm, interesting.



Quentin Christensen 於 11/5/2022 06:21 寫道:

I can replicate the first part - although just to confirm, the data itself is still read, it's just that you get the extra unnecessary list box list item information as well, correct?

For the next part, step 7, I couldn't replicate that, but maybe I was doing it slightly differently.

Would you be able to write it up at https://github.com/nvaccess/nvda/issues please?

Kind regards

Quentin.

On Tue, May 10, 2022 at 10:03 PM William <xsuper.sillyx@...> wrote:
Hello,


1. Open any excel file

2. filled the worksheet with some data with the first row as the header

3. select all existing data by ctrl +a

4. go to data tab, press sort button

5. tab to any of the dropdown menu

6. press up or down arrow, everytime when I press up or down arrow, nvda
will say list box  list xxxx

7. after I have selected one of the item and press tab, nvda will repeat
the name of the current worksheet and says excel unavailable, followed
by the next item.


Would you please comment on whether this is a nvda or excel problem? Thanks.

William












--
Quentin Christensen
Training and Support Manager


William
 

Hi quentin,

I have created an issue, https://github.com/nvaccess/nvda/issues/13682


Quentin Christensen 於 11/5/2022 06:21 寫道:

I can replicate the first part - although just to confirm, the data itself is still read, it's just that you get the extra unnecessary list box list item information as well, correct?

For the next part, step 7, I couldn't replicate that, but maybe I was doing it slightly differently.

Would you be able to write it up at https://github.com/nvaccess/nvda/issues please?

Kind regards

Quentin.

On Tue, May 10, 2022 at 10:03 PM William <xsuper.sillyx@...> wrote:
Hello,


1. Open any excel file

2. filled the worksheet with some data with the first row as the header

3. select all existing data by ctrl +a

4. go to data tab, press sort button

5. tab to any of the dropdown menu

6. press up or down arrow, everytime when I press up or down arrow, nvda
will say list box  list xxxx

7. after I have selected one of the item and press tab, nvda will repeat
the name of the current worksheet and says excel unavailable, followed
by the next item.


Would you please comment on whether this is a nvda or excel problem? Thanks.

William












--
Quentin Christensen
Training and Support Manager


Quentin Christensen
 

Thanks for that, the issue looks good.


On Wed, May 11, 2022 at 10:48 AM William <xsuper.sillyx@...> wrote:

Hi quentin,

I have created an issue, https://github.com/nvaccess/nvda/issues/13682


Quentin Christensen 於 11/5/2022 06:21 寫道:
I can replicate the first part - although just to confirm, the data itself is still read, it's just that you get the extra unnecessary list box list item information as well, correct?

For the next part, step 7, I couldn't replicate that, but maybe I was doing it slightly differently.

Would you be able to write it up at https://github.com/nvaccess/nvda/issues please?

Kind regards

Quentin.

On Tue, May 10, 2022 at 10:03 PM William <xsuper.sillyx@...> wrote:
Hello,


1. Open any excel file

2. filled the worksheet with some data with the first row as the header

3. select all existing data by ctrl +a

4. go to data tab, press sort button

5. tab to any of the dropdown menu

6. press up or down arrow, everytime when I press up or down arrow, nvda
will say list box  list xxxx

7. after I have selected one of the item and press tab, nvda will repeat
the name of the current worksheet and says excel unavailable, followed
by the next item.


Would you please comment on whether this is a nvda or excel problem? Thanks.

William












--
Quentin Christensen
Training and Support Manager



--
Quentin Christensen
Training and Support Manager


Cearbhall O'Meadhra
 

Quentin and William,

 

Step 7 describes what I experience every time when sorting a document in excel.

I am using Office 2016 in Windows 10 and latest NVDA – all latest versions.

 

This is a noisy and unnecessary babble of information. I always press the left alt key to silence it so that I can actually hear the options in the next drop down box.

 

I can also replicate this when I move away from the spreadsheet to another application and swing back again with alt+tab. This generates the full text that William describes.

 

The elements I hear are:

1.The Sheet title followed by the addition of "dash Excel"

2. Then "unavailable"

3.Then "Sort dialog, Sort widnow"

4. Then "Data Grid"

5. Then "Sort data Item 1 of 1"

6. Then "Order combo box, smallest to largest collapsed"

 

If I do not change the three boxes, "order by" "sort on" or "order", I do not get this echo as I tab from combo box to combo box.

However, as soon as I activate any one of these  combo boxes, I get the full whack of all six elements described above when I tab away from the combo box.

 

If I keep the alt key pressed when I press alt +tab to return to the Excel window from another application window, I hear the sheet title plus "dash Excel" but no mention of "Unavailable". However, when I let go the alt key, I then get the repetition of the Title and all six parts of the announcement.

 

This is an awful lot of verbiage and it has no value to me as a user.

 

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 Quentin Christensen
Sent: Tuesday, May 10, 2022 11:22 PM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Excel and sort data

 

I can replicate the first part - although just to confirm, the data itself is still read, it's just that you get the extra unnecessary list box list item information as well, correct?

 

For the next part, step 7, I couldn't replicate that, but maybe I was doing it slightly differently.

 

Would you be able to write it up at https://github.com/nvaccess/nvda/issues please?

 

Kind regards

 

Quentin.

 

On Tue, May 10, 2022 at 10:03 PM William <xsuper.sillyx@...> wrote:

Hello,


1. Open any excel file

2. filled the worksheet with some data with the first row as the header

3. select all existing data by ctrl +a

4. go to data tab, press sort button

5. tab to any of the dropdown menu

6. press up or down arrow, every time when I press up or down arrow, nvda
will say list box  list xxxx

7. after I have selected one of the item and press tab, nvda will repeat
the name of the current worksheet and says excel unavailable, followed
by the next item.


Would you please comment on whether this is a nvda or excel problem? Thanks.

William










 

--

Quentin Christensen
Training and Support Manager

 




Avast logo

This email has been checked for viruses by Avast antivirus software.
www.avast.com



William
 

Cearbhall, I think you can also add your comment to the github discussion which I have posted earlier.


Cearbhall O'Meadhra 於 11/5/2022 17:44 寫道:

Quentin and William,

 

Step 7 describes what I experience every time when sorting a document in excel.

I am using Office 2016 in Windows 10 and latest NVDA – all latest versions.

 

This is a noisy and unnecessary babble of information. I always press the left alt key to silence it so that I can actually hear the options in the next drop down box.

 

I can also replicate this when I move away from the spreadsheet to another application and swing back again with alt+tab. This generates the full text that William describes.

 

The elements I hear are:

1.The Sheet title followed by the addition of "dash Excel"

2. Then "unavailable"

3.Then "Sort dialog, Sort widnow"

4. Then "Data Grid"

5. Then "Sort data Item 1 of 1"

6. Then "Order combo box, smallest to largest collapsed"

 

If I do not change the three boxes, "order by" "sort on" or "order", I do not get this echo as I tab from combo box to combo box.

However, as soon as I activate any one of these  combo boxes, I get the full whack of all six elements described above when I tab away from the combo box.

 

If I keep the alt key pressed when I press alt +tab to return to the Excel window from another application window, I hear the sheet title plus "dash Excel" but no mention of "Unavailable". However, when I let go the alt key, I then get the repetition of the Title and all six parts of the announcement.

 

This is an awful lot of verbiage and it has no value to me as a user.

 

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 Quentin Christensen
Sent: Tuesday, May 10, 2022 11:22 PM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Excel and sort data

 

I can replicate the first part - although just to confirm, the data itself is still read, it's just that you get the extra unnecessary list box list item information as well, correct?

 

For the next part, step 7, I couldn't replicate that, but maybe I was doing it slightly differently.

 

Would you be able to write it up at https://github.com/nvaccess/nvda/issues please?

 

Kind regards

 

Quentin.

 

On Tue, May 10, 2022 at 10:03 PM William <xsuper.sillyx@...> wrote:

Hello,


1. Open any excel file

2. filled the worksheet with some data with the first row as the header

3. select all existing data by ctrl +a

4. go to data tab, press sort button

5. tab to any of the dropdown menu

6. press up or down arrow, every time when I press up or down arrow, nvda
will say list box  list xxxx

7. after I have selected one of the item and press tab, nvda will repeat
the name of the current worksheet and says excel unavailable, followed
by the next item.


Would you please comment on whether this is a nvda or excel problem? Thanks.

William










 

--

Quentin Christensen
Training and Support Manager

 




Avast logo

This email has been checked for viruses by Avast antivirus software.
www.avast.com



Cearbhall O'Meadhra
 

William

 

I would be happy to add my experience to your submission. What is the GitHub code for your entry?

 

 

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 William
Sent: Wednesday, May 11, 2022 11:17 AM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Excel and sort data

 

Cearbhall, I think you can also add your comment to the github discussion which I have posted earlier.

 

Cearbhall O'Meadhra 11/5/2022 17:44 寫道:

Quentin and William,

 

Step 7 describes what I experience every time when sorting a document in excel.

I am using Office 2016 in Windows 10 and latest NVDA – all latest versions.

 

This is a noisy and unnecessary babble of information. I always press the left alt key to silence it so that I can actually hear the options in the next drop down box.

 

I can also replicate this when I move away from the spreadsheet to another application and swing back again with alt+tab. This generates the full text that William describes.

 

The elements I hear are:

1.The Sheet title followed by the addition of "dash Excel"

2. Then "unavailable"

3.Then "Sort dialog, Sort widnow"

4. Then "Data Grid"

5. Then "Sort data Item 1 of 1"

6. Then "Order combo box, smallest to largest collapsed"

 

If I do not change the three boxes, "order by" "sort on" or "order", I do not get this echo as I tab from combo box to combo box.

However, as soon as I activate any one of these  combo boxes, I get the full whack of all six elements described above when I tab away from the combo box.

 

If I keep the alt key pressed when I press alt +tab to return to the Excel window from another application window, I hear the sheet title plus "dash Excel" but no mention of "Unavailable". However, when I let go the alt key, I then get the repetition of the Title and all six parts of the announcement.

 

This is an awful lot of verbiage and it has no value to me as a user.

 

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 Quentin Christensen
Sent: Tuesday, May 10, 2022 11:22 PM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Excel and sort data

 

I can replicate the first part - although just to confirm, the data itself is still read, it's just that you get the extra unnecessary list box list item information as well, correct?

 

For the next part, step 7, I couldn't replicate that, but maybe I was doing it slightly differently.

 

Would you be able to write it up at https://github.com/nvaccess/nvda/issues please?

 

Kind regards

 

Quentin.

 

On Tue, May 10, 2022 at 10:03 PM William <xsuper.sillyx@...> wrote:

Hello,


1. Open any excel file

2. filled the worksheet with some data with the first row as the header

3. select all existing data by ctrl +a

4. go to data tab, press sort button

5. tab to any of the dropdown menu

6. press up or down arrow, every time when I press up or down arrow, nvda
will say list box  list xxxx

7. after I have selected one of the item and press tab, nvda will repeat
the name of the current worksheet and says excel unavailable, followed
by the next item.


Would you please comment on whether this is a nvda or excel problem? Thanks.

William








 

 

--

Quentin Christensen
Training and Support Manager

 


William
 

Hi, please see here https://github.com/nvaccess/nvda/issues/13682

Cearbhall O'Meadhra 於 11/5/2022 21:13 寫道:

William

 

I would be happy to add my experience to your submission. What is the GitHub code for your entry?

 

 

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 William
Sent: Wednesday, May 11, 2022 11:17 AM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Excel and sort data

 

Cearbhall, I think you can also add your comment to the github discussion which I have posted earlier.

 

Cearbhall O'Meadhra 11/5/2022 17:44 寫道:

Quentin and William,

 

Step 7 describes what I experience every time when sorting a document in excel.

I am using Office 2016 in Windows 10 and latest NVDA – all latest versions.

 

This is a noisy and unnecessary babble of information. I always press the left alt key to silence it so that I can actually hear the options in the next drop down box.

 

I can also replicate this when I move away from the spreadsheet to another application and swing back again with alt+tab. This generates the full text that William describes.

 

The elements I hear are:

1.The Sheet title followed by the addition of "dash Excel"

2. Then "unavailable"

3.Then "Sort dialog, Sort widnow"

4. Then "Data Grid"

5. Then "Sort data Item 1 of 1"

6. Then "Order combo box, smallest to largest collapsed"

 

If I do not change the three boxes, "order by" "sort on" or "order", I do not get this echo as I tab from combo box to combo box.

However, as soon as I activate any one of these  combo boxes, I get the full whack of all six elements described above when I tab away from the combo box.

 

If I keep the alt key pressed when I press alt +tab to return to the Excel window from another application window, I hear the sheet title plus "dash Excel" but no mention of "Unavailable". However, when I let go the alt key, I then get the repetition of the Title and all six parts of the announcement.

 

This is an awful lot of verbiage and it has no value to me as a user.

 

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 Quentin Christensen
Sent: Tuesday, May 10, 2022 11:22 PM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Excel and sort data

 

I can replicate the first part - although just to confirm, the data itself is still read, it's just that you get the extra unnecessary list box list item information as well, correct?

 

For the next part, step 7, I couldn't replicate that, but maybe I was doing it slightly differently.

 

Would you be able to write it up at https://github.com/nvaccess/nvda/issues please?

 

Kind regards

 

Quentin.

 

On Tue, May 10, 2022 at 10:03 PM William <xsuper.sillyx@...> wrote:

Hello,


1. Open any excel file

2. filled the worksheet with some data with the first row as the header

3. select all existing data by ctrl +a

4. go to data tab, press sort button

5. tab to any of the dropdown menu

6. press up or down arrow, every time when I press up or down arrow, nvda
will say list box  list xxxx

7. after I have selected one of the item and press tab, nvda will repeat
the name of the current worksheet and says excel unavailable, followed
by the next item.


Would you please comment on whether this is a nvda or excel problem? Thanks.

William








 

 

--

Quentin Christensen
Training and Support Manager