Attachment Excel2013_Pivot_Practice.xlsx added by sumandogra on 2015-07-28 11:01
Description:
Update:
File added from Trac
Excel2013_Pivot_Practice.xlsx

Ok I think I understand this issue. When you create a pivot table, the table is empty. There is a pivot table toolbar where you can select which values should be displayed in columns and which ones should be displayed in rows. But that toolbar is only accessible with mouse navigation. Not in the ribbon menu and not with usual keyboard navigation. so if you are not familiar with mouse navigation, you cannot really create a pivot table. This is also reproducible in MS Excel 2010 and Excel 2016 and 365. Honnestly I think this is bad implementation from Microsoft side. @michaelDCurran, @Qchristensen if so, could you please report this to Microsoft? Thank you very much.

In Excel 2010 ad least you can access this toolbar by pressing f6. The controls that are used to select which items should be displayed in the table are buttons whereas they are check boxes, but the checked one are written in bold, which can be checked in the screen review. Not very easy and efficient, but definitely doable.

I've done the following:

1. Download the attachment from this ticket called Excel2013_Pivot_Practice.xlsx
2. Opened it in Excel 2010 32-bit on Windows 7
3. From the Insert ribbon I've chosen table and the pivot table
4. I haven't changed anything in the next window just pressed ok.
5. Then in the newly opened sheet I've pressed f6 and NVDA announced toolbar in which I can navigate with tab and arrows.
   I am not sure why your results are different.

Ah one more thing you have to be in the range included in the pivot table for this toolbar to be reachable with a f6 key, otherwise you cannot move focus there. So in the attached sheet if your create pivot table and then move to the f1 which is outside of the included range f6 would cycle between ribbon, status bar ant the sheet itself.

Ah ok this is interesting. Indeed it works with f6 if you are in the right range. I wonder if NVDA could Report when you enter or leave the Pivot table area?

Pivots are working great in Excel 2013 and Excel 365. The trick is to start at cell a3. This is always the first cell in a pivot. Then hit F6 and you will be placed in a list of available fields (column headers from the original selected range). Here you cann arrow down the list. If you found your field right click or hit the application key and choose from the available options to place the field as row, column, value etc. From my point of view, and I use pivots all day long there is no issue with NVDA and pivots..

Well, if you know that it always starts in a3 it's ok. But for new users I guess this is not obvious. So an announcement that that the Cursor entered the Pivot area would be actually a desired behavior. And this is also the case for autofilter or Dropdown lists.

I believe the question is how it is communicated to the sighted users. I will heck with someone sighted later today.

Maybe @Qchristensen could give us some indications on how is the pivot area displayed for sighted people.

I've looked with someone sighted and:

• when we are outside of the range included in the table the toolbar in which we can modify pivot table is visually hidden and on top of the range of cells included in it there is the message saying that in order to work with the pivot table you have to be inside that area.
• when focus is in the included area the toolbar is obviously visible and the displayed message informs us that we have to select a field in it.

Therefore I believe that this issue should be closed. Basic knowledge of the used program, in this case Excel is simply required to work with the pivot tables. Having said that this info should be included in the Microsoft Excel With NVDA module. @Qchristensen Any chance for expanding a section about pivot tables there?

@lukaszgo1 maybe I am not understanding correctly the initial description of the isue. But I think the author was requesting exactly this, namely that NVDA gives feedback when entering or leaving the range. In this case it could read the message which is displayed for the sighted people. At least we should get the same information as sighted people. But this is only my opinion.

I've looked further, and we are getting the message, ad least in Excel 2010 it can be accessed in screen review, and when pressing NVDA +numpad 5 the cell on top which it is displayed is properly reported.

In Excel 365 screen review doesn't work.
I see two ways in which the announcement can be implemented however none of the looks really good to me.

1. Announce 'in the pivot table' for every cell which is the part of the pivot table - very verbose.
2. announce the start or the end of the pivot table when moving with the arrow keys to the cells included in it - not very elegant what if user moves to the cell in the middle with ctrl+g for example.

I haven't looked at Pivot Tables much in awhile. I will review and update the Excel module this year and have made a note to look at incorporating using Pivot Tables when I do.

Using UIA for Microsoft Excel solves this issue, but I guess only for MS Office 365. This should be kept open maybe someone can implement the same solution for object model as well.