The GW-Scripting list is a discussion list for information regarding the development and use of Window-Eyes scripts. Any subscriber of the GW-Scripting list has the ability to post on-topic messages.
From:
Amanda LeeSubject:
Re: MS/Excel 2007 and Headings that aren't really headingsDate:
Thu, Jun 16, 2011 1:53:51 pmcharset="iso-8859-1"
Ok, tried it but it errors out expecting a name. I didn't see anything in the manual under Office or an example but I think I got it working.
Thanks.
----- Original Message -----
From: Doug Geoffray
To: gw-scripting@gwmicro.com
Sent: Thursday, June 16, 2011 1:34 PM
Subject: Re: MS/Excel 2007 and Headings that aren't really headings
Amanda,
Just to be clear what Ralf suggested doesn't have to be done for each of the possible 100 columns. You could have as many columns as Excel supports, as long as they are on the same row this is all done once and only once per worksheet.
Doug
On 6/16/2011 1:25 PM, Amanda Lee wrote:
As i said for everytime you get a completely new version of certin spreadsheets, everything will have to be duplicated once again so if this spreadsheet is changed out hourly and one has to define each of 100 or more headings each time, this is very unproductive in terms of time spent performing one's work.
As I say the competition enables a workaround and in this instance they're getting the edge.
----- Original Message -----
From: Ralf Kefferpuetz
To: gw-scripting@gwmicro.com
Sent: Thursday, June 16, 2011 1:09 PM
Subject: RE: MS/Excel 2007 and Headings that aren't really headings
Amanda,
why not just use the column and row header hotkey alt-shift-h? It is a5 second task to define the cells in the first row as a header, as well as the cells in the first column as row headers.
Maybe I did not get your point?
Cheers,
Ralf
Ralf Kefferpuetz
Germany
From: Amanda Lee [mailto:amanda.e.lee@verizon.net]
Sent: Thursday, June 16, 2011 5:32 PM
To: gw-scripting@gwmicro.com
Subject: MS/Excel 2007 and Headings that aren't really headings
Oftentimes I find Excel spreadsheet applications with improperly coded headingss and some which are exported from other applications which result similarly.
Haven't been able to attend WE App development training or I'd make an attempt to develop something which would treat each column of the first ro of a spreadsheet row and speak it as one navigates through each column such as the WE Office hotkeys should do if there are proper Headings coded.
It would also treat the first column of every row the same and preferably have a toggle to activate this feature if desired as not all rows have headings in every spreadsheet.
The competition allows one to change their Verbosity settings which of course isn't pure but its a decent workaround. Still as always would rather rely upon Window-Eyes for it's responsiveness, stability and all of it's superior qualities.
Yes one can manually correct spreadsheets but this becomes very time-consuming when there's 100 or more columns and the spreadsheet is replaced often!
So if anyone has a little spare time, I know that there would be many who would be grateful for this one!
Ok, tried it but it errors out expecting a name. I didn't see anything in the manual under Office or an example but I think I got it working.
Thanks.
----- Original Message -----
From: Doug Geoffray
To: gw-scripting@gwmicro.com
Sent: Thursday, June 16, 2011 1:34 PM
Subject: Re: MS/Excel 2007 and Headings that aren't really headings
Amanda,
Just to be clear what Ralf suggested doesn't have to be done for each of the possible 100 columns. You could have as many columns as Excel supports, as long as they are on the same row this is all done once and only once per worksheet.
Doug
On 6/16/2011 1:25 PM, Amanda Lee wrote:
As i said for everytime you get a completely new version of certin spreadsheets, everything will have to be duplicated once again so if this spreadsheet is changed out hourly and one has to define each of 100 or more headings each time, this is very unproductive in terms of time spent performing one's work.
As I say the competition enables a workaround and in this instance they're getting the edge.
----- Original Message -----
From: Ralf Kefferpuetz
To: gw-scripting@gwmicro.com
Sent: Thursday, June 16, 2011 1:09 PM
Subject: RE: MS/Excel 2007 and Headings that aren't really headings
Amanda,
why not just use the column and row header hotkey alt-shift-h? It is a5 second task to define the cells in the first row as a header, as well as the cells in the first column as row headers.
Maybe I did not get your point?
Cheers,
Ralf
Ralf Kefferpuetz
Germany
From: Amanda Lee [mailto:amanda.e.lee@verizon.net]
Sent: Thursday, June 16, 2011 5:32 PM
To: gw-scripting@gwmicro.com
Subject: MS/Excel 2007 and Headings that aren't really headings
Oftentimes I find Excel spreadsheet applications with improperly coded headingss and some which are exported from other applications which result similarly.
Haven't been able to attend WE App development training or I'd make an attempt to develop something which would treat each column of the first ro of a spreadsheet row and speak it as one navigates through each column such as the WE Office hotkeys should do if there are proper Headings coded.
It would also treat the first column of every row the same and preferably have a toggle to activate this feature if desired as not all rows have headings in every spreadsheet.
The competition allows one to change their Verbosity settings which of course isn't pure but its a decent workaround. Still as always would rather rely upon Window-Eyes for it's responsiveness, stability and all of it's superior qualities.
Yes one can manually correct spreadsheets but this becomes very time-consuming when there's 100 or more columns and the spreadsheet is replaced often!
So if anyone has a little spare time, I know that there would be many who would be grateful for this one!
