Re: Setting up Rows and Columns to be read by JFW
- From: "Dave Carlson" <dgcarlson@xxxxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Fri, 7 May 2010 14:12:52 -0700
Bob,
Yes, true enough. However in my job, I received spreadsheets pushed out to a
large number of sales engineers, and each time it arrives it's not going to
have that nice feature included. So I have to use the old method of either
using a JSI file previously created, or assign the titles on-the-fly.
I agree that the use of Names is much more elegant and transportable. I also
like the summary feature in Excel. Have you used that?
Dave
From: Bob Verity
To: jfw@xxxxxxxxxxxxx
Sent: Friday, May 07, 2010 14:02
Subject: Re: Setting up Rows and Columns to be read by JFW
An advantage of setting up the row and column title reading as I described is
that if you send the workbook to someone else the title reading is already set
up and they have to do nothing.
----- Original Message -----
From: Bob Verity
To: jfw@xxxxxxxxxxxxx
Sent: Friday, May 07, 2010 3:23 PM
Subject: Re: Setting up Rows and Columns to be read by JFW
Using the JAWS verbosity menu is not the prefered way to have row and
column titles spoken. You can find a detailed explaination of the better way
to do this in the JAWS help for Excel.
Here is how it should be done.
In the Excel INSERT menu choose name and then define and enter this with
your cursor in cell A6:
Title.a6.W17.X
Where X is the number of the worksheet in the work book.
There are other options when there are multiple regions on a worksheet.
In the above example note the capital in Title.
HTH
----- Original Message -----
From: Lafond, Eileen
To: jfw@xxxxxxxxxxxxx
Sent: Friday, May 07, 2010 12:16 PM
Subject: RE: Setting up Rows and Columns to be read by JFW
That was the first thing that I tried and it said that these were already
defined, yet it was not working. I tried to manually do it again to get it
started and that did not work. Is there a command or something to make it do
what is already defined?
Thanks,
Eileen La fond
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
Behalf Of Lisle, Ted (CHFS DMS)
Sent: Friday, May 07, 2010 9:59 AM
To: jfw@xxxxxxxxxxxxx
Cc: gbmagoo@xxxxxxxxxxx
Subject: RE: Setting up Rows and Columns to be read by JFW
If you mean what I think you mean, you set using the first row and the
first column. Hitting the spacebar will either define a value, or supersede
what is already there. The headings are row values to column range, and column
values to row range.
Ted
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
Behalf Of Lafond, Eileen
Sent: Friday, May 07, 2010 12:52 PM
To: jfw@xxxxxxxxxxxxx
Cc: gbmagoo@xxxxxxxxxxx
Subject: Setting up Rows and Columns to be read by JFW
Hi,
I had a computer crash at work and I am trying to get everything set
back up. The problem that I have right now is setting the rows and columns for
my timesheet to be read as I go across and down the spreadsheet entering my
hours.
In the past, I went into the insert v window and went to Title Reading
and set it according to what I thought was correct for reading the columns from
A6 to W6. For the rows I wanted the A6 through A17 to be read as I went across
and filled in the hours.
I have been able to get this to work in the past, but now I have gotten
myself very confused and it seems that everything that I try does not work.
Can someone tell me the exact items that I need to change to achieve
the above settings?
I am using JFW version 11 and Excel version 2003.
Thanks for any help,
Eileen La Fond
Work phone: (206 386-0011
email: eileen.lafond@xxxxxxxxxxx
Other related posts:
