From:

 Richard G Applegate

Subject:

 RE: MS/Excel 2007 and Headings that aren't really headings

Date:

 Thu, Jun 16, 2011 7:30:49 pm

charset="us-ascii"

Hi Amanda:

Is the reconfiguring of the new spreadsheets something that Aaron's
HotSpot app can do for you?





From: Doug Geoffray [mailto:geoffray@gwmicro.com]
Sent: Thursday, June 16, 2011 2:04 PM
To: gw-scripting@gwmicro.com
Subject: Re: MS/Excel 2007 and Headings that aren't really headings



Amanda,

In the manual go to the "Window-Eyes Features" node. Under that you'll find
Working with "Microsoft Excel." Under that you'll see "Headers and Totals".
I believe this describes the steps you are needing.

For the record, I also didn't know where in the manual this was described so
while in the manual I just pressed alt-s for the search and typed "excel"
and hit enter. I than tabbed until I got to the listview of results and
arrowed down until I got to "Headers and Totals" (for me this took 2 down
arrows). I hit enter on this and pressed f6 to get the to content and
there I was.

Doug

On 6/16/2011 1:53 PM, Amanda Lee wrote:

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!

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.901 / Virus Database: 271.1.1/3708 - Release Date: 06/16/11
14:34:00