RE: Creating/ reading Pivot Tables Excel

  • From: "Chip Orange" <Corange@xxxxxxxxxxxxxxx>
  • To: <jfw@xxxxxxxxxxxxx>
  • Date: Thu, 5 Jun 2008 10:07:06 -0400

Bill,

I think you could write a special program in VBA which could do it, all the 
information is there in the programming api; I don't know if jaws can do it or 
not.

I should go learn about jaws scripting to do some of these things.

Does anyone have an example pivot table that they could send me (which they 
cannot read with jaws)?

Chip






------------------------------

Chip Orange
Database Administrator
Florida Public Service Commission

Chip.Orange@xxxxxxxxxxxxxxx
(850) 413-6314

 (Any opinions expressed are solely those of the author and do not necessarily 
reflect those of the Florida Public Service Commission.)
 

> -----Original Message-----
> From: jfw-bounce@xxxxxxxxxxxxx 
> [mailto:jfw-bounce@xxxxxxxxxxxxx] On Behalf Of Bill Tipton
> Sent: Wednesday, June 04, 2008 5:14 PM
> To: jfw@xxxxxxxxxxxxx
> Subject: RE: Creating/ reading Pivot Tables Excel 
> 
>       Hi Artur and all,
> 
> How do you read a pivot table with the latest version of Jaws 
> in Excel 2003?
> 
> I have a Excel file where I move down to row 2 and Jaws says 
> pivot table.
> Then Jaws sort of freezes for a bit.
> Then I can't seem to be able to read anything from this view.
> Is there special Jaws keystrokes to read the pivot table?
> Thanks,
> 
> Bill
>  
> 
> -----Original Message-----
> From: jfw-bounce@xxxxxxxxxxxxx 
> [mailto:jfw-bounce@xxxxxxxxxxxxx] On Behalf Of Artur Räpp
> Sent: Saturday, May 31, 2008 8:41 AM
> To: jfw@xxxxxxxxxxxxx
> Subject: RE: Creating Pivot Tables Excel 2003
> 
> Hello Dave,
> 
> I am using Excel 2003.
> Excel 2003 shows 2 toolbars for Pivot Tables.
> On second pivot table toolbar are only 3 choices:
> Pivot Table field list - You can choose with arrow keys
> Pivot Table choices (row area, column area ...) you can 
> choose with arrow
> keys
> And add to button, you can activate this button with Enter key.
> You can move between these 3 choices with tab key.
> 
> In short
> 1. Open data menu, chose Pivot Tables, press Enter
> 2. Move with tab key to finish button and press space bar or 
> press ALT+F
> 3. Press alt key (activate menu bar)
> 4. Press ctrl+tab until the Pivot Table toolbar
> 5. Press tab key until 
> Show field list button. Ensure that this button is selected, JAWS says
> pressed. If not then press Enter.
> 6. Press again ctrl+tab to move on the toolbar with Pivot 
> Table field list
> (second pivot table toolbar) 
> 7. Choose in the first list box Pivot Table field, move with 
> tab key to
> second list box, choose Pivot Table area, move with tab key 
> to Add to button
> and press Enter to add this field to selected pivot table area.
> Press again tab key, choose next field for Pivot Table...
> 
> HTH
> Artur
> -----Original Message-----
> From: jfw-bounce@xxxxxxxxxxxxx 
> [mailto:jfw-bounce@xxxxxxxxxxxxx] On Behalf
> Of Dave 'SqueezeBox' Carlson
> Sent: Saturday, May 31, 2008 3:55 PM
> To: jfw@xxxxxxxxxxxxx
> Subject: Re: Creating Pivot Tables Excel 2003
> 
> Artur,
> 
> How do you navigate in the drag-and-drop dialog when creating 
> the pivot
> table?
> 
> Dave
> 
> ----- Original Message -----
> From: "Artur Räpp" <artur1248@xxxxxxxxxxx>
> To: <jfw@xxxxxxxxxxxxx>
> Sent: Saturday, May 31, 2008 1:13 AM
> Subject: RE: Creating Pivot Tables Excel 2003
> 
> 
> Hi,
> 
> This is quite easy.
> Open Pivot Table dialoog. Move to finiš button and press Enter.
> Then move to menu bar - press alt key. with ctrl+tab key move 
> to Pivot Table
> toolbar.
> 
> HTH
> Artur
> 
> -----Original Message-----
> From: jfw-bounce@xxxxxxxxxxxxx 
> [mailto:jfw-bounce@xxxxxxxxxxxxx] On Behalf
> Of Bill Tipton
> Sent: Tuesday, May 20, 2008 6:02 AM
> To: jfw@xxxxxxxxxxxxx
> Subject: Creating Pivot Tables Excel 2003
> 
> Hello all,
> 
> How do I create Pivot tables in Excel 2003 with Jaws 9.0.2152?
> 
> I have never attempted creating pivot tables in past and could use any
> pointers to help me.
> 
> Once I create the pivot table  how can I read the pivot table 
> with Jaws to
> verify I did it correctly?
> 
> Thank you.
> 
> Bill
> 
> Bill Tipton
> 
> Bill.tipton@xxxxxxxxxxx
> Blog: http://globaldialoguecenter.blogs.com/disabilities/
> 
> 
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/ Scripting 
> mailing list:
> http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx 
> To unsubscribe
> from this mailing list, send a message to 
> jfw-request@xxxxxxxxxxxxx with the
> word unsubscribe in the subject line.
> Archives located at: //www.freelists.org/archives/jfw
> 
> If you have any concerns about the list, post received from 
> the list, or the
> way the list is being run, do not post them to the list. 
> Rather contact the
> list owner at jfw-admins@xxxxxxxxxxxxxx
> 
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/
> Scripting mailing list: 
> http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to 
> jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the 
> subject line.
> Archives located at: //www.freelists.org/archives/jfw
> 
> If you have any concerns about the list, post received from 
> the list, or the
> 
> way the list is being run, do not post them to the list. 
> Rather contact the 
> list owner at jfw-admins@xxxxxxxxxxxxxx 
> 
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/
> Scripting mailing list:
> http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to
> jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the 
> subject line.
> Archives located at: //www.freelists.org/archives/jfw
> 
> If you have any concerns about the list, post received from 
> the list, or the
> way the list is being run, do not post them to the list. 
> Rather contact the
> list owner at jfw-admins@xxxxxxxxxxxxxx
> 
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/
> Scripting mailing list: 
> http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to 
> jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the 
> subject line.
> Archives located at: //www.freelists.org/archives/jfw
> 
> If you have any concerns about the list, post received from 
> the list, or the way the list is being run, do not post them to the
> list. Rather contact the list owner at jfw-admins@xxxxxxxxxxxxxx
> 
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/
> Scripting mailing list: 
> http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to 
> jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the 
> subject line.
> Archives located at: //www.freelists.org/archives/jfw
> 
> If you have any concerns about the list, post received from 
> the list, or the way the list is being run, do not post them 
> to the list. Rather contact the list owner at 
> jfw-admins@xxxxxxxxxxxxxx
> 
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list: 
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to 
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw

If you have any concerns about the list, post received from the list, or the 
way the list is being run, do not post them to the list. Rather contact the 
list owner at jfw-admins@xxxxxxxxxxxxxx

Other related posts: