Date   

Re: training modules

Carol Smith
 

Glad to help.  I even went back and found more material than I saw when I first started with the tutorials.  I'm not saying they weren't there, but at least, they were not something I would have used at the time.  It works to work together.  Take care.

Carol

On 6/8/2017 3:36 PM, Bob Hicks wrote:

Tnx kCarol.  I tried that earlier and it didn’t work.  But, I just followed your instructions, and, wah lah it worked!  My typing stinks!  tia

 

Have a great day!

 

Bob Hicks

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Carol Smith via Groups.Io
Sent: Thursday, June 08, 2017 3:24 PM
To: main@jfw.groups.io
Subject: Re: training modules

 

If you open the FS reader, you should be able to access tutorials from there by pressing control+J.  There are links to tutorials.  If they are not already downloaded and placed in the appropriate place, the program will do this for you.  These are in Daisy format and you can use control+P to toggle play and pause. 

This is a global key command, so as long as the reader is open, it takes presidence over other programs using that key command.  This makes it very handy if you want to practice what you are reading in an open program.  This information should be enough to get you started. 

Carol

On 6/8/2017 2:46 PM, Bob Hicks wrote:

I downloaded my version of Jaws 18.  How do I git the training modules into FS reader?  tia

 

Have a great day!

 

Bob Hicks

 

 



Re: mail app on windows 10, very slow when loading pictures within messages

 

As for Jaws starting automatically you can set this in Jaws Settings, press Jaws Key+J, then Options, then Basics then Alt+J or arrow to "Automatically Start Jaws...

Here you can select to have Jaws start automatically "Always" or "Never" and you can check a checkbox so this happens for all users or just yourself. I guess if you are the only person who has a login on this PC it doesn't matter, just set it to Always.

Can you provide the specs of your PC? It may take 5 or 6 seconds or maybe even 8 to come up, but it shouldn't take 30 seconds.

 

Regards,

Sieghard

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Jessica D
Sent: Thursday, June 08, 2017 10:23 AM
To: main@jfw.groups.io
Subject: mail app on windows 10, very slow when loading pictures within messages

 

Hi,

I got an email with graphics in it.

When I opened the email, JAWS nearly stalled.

It barely talked.

 

Also, when I’m asked to restart my computer, after 40 minutes, it takes 2 or 3 restarts to actually do what its supposed to.

Jaws doesn’t start automatically for me, and takes about 3 minutes to come up, when I click the icon after restarting my machine.

What can I do to fix this?

 

 

Sent from Mail for Windows 10

 


Re: training modules

Bob Hicks
 

Hard to believe I started on JAWS 3.1 isn’t it!

 

Have a great day!

 

Bob Hicks

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Carol Smith via Groups.Io
Sent: Thursday, June 08, 2017 3:24 PM
To: main@jfw.groups.io
Subject: Re: training modules

 

If you open the FS reader, you should be able to access tutorials from there by pressing control+J.  There are links to tutorials.  If they are not already downloaded and placed in the appropriate place, the program will do this for you.  These are in Daisy format and you can use control+P to toggle play and pause. 

This is a global key command, so as long as the reader is open, it takes presidence over other programs using that key command.  This makes it very handy if you want to practice what you are reading in an open program.  This information should be enough to get you started. 

Carol

On 6/8/2017 2:46 PM, Bob Hicks wrote:

I downloaded my version of Jaws 18.  How do I git the training modules into FS reader?  tia

 

Have a great day!

 

Bob Hicks

 

 


Re: training modules

Bob Hicks
 

Tnx kCarol.  I tried that earlier and it didn’t work.  But, I just followed your instructions, and, wah lah it worked!  My typing stinks!  tia

 

Have a great day!

 

Bob Hicks

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Carol Smith via Groups.Io
Sent: Thursday, June 08, 2017 3:24 PM
To: main@jfw.groups.io
Subject: Re: training modules

 

If you open the FS reader, you should be able to access tutorials from there by pressing control+J.  There are links to tutorials.  If they are not already downloaded and placed in the appropriate place, the program will do this for you.  These are in Daisy format and you can use control+P to toggle play and pause. 

This is a global key command, so as long as the reader is open, it takes presidence over other programs using that key command.  This makes it very handy if you want to practice what you are reading in an open program.  This information should be enough to get you started. 

Carol

On 6/8/2017 2:46 PM, Bob Hicks wrote:

I downloaded my version of Jaws 18.  How do I git the training modules into FS reader?  tia

 

Have a great day!

 

Bob Hicks

 

 


Re: Outlook Express with windows 10?

Gene Stevens
 

I have been using Outlook Express on Windows 10 for a couple of weeks now with no issues. The download page is below. The spell checker for it is also there.

https://www.jaws-users.com/programs/

----- Original Message -----
From: "Ann Byrne" <annakb@sbcglobal.net>
To: <main@jfw.groups.io>
Sent: Thursday, June 8, 2017 2:40 PM
Subject: Outlook Express with windows 10?


Is it possible to use Outlook Express with windows 10? If so, may I have an address for downloading it?

thanks,
Ann



Re: training modules

Lisle, Ted (CHFS DMS)
 

I always access training material from JAWS itself, listed under Help, but it works pretty much as descried below.  Additional training modules, not included in the JAWS package, are available FROM THEIR site.  Most contain both text and spoken audio.  They’ve always been strong, and easy to follow.

 

Ted

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Carol Smith via Groups.Io
Sent: Thursday, June 08, 2017 3:24 PM
To: main@jfw.groups.io
Subject: Re: training modules

 

If you open the FS reader, you should be able to access tutorials from there by pressing control+J.  There are links to tutorials.  If they are not already downloaded and placed in the appropriate place, the program will do this for you.  These are in Daisy format and you can use control+P to toggle play and pause. 

This is a global key command, so as long as the reader is open, it takes presidence over other programs using that key command.  This makes it very handy if you want to practice what you are reading in an open program.  This information should be enough to get you started. 

Carol

On 6/8/2017 2:46 PM, Bob Hicks wrote:

I downloaded my version of Jaws 18.  How do I git the training modules into FS reader?  tia

 

Have a great day!

 

Bob Hicks

 

 


Re: training modules

Carol Smith
 

If you open the FS reader, you should be able to access tutorials from there by pressing control+J.  There are links to tutorials.  If they are not already downloaded and placed in the appropriate place, the program will do this for you.  These are in Daisy format and you can use control+P to toggle play and pause. 

This is a global key command, so as long as the reader is open, it takes presidence over other programs using that key command.  This makes it very handy if you want to practice what you are reading in an open program.  This information should be enough to get you started. 

Carol


On 6/8/2017 2:46 PM, Bob Hicks wrote:

I downloaded my version of Jaws 18.  How do I git the training modules into FS reader?  tia

 

Have a great day!

 

Bob Hicks

 



JAWS says command keys, and other nonsense

Jessica D <jldail13@...>
 

                      Hi,

I’m using JAWS 18, with Windows 10, 1607.

 

I’m getting a lot of extraneous info from JAWS.

When I go to my desktop, for example, I hear, “Windows D desktop.”

 

Can I stop JAWS from saying this extra stuff?

Thanks,

Jessica

 

 

Sent from Mail for Windows 10

 


training modules

Bob Hicks
 

I downloaded my version of Jaws 18.  How do I git the training modules into FS reader?  tia

 

Have a great day!

 

Bob Hicks

 


Outlook Express with windows 10?

Ann Byrne
 

Is it possible to use Outlook Express with windows 10? If so, may I have an address for downloading it?

thanks,
Ann


To listen to the entire paragraph in a post or email I would just use the JAWS or insert key and press the arrow down. Now all I hear is "arrow down"What have I fouled up in the settings?

David & his pack of dogs
 

 


mail app on windows 10, very slow when loading pictures within messages

Jessica D <jldail13@...>
 

Hi,

I got an email with graphics in it.

When I opened the email, JAWS nearly stalled.

It barely talked.

 

Also, when I’m asked to restart my computer, after 40 minutes, it takes 2 or 3 restarts to actually do what its supposed to.

Jaws doesn’t start automatically for me, and takes about 3 minutes to come up, when I click the icon after restarting my machine.

What can I do to fix this?

 

 

Sent from Mail for Windows 10

 


Jaws and speaking Excel headings

Carol Smith
 

Hi,

My spreadsheet was set up by someone else. The column headers begin on row 2 and go through row 4. Each line has one word. I.E., A2 is Company and A3 is Symbol. there is F2 with Date of F3 original F4 Purchase.

There are ten columns and the actual data begins on row 6. The spreadsheet name is in A1.

Using the information that was posted yesterday with how to get columns headings to speak, my spreadsheet only said "title" when I arrowed through the cells. I am sure I may have done something wrong, but I am thinking it had more to do with my headers being broken into multiple rows.

Is there a way I can either combine the information on each column so that each word still remains in three rows, but only takes up one physical cell, or is there a way to get all three rows spoken with the column identification. I hope this makes sense. I don't want to change the physical appearance of the printed sheet. Thanks for any help. If you need further clarification, please email me off list.

Carol
carollablady@aol.com


Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Carol Smith
 

Thanks. I did find this one in a previous message, of course, after I wrote my last one, grin.

Carol

On 6/8/2017 12:13 PM, Bissett, Tom wrote:
To hear coordinates press JawsKey and C together
Regards
Tom Bisset
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Carol Smith via Groups.Io
Sent: Thursday, June 08, 2017 11:24 AM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

When going through lots of numeric data, my preference is to have only cell content spoken. Does Jaws have a shortcut key for reading just coordinates? This way, I can hear only the data I need and can get related coordinates when I need them. Thanks.

Carol
On 6/8/2017 9:54 AM, Shannon wrote:
Ted,
Precisely!
My preference would be to hear;
A81 "Thursday, June 8, 2017,
G79 "Five, has formula,."

Sounds like a simple enough thing to do but obviously it is not. Smile
Shannon -----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Lisle, Ted (CHFS DMS)
Sent: Thursday, June 8, 2017 8:18 AM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Just for fun, I flipped to a little sheet I use here to track pharmacy calls. The first column reads "Thursday, June 8, 2017, A81." succeeding columns list calls, each designated with a 1. At the end of the day, I enter a simple sum; so yesterday's total reads "Five, has formula, G79."

Ted

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Carol Smith via Groups.Io
Sent: Thursday, June 08, 2017 8:40 AM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Actually, I never gave it any thought, but with Window-Eyes and Excel,
the coordinates are spoken first, the contents next and information
about the dell, money, date, etc. are spoken afterward.

Carol


On 6/8/2017 7:50 AM, Lisle, Ted (CHFS DMS) wrote:
I got my first real spreadsheet training around 1990. Over the years, I used Artic Business Vision, VOS, ASAP, and, of course, JAWS. Far as I can remember, cells have always been announced the same way; guess I never gave it much thought until now.

Ted

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Shannon
Sent: Wednesday, June 07, 2017 4:41 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Mario,
After doing all of this and rearranging a few lines.
I deleted the entire script entry.
Guess what happened?
Not a thing!
Without that stuff in there it still says the contents and then the coordinates.
So the answer must be tied to something else.
Shannon
P.s.
I copied all of the jaws excel script into note pad for back up before I did anything.
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Mario
Sent: Wednesday, June 7, 2017 3:20 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

yep, same issue I'm having.

at the end of one of Tom's replys, he mentioned about a setting in JAWS.
I wonder if he meant the Cell verbosity, which in my case, it's set
to contents and coordinates. but changing it to contents only is not
practical. these are the only choices for cell verbosity. maybe
there's another setting to adjust?


-------- Original Message --------
From: Shannon [mailto:shannon@bartchroofing.com]
Sent: Wednesday, Jun 7, 2017 4:10 PM EST
To: main@jfw.groups.io
Subject: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

Hi all,
I gave up intrying to over think it and just did a cut and paste.
At first it would not save. I got some sort of error.
Then I read Joseph's message below and learned about compialing. I
did the whole thing over cut and pasted what Tom provided.
I did the ctrl S and I was told it compiled.
But it still is reading the contents and then the coordinates.
It didn't change the behavior.
Here is what I pasted.
Script SayCell()
If OnSpreadSheet()
&& !OnFormulaBar() then
SayCell()
if CellReadingVerbosity() == readCellContentsAndCoordinates then
SayActiveCellCoordinates()
Endif
EndIf
EndScript
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Joseph Lee
Sent: Wednesday, June 7, 2017 2:53 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel
bothers me How to customize it?

Hi,
Was the script compiled at all? You need to compile the script
(Control+S) before it takes effect.
Cheers,
Joseph

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Mario
Sent: Wednesday, June 7, 2017 12:52 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel
bothers me How to customize it?

Tom, I followed along but the coordinates are still announced after
the contents. I don't understand why does it not work for me, might I
have to do a repair of JAWS?

-------- Original Message --------
From: Bissett, Tom [mailto:tom.bissett@bmo.com]
Sent: Wednesday, Jun 7, 2017 3:23 PM EST
To: main@jfw.groups.io
Subject: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

We are moving the line from between the endIF statements to before
the

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

statement.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io [mailto:main@jfw.groups.io] *On Behalf Of
*Lisle, Ted (CHFS DMS)
*Sent:* Wednesday, June 07, 2017 3:17 PM
*To:* main@jfw.groups.io
*Subject:* Re: Modifying scripts for cell coordinates, was Excel
bothers me How to customize it?

Correction: if I understood, there’s no line to delete, just insert.

Ted

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Lisle, Ted (CHFS DMS)
*Sent:* Wednesday, June 07, 2017 3:14 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel
bothers me How to customize it?

I’ve been following this, as I haven’t done any cookbook mods to a
script for a good while. I think Tom is inserting the line “SayCell()”
immediately prior to “*if CellReadingVerbosity” . . ., and that makes
the change. If all else fails, try using cut-and-paste, to avoid
mistyping. Delete the original line, and paste from the clipboard.*

**

*Ted*

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 07, 2017 3:02 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel
bothers me How to customize it?

Actually Richard gives a good response.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Wednesday, June 07, 2017 2:47 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel
bothers me How to customize it?

Tom,

I am so sorry to keep pestering.

I did what you said, I opened excel, insert 0 and found that section
in the script.

What you wrote is exactly what it already says.

Which part do we change to reverse the information?

I have no idea at all what the ! () && have to do with anything so I
don’t know what it is that I need to change.

It mentions something about verbosity set to
*readCellContentsAndCoordinates *Which is the default choice

Do we need to find the Verbosity script to change that to say
*readCellCoordinatesANDContents*

Or is that what I need to do right here in this section you pointed out?

Thanks a lot

Shannon

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 7, 2017 1:15 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel
bothers me How to customize it?

Ok, I will give this a go.

Open excel

Then open the script manager using jawsKey and zero on the number row

This will bring up the excel scripts in the script manager

Then do a search using control F searching for “*Script SayCell()”
with out the quotes *

*Here is where you can make the modification so that is reads like
the following *

**

*Script SayCell()*

*If OnSpreadSheet()*

*&& !OnFormulaBar() then*

* SayCell()*

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

* SayActiveCellCoordinates()*

* Endif*

*EndIf*

*EndScript*

**

*You will see that I just moved the line Script SayCell() up 3 lines
so that it is before *

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

**

*That is the only change needed but now you need to compile and save
the
file.*

*When you open the jaws script manager using JawsKey and zero Jaws
automatically creates a copy of the excel scripts in your personal
folder and this is where jaws looks for scripts first so it will pick
up any new or modified scripts.*

*To invoke the compile and save you simply press control and the
letter S. Jaws will announce compile complete you can then use alt
F4 to close the script manager. *

Your changes will take effect immediately.

If you want to back out of the changes you can go to your jaws
personal folders

c:\Users\userid\AppData \Roaming \Freedom
Scientific\JAWS\18.0\Settings\enu

here you can delete the excel.jsb and excel.jss files and you are
good to go.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner
*Sent:* Wednesday, June 07, 2017 12:44 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Tom,

To someone who is not a programmer, or doesn’t know the first thing
about programming, this still is not terribly useful.

If you could give file names and specific instructions how to do this
without screwing up the original scripts or how to safely back them
up first, that would be very useful.

Or, maybe those of us who are completely clueless shouldn’t even
monkey with this.

Richard

-----Original Message-----
From: main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] On Behalf Of Bissett, Tom
Sent: Wednesday, June 7, 2017 9:35 AM
To: main@jfw.groups.io <mailto:main@jfw.groups.io>
Subject: Re: Excel bothers me How to customize it?

This wasn't a new script but which script to change and how to change
it. Adding a new script by the same name at the end won't fix it
because jaws will just the first one.

I should have been more descriptive and said that you needed to
locate the existing script and make the modification as shown in the example.

regards

Tom Bisset

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 7, 2017 7:39 AM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

The only way I can find to change the order is by changing the script.
Below is the script

*Script SayCell()*

*If OnSpreadSheet()*

*&& !OnFormulaBar() then*

* SayCell()*

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

* SayActiveCellCoordinates()*

* Endif*

*; SayCell()*

*EndIf*

*EndScript*

I commented out the line

* SayCell()*

*And copied it And pasted it in the script just above the third “if”
statement as shown above *

Regards

Tom Bisset

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Tuesday, June 06, 2017 3:46 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

Richard,

Thank you, Do I have to do this for every spread sheet.?

I want to hear the coordenants before the contents not after. I want
to hear A2, meadows plaza not Meadows plaza A2

I looked around and found the spot to turn off the coordinates but
not how to reverse the order of what is spoken. Is this one of the
advanced settings of the verbosity settings?

Thanks again

Shannon

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner
*Sent:* Tuesday, June 6, 2017 2:30 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

I can help you with the column headers, but I’m not sure why my
coordinates speak after the data.

To set the column headers to read the way you want do the following:

One, Go to a1 and tap the alt key to bring up the upper ribbon and
arrow to the formulas tab.

2. down arrow to the lower ribbon and right arrow to the Define Names tab.

3. Hit enter.

4. Hit alt+n to create a new name.

5. Write the word “title” without the quotes and hit enter.

6. tab to the close button and hit spacebar.

Now, when you arrow down a column, it will speak the contents of the
cell, but if you right arrow or tab, you will hear the column title.
As you down arrow, you will also hear the row title.

I hope that helps,

Richard

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Tuesday, June 6, 2017 12:05 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Excel bothers me How to customize it?

Hi all,

I use spread sheets every single day.

I have opened an excel sheet and when I am arrowing through it I am
hearing things that are just…. Yucky!

1there is this annoying voice that speaks the cell coordinates.

I have futzed around with the voices so what I don’t know is which
one of the voices is doing this. It is the same one that says the
status of a message in Outlook un-read, forwarded and replied. And
gives the erroneous indexes of the messages. (for some reason it
always gives x of
44.)

2I don’t like hearing the contents and then the cell coordinates after.

I want to reverse the order. How can I do that?

3 How to make the entire first row column headers and have it only
report when I change columns? I don’t want to hear it when I stay in
the same column.

Thanks

Shannon














.
























Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Carol Smith
 

Thank you. I couldn't remember the keys to get into the quick settings. This is now done. Works great!

Carol

On 6/8/2017 11:59 AM, Mario wrote:
Carol, press insert+v for the quick settings dialog, type verb.
you should hear cell verbosity, press down arrow and space bar to
contents only. press enter to save the change. you might have to enter
again to close the quick settings dialog.


-------- Original Message --------
From: Carol Smith via Groups.Io [mailto:carollablady=aol.com@groups.io]
Sent: Thursday, Jun 8, 2017 11:24 AM EST
To: main@jfw.groups.io
Subject: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

When going through lots of numeric data, my preference is to have only
cell content spoken. Does Jaws have a shortcut key for reading just
coordinates? This way, I can hear only the data I need and can get
related coordinates when I need them. Thanks.

Carol
On 6/8/2017 9:54 AM, Shannon wrote:
Ted,
Precisely!
My preference would be to hear;
A81 "Thursday, June 8, 2017,
G79 "Five, has formula,."

Sounds like a simple enough thing to do but obviously it is not. Smile
Shannon
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Lisle, Ted (CHFS DMS)
Sent: Thursday, June 8, 2017 8:18 AM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Just for fun, I flipped to a little sheet I use here to track pharmacy
calls. The first column reads "Thursday, June 8, 2017, A81."
succeeding columns list calls, each designated with a 1. At the end
of the day, I enter a simple sum; so yesterday's total reads "Five,
has formula, G79."

Ted

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Carol Smith via Groups.Io
Sent: Thursday, June 08, 2017 8:40 AM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Actually, I never gave it any thought, but with Window-Eyes and Excel,
the coordinates are spoken first, the contents next and information
about the dell, money, date, etc. are spoken afterward.

Carol


On 6/8/2017 7:50 AM, Lisle, Ted (CHFS DMS) wrote:
I got my first real spreadsheet training around 1990. Over the
years, I used Artic Business Vision, VOS, ASAP, and, of course,
JAWS. Far as I can remember, cells have always been announced the
same way; guess I never gave it much thought until now.

Ted

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Shannon
Sent: Wednesday, June 07, 2017 4:41 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel
bothers me How to customize it?

Mario,
After doing all of this and rearranging a few lines.
I deleted the entire script entry.
Guess what happened?
Not a thing!
Without that stuff in there it still says the contents and then the
coordinates.
So the answer must be tied to something else.
Shannon
P.s.
I copied all of the jaws excel script into note pad for back up
before I did anything.
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario
Sent: Wednesday, June 7, 2017 3:20 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel
bothers me How to customize it?

yep, same issue I'm having.

at the end of one of Tom's replys, he mentioned about a setting in JAWS.
I wonder if he meant the Cell verbosity, which in my case, it's set to
contents and coordinates. but changing it to contents only is not
practical. these are the only choices for cell verbosity. maybe there's
another setting to adjust?


-------- Original Message --------
From: Shannon [mailto:shannon@bartchroofing.com]
Sent: Wednesday, Jun 7, 2017 4:10 PM EST
To: main@jfw.groups.io
Subject: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

Hi all,
I gave up intrying to over think it and just did a cut and paste.
At first it would not save. I got some sort of error.
Then I read Joseph's message below and learned about compialing. I did
the whole thing over cut and pasted what Tom provided.
I did the ctrl S and I was told it compiled.
But it still is reading the contents and then the coordinates.
It didn't change the behavior.
Here is what I pasted.
Script SayCell()
If OnSpreadSheet()
&& !OnFormulaBar() then
SayCell()
if CellReadingVerbosity() == readCellContentsAndCoordinates then
SayActiveCellCoordinates()
Endif
EndIf
EndScript
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Joseph Lee
Sent: Wednesday, June 7, 2017 2:53 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Hi,
Was the script compiled at all? You need to compile the script
(Control+S) before it takes effect.
Cheers,
Joseph

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario
Sent: Wednesday, June 7, 2017 12:52 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Tom, I followed along but the coordinates are still announced after the
contents. I don't understand why does it not work for me, might I have
to do a repair of JAWS?

-------- Original Message --------
From: Bissett, Tom [mailto:tom.bissett@bmo.com]
Sent: Wednesday, Jun 7, 2017 3:23 PM EST
To: main@jfw.groups.io
Subject: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

We are moving the line from between the endIF statements to before the

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

statement.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io [mailto:main@jfw.groups.io] *On Behalf Of
*Lisle, Ted (CHFS DMS)
*Sent:* Wednesday, June 07, 2017 3:17 PM
*To:* main@jfw.groups.io
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Correction: if I understood, there’s no line to delete, just insert.

Ted

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Lisle, Ted (CHFS DMS)
*Sent:* Wednesday, June 07, 2017 3:14 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

I’ve been following this, as I haven’t done any cookbook mods to a
script for a good while. I think Tom is inserting the line “SayCell()”
immediately prior to “*if CellReadingVerbosity” . . ., and that makes
the change. If all else fails, try using cut-and-paste, to avoid
mistyping. Delete the original line, and paste from the clipboard.*

**

*Ted*

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 07, 2017 3:02 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Actually Richard gives a good response.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Wednesday, June 07, 2017 2:47 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Tom,

I am so sorry to keep pestering.

I did what you said, I opened excel, insert 0 and found that section in
the script.

What you wrote is exactly what it already says.

Which part do we change to reverse the information?

I have no idea at all what the ! () && have to do with anything so I
don’t know what it is that I need to change.

It mentions something about verbosity set to
*readCellContentsAndCoordinates *Which is the default choice

Do we need to find the Verbosity script to change that to say
*readCellCoordinatesANDContents*

Or is that what I need to do right here in this section you pointed out?

Thanks a lot

Shannon

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 7, 2017 1:15 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Ok, I will give this a go.

Open excel

Then open the script manager using jawsKey and zero on the number row

This will bring up the excel scripts in the script manager

Then do a search using control F searching for “*Script SayCell()” with
out the quotes *

*Here is where you can make the modification so that is reads like the
following *

**

*Script SayCell()*

*If OnSpreadSheet()*

*&& !OnFormulaBar() then*

* SayCell()*

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

* SayActiveCellCoordinates()*

* Endif*

*EndIf*

*EndScript*

**

*You will see that I just moved the line Script SayCell() up 3 lines so
that it is before *

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

**

*That is the only change needed but now you need to compile and save the
file.*

*When you open the jaws script manager using JawsKey and zero Jaws
automatically creates a copy of the excel scripts in your personal
folder and this is where jaws looks for scripts first so it will pick up
any new or modified scripts.*

*To invoke the compile and save you simply press control and the letter
S. Jaws will announce compile complete you can then use alt F4 to close
the script manager. *

Your changes will take effect immediately.

If you want to back out of the changes you can go to your jaws personal
folders

c:\Users\userid\AppData \Roaming \Freedom
Scientific\JAWS\18.0\Settings\enu

here you can delete the excel.jsb and excel.jss files and you are good
to go.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner
*Sent:* Wednesday, June 07, 2017 12:44 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

Tom,

To someone who is not a programmer, or doesn’t know the first thing
about programming, this still is not terribly useful.

If you could give file names and specific instructions how to do this
without screwing up the original scripts or how to safely back them up
first, that would be very useful.

Or, maybe those of us who are completely clueless shouldn’t even monkey
with this.

Richard

-----Original Message-----
From: main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] On Behalf Of Bissett, Tom
Sent: Wednesday, June 7, 2017 9:35 AM
To: main@jfw.groups.io <mailto:main@jfw.groups.io>
Subject: Re: Excel bothers me How to customize it?

This wasn't a new script but which script to change and how to change
it. Adding a new script by the same name at the end won't fix it
because jaws will just the first one.

I should have been more descriptive and said that you needed to locate
the existing script and make the modification as shown in the example.

regards

Tom Bisset

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 7, 2017 7:39 AM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

The only way I can find to change the order is by changing the script.
Below is the script

*Script SayCell()*

*If OnSpreadSheet()*

*&& !OnFormulaBar() then*

* SayCell()*

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

* SayActiveCellCoordinates()*

* Endif*

*; SayCell()*

*EndIf*

*EndScript*

I commented out the line

* SayCell()*

*And copied it And pasted it in the script just above the third “if”
statement as shown above *

Regards

Tom Bisset

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Tuesday, June 06, 2017 3:46 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

Richard,

Thank you, Do I have to do this for every spread sheet.?

I want to hear the coordenants before the contents not after. I want to
hear A2, meadows plaza not Meadows plaza A2

I looked around and found the spot to turn off the coordinates but not
how to reverse the order of what is spoken. Is this one of the advanced
settings of the verbosity settings?

Thanks again

Shannon

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner
*Sent:* Tuesday, June 6, 2017 2:30 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

I can help you with the column headers, but I’m not sure why my
coordinates speak after the data.

To set the column headers to read the way you want do the following:

One, Go to a1 and tap the alt key to bring up the upper ribbon and arrow
to the formulas tab.

2. down arrow to the lower ribbon and right arrow to the Define
Names tab.

3. Hit enter.

4. Hit alt+n to create a new name.

5. Write the word “title” without the quotes and hit enter.

6. tab to the close button and hit spacebar.

Now, when you arrow down a column, it will speak the contents of the
cell, but if you right arrow or tab, you will hear the column title. As
you down arrow, you will also hear the row title.

I hope that helps,

Richard

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Tuesday, June 6, 2017 12:05 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Excel bothers me How to customize it?

Hi all,

I use spread sheets every single day.

I have opened an excel sheet and when I am arrowing through it I am
hearing things that are just…. Yucky!

1there is this annoying voice that speaks the cell coordinates.

I have futzed around with the voices so what I don’t know is which one
of the voices is doing this. It is the same one that says the status of
a message in Outlook un-read, forwarded and replied. And gives the
erroneous indexes of the messages. (for some reason it always gives x of
44.)

2I don’t like hearing the contents and then the cell coordinates after.

I want to reverse the order. How can I do that?

3 How to make the entire first row column headers and have it only
report when I change columns? I don’t want to hear it when I stay in the
same column.

Thanks

Shannon














.



























.




Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Dave...
 

Insert+C

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer

----- Original Message -----
From: "Carol Smith via Groups.Io" <carollablady=aol.com@groups.io>
To: <main@jfw.groups.io>
Sent: Thursday, June 08, 2017 08:24
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?


When going through lots of numeric data, my preference is to have only
cell content spoken. Does Jaws have a shortcut key for reading just
coordinates? This way, I can hear only the data I need and can get
related coordinates when I need them. Thanks.

Carol
On 6/8/2017 9:54 AM, Shannon wrote:
Ted,
Precisely!
My preference would be to hear;
A81 "Thursday, June 8, 2017,
G79 "Five, has formula,."

Sounds like a simple enough thing to do but obviously it is not. Smile
Shannon
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Lisle,
Ted (CHFS DMS)
Sent: Thursday, June 8, 2017 8:18 AM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

Just for fun, I flipped to a little sheet I use here to track pharmacy
calls. The first column reads "Thursday, June 8, 2017, A81." succeeding
columns list calls, each designated with a 1. At the end of the day, I
enter a simple sum; so yesterday's total reads "Five, has formula, G79."

Ted

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Carol
Smith via Groups.Io
Sent: Thursday, June 08, 2017 8:40 AM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

Actually, I never gave it any thought, but with Window-Eyes and Excel,
the coordinates are spoken first, the contents next and information
about the dell, money, date, etc. are spoken afterward.

Carol


On 6/8/2017 7:50 AM, Lisle, Ted (CHFS DMS) wrote:
I got my first real spreadsheet training around 1990. Over the years, I
used Artic Business Vision, VOS, ASAP, and, of course, JAWS. Far as I
can remember, cells have always been announced the same way; guess I
never gave it much thought until now.

Ted

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Shannon
Sent: Wednesday, June 07, 2017 4:41 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

Mario,
After doing all of this and rearranging a few lines.
I deleted the entire script entry.
Guess what happened?
Not a thing!
Without that stuff in there it still says the contents and then the
coordinates.
So the answer must be tied to something else.
Shannon
P.s.
I copied all of the jaws excel script into note pad for back up before I
did anything.
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario
Sent: Wednesday, June 7, 2017 3:20 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

yep, same issue I'm having.

at the end of one of Tom's replys, he mentioned about a setting in JAWS.
I wonder if he meant the Cell verbosity, which in my case, it's set to
contents and coordinates. but changing it to contents only is not
practical. these are the only choices for cell verbosity. maybe there's
another setting to adjust?


-------- Original Message --------
From: Shannon [mailto:shannon@bartchroofing.com]
Sent: Wednesday, Jun 7, 2017 4:10 PM EST
To: main@jfw.groups.io
Subject: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

Hi all,
I gave up intrying to over think it and just did a cut and paste.
At first it would not save. I got some sort of error.
Then I read Joseph's message below and learned about compialing. I did
the whole thing over cut and pasted what Tom provided.
I did the ctrl S and I was told it compiled.
But it still is reading the contents and then the coordinates.
It didn't change the behavior.
Here is what I pasted.
Script SayCell()
If OnSpreadSheet()
&& !OnFormulaBar() then
SayCell()
if CellReadingVerbosity() == readCellContentsAndCoordinates then
SayActiveCellCoordinates()
Endif
EndIf
EndScript
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Joseph
Lee
Sent: Wednesday, June 7, 2017 2:53 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Hi,
Was the script compiled at all? You need to compile the script
(Control+S) before it takes effect.
Cheers,
Joseph

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario
Sent: Wednesday, June 7, 2017 12:52 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Tom, I followed along but the coordinates are still announced after the
contents. I don't understand why does it not work for me, might I have
to do a repair of JAWS?

-------- Original Message --------
From: Bissett, Tom [mailto:tom.bissett@bmo.com]
Sent: Wednesday, Jun 7, 2017 3:23 PM EST
To: main@jfw.groups.io
Subject: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

We are moving the line from between the endIF statements to before the

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

statement.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io [mailto:main@jfw.groups.io] *On Behalf Of
*Lisle, Ted (CHFS DMS)
*Sent:* Wednesday, June 07, 2017 3:17 PM
*To:* main@jfw.groups.io
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Correction: if I understood, there’s no line to delete, just insert.

Ted

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Lisle, Ted (CHFS DMS)
*Sent:* Wednesday, June 07, 2017 3:14 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

I’ve been following this, as I haven’t done any cookbook mods to a
script for a good while. I think Tom is inserting the line “SayCell()”
immediately prior to “*if CellReadingVerbosity” . . ., and that makes
the change. If all else fails, try using cut-and-paste, to avoid
mistyping. Delete the original line, and paste from the clipboard.*

**

*Ted*

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 07, 2017 3:02 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Actually Richard gives a good response.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Wednesday, June 07, 2017 2:47 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Tom,

I am so sorry to keep pestering.

I did what you said, I opened excel, insert 0 and found that section in
the script.

What you wrote is exactly what it already says.

Which part do we change to reverse the information?

I have no idea at all what the ! () && have to do with anything so I
don’t know what it is that I need to change.

It mentions something about verbosity set to
*readCellContentsAndCoordinates *Which is the default choice

Do we need to find the Verbosity script to change that to say
*readCellCoordinatesANDContents*

Or is that what I need to do right here in this section you pointed out?

Thanks a lot

Shannon

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 7, 2017 1:15 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Ok, I will give this a go.

Open excel

Then open the script manager using jawsKey and zero on the number row

This will bring up the excel scripts in the script manager

Then do a search using control F searching for “*Script SayCell()” with
out the quotes *

*Here is where you can make the modification so that is reads like the
following *

**

*Script SayCell()*

*If OnSpreadSheet()*

*&& !OnFormulaBar() then*

* SayCell()*

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

* SayActiveCellCoordinates()*

* Endif*

*EndIf*

*EndScript*

**

*You will see that I just moved the line Script SayCell() up 3 lines so
that it is before *

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

**

*That is the only change needed but now you need to compile and save the
file.*

*When you open the jaws script manager using JawsKey and zero Jaws
automatically creates a copy of the excel scripts in your personal
folder and this is where jaws looks for scripts first so it will pick up
any new or modified scripts.*

*To invoke the compile and save you simply press control and the letter
S. Jaws will announce compile complete you can then use alt F4 to close
the script manager. *

Your changes will take effect immediately.

If you want to back out of the changes you can go to your jaws personal
folders

c:\Users\userid\AppData \Roaming \Freedom
Scientific\JAWS\18.0\Settings\enu

here you can delete the excel.jsb and excel.jss files and you are good
to go.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner
*Sent:* Wednesday, June 07, 2017 12:44 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

Tom,

To someone who is not a programmer, or doesn’t know the first thing
about programming, this still is not terribly useful.

If you could give file names and specific instructions how to do this
without screwing up the original scripts or how to safely back them up
first, that would be very useful.

Or, maybe those of us who are completely clueless shouldn’t even monkey
with this.

Richard

-----Original Message-----
From: main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] On Behalf Of Bissett, Tom
Sent: Wednesday, June 7, 2017 9:35 AM
To: main@jfw.groups.io <mailto:main@jfw.groups.io>
Subject: Re: Excel bothers me How to customize it?

This wasn't a new script but which script to change and how to change
it. Adding a new script by the same name at the end won't fix it
because jaws will just the first one.

I should have been more descriptive and said that you needed to locate
the existing script and make the modification as shown in the example.

regards

Tom Bisset

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 7, 2017 7:39 AM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

The only way I can find to change the order is by changing the script.
Below is the script

*Script SayCell()*

*If OnSpreadSheet()*

*&& !OnFormulaBar() then*

* SayCell()*

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

* SayActiveCellCoordinates()*

* Endif*

*; SayCell()*

*EndIf*

*EndScript*

I commented out the line

* SayCell()*

*And copied it And pasted it in the script just above the third “if”
statement as shown above *

Regards

Tom Bisset

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Tuesday, June 06, 2017 3:46 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

Richard,

Thank you, Do I have to do this for every spread sheet.?

I want to hear the coordenants before the contents not after. I want to
hear A2, meadows plaza not Meadows plaza A2

I looked around and found the spot to turn off the coordinates but not
how to reverse the order of what is spoken. Is this one of the advanced
settings of the verbosity settings?

Thanks again

Shannon

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner
*Sent:* Tuesday, June 6, 2017 2:30 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

I can help you with the column headers, but I’m not sure why my
coordinates speak after the data.

To set the column headers to read the way you want do the following:

One, Go to a1 and tap the alt key to bring up the upper ribbon and arrow
to the formulas tab.

2. down arrow to the lower ribbon and right arrow to the Define Names
tab.

3. Hit enter.

4. Hit alt+n to create a new name.

5. Write the word “title” without the quotes and hit enter.

6. tab to the close button and hit spacebar.

Now, when you arrow down a column, it will speak the contents of the
cell, but if you right arrow or tab, you will hear the column title. As
you down arrow, you will also hear the row title.

I hope that helps,

Richard

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Tuesday, June 6, 2017 12:05 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Excel bothers me How to customize it?

Hi all,

I use spread sheets every single day.

I have opened an excel sheet and when I am arrowing through it I am
hearing things that are just…. Yucky!

1there is this annoying voice that speaks the cell coordinates.

I have futzed around with the voices so what I don’t know is which one
of the voices is doing this. It is the same one that says the status of
a message in Outlook un-read, forwarded and replied. And gives the
erroneous indexes of the messages. (for some reason it always gives x of
44.)

2I don’t like hearing the contents and then the cell coordinates after.

I want to reverse the order. How can I do that?

3 How to make the entire first row column headers and have it only
report when I change columns? I don’t want to hear it when I stay in the
same column.

Thanks

Shannon














.





















Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Dave...
 

Well, that's good for Window-Eyes, but we're trying to help with JAWS here.

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer

----- Original Message -----
From: "Richard Turner" <richardturner42@outlook.com>
To: <main@jfw.groups.io>
Sent: Thursday, June 08, 2017 06:12
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?


And, you could change that easily in the Window-Eyes settings.

Richard


-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Carol
Smith via Groups.Io
Sent: Thursday, June 8, 2017 5:40 AM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

Actually, I never gave it any thought, but with Window-Eyes and Excel,
the coordinates are spoken first, the contents next and information
about the dell, money, date, etc. are spoken afterward.

Carol


On 6/8/2017 7:50 AM, Lisle, Ted (CHFS DMS) wrote:
I got my first real spreadsheet training around 1990. Over the years, I
used Artic Business Vision, VOS, ASAP, and, of course, JAWS. Far as I can
remember, cells have always been announced the same way; guess I never
gave it much thought until now.

Ted

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Shannon
Sent: Wednesday, June 07, 2017 4:41 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

Mario,
After doing all of this and rearranging a few lines.
I deleted the entire script entry.
Guess what happened?
Not a thing!
Without that stuff in there it still says the contents and then the
coordinates.
So the answer must be tied to something else.
Shannon
P.s.
I copied all of the jaws excel script into note pad for back up before I
did anything.
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario
Sent: Wednesday, June 7, 2017 3:20 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

yep, same issue I'm having.

at the end of one of Tom's replys, he mentioned about a setting in JAWS.
I wonder if he meant the Cell verbosity, which in my case, it's set to
contents and coordinates. but changing it to contents only is not
practical. these are the only choices for cell verbosity. maybe there's
another setting to adjust?


-------- Original Message --------
From: Shannon [mailto:shannon@bartchroofing.com]
Sent: Wednesday, Jun 7, 2017 4:10 PM EST
To: main@jfw.groups.io
Subject: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

Hi all,
I gave up intrying to over think it and just did a cut and paste.
At first it would not save. I got some sort of error.
Then I read Joseph's message below and learned about compialing. I did
the whole thing over cut and pasted what Tom provided.
I did the ctrl S and I was told it compiled.
But it still is reading the contents and then the coordinates.
It didn't change the behavior.
Here is what I pasted.
Script SayCell()
If OnSpreadSheet()
&& !OnFormulaBar() then
SayCell()
if CellReadingVerbosity() == readCellContentsAndCoordinates then
SayActiveCellCoordinates()
Endif
EndIf
EndScript
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Joseph
Lee
Sent: Wednesday, June 7, 2017 2:53 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Hi,
Was the script compiled at all? You need to compile the script
(Control+S) before it takes effect.
Cheers,
Joseph

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario
Sent: Wednesday, June 7, 2017 12:52 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Tom, I followed along but the coordinates are still announced after the
contents. I don't understand why does it not work for me, might I have
to do a repair of JAWS?

-------- Original Message --------
From: Bissett, Tom [mailto:tom.bissett@bmo.com]
Sent: Wednesday, Jun 7, 2017 3:23 PM EST
To: main@jfw.groups.io
Subject: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

We are moving the line from between the endIF statements to before the

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

statement.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io [mailto:main@jfw.groups.io] *On Behalf Of
*Lisle, Ted (CHFS DMS)
*Sent:* Wednesday, June 07, 2017 3:17 PM
*To:* main@jfw.groups.io
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Correction: if I understood, there’s no line to delete, just insert.

Ted

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Lisle, Ted (CHFS DMS)
*Sent:* Wednesday, June 07, 2017 3:14 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

I’ve been following this, as I haven’t done any cookbook mods to a
script for a good while. I think Tom is inserting the line “SayCell()”
immediately prior to “*if CellReadingVerbosity” . . ., and that makes
the change. If all else fails, try using cut-and-paste, to avoid
mistyping. Delete the original line, and paste from the clipboard.*

**

*Ted*

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 07, 2017 3:02 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Actually Richard gives a good response.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Wednesday, June 07, 2017 2:47 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Tom,

I am so sorry to keep pestering.

I did what you said, I opened excel, insert 0 and found that section in
the script.

What you wrote is exactly what it already says.

Which part do we change to reverse the information?

I have no idea at all what the ! () && have to do with anything so I
don’t know what it is that I need to change.

It mentions something about verbosity set to
*readCellContentsAndCoordinates *Which is the default choice

Do we need to find the Verbosity script to change that to say
*readCellCoordinatesANDContents*

Or is that what I need to do right here in this section you pointed out?

Thanks a lot

Shannon

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 7, 2017 1:15 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Ok, I will give this a go.

Open excel

Then open the script manager using jawsKey and zero on the number row

This will bring up the excel scripts in the script manager

Then do a search using control F searching for “*Script SayCell()” with
out the quotes *

*Here is where you can make the modification so that is reads like the
following *

**

*Script SayCell()*

*If OnSpreadSheet()*

*&& !OnFormulaBar() then*

* SayCell()*

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

* SayActiveCellCoordinates()*

* Endif*

*EndIf*

*EndScript*

**

*You will see that I just moved the line Script SayCell() up 3 lines so
that it is before *

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

**

*That is the only change needed but now you need to compile and save the
file.*

*When you open the jaws script manager using JawsKey and zero Jaws
automatically creates a copy of the excel scripts in your personal
folder and this is where jaws looks for scripts first so it will pick up
any new or modified scripts.*

*To invoke the compile and save you simply press control and the letter
S. Jaws will announce compile complete you can then use alt F4 to close
the script manager. *

Your changes will take effect immediately.

If you want to back out of the changes you can go to your jaws personal
folders

c:\Users\userid\AppData \Roaming \Freedom
Scientific\JAWS\18.0\Settings\enu

here you can delete the excel.jsb and excel.jss files and you are good
to go.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner
*Sent:* Wednesday, June 07, 2017 12:44 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

Tom,

To someone who is not a programmer, or doesn’t know the first thing
about programming, this still is not terribly useful.

If you could give file names and specific instructions how to do this
without screwing up the original scripts or how to safely back them up
first, that would be very useful.

Or, maybe those of us who are completely clueless shouldn’t even monkey
with this.

Richard

-----Original Message-----
From: main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] On Behalf Of Bissett, Tom
Sent: Wednesday, June 7, 2017 9:35 AM
To: main@jfw.groups.io <mailto:main@jfw.groups.io>
Subject: Re: Excel bothers me How to customize it?

This wasn't a new script but which script to change and how to change
it. Adding a new script by the same name at the end won't fix it
because jaws will just the first one.

I should have been more descriptive and said that you needed to locate
the existing script and make the modification as shown in the example.

regards

Tom Bisset

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 7, 2017 7:39 AM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

The only way I can find to change the order is by changing the script.
Below is the script

*Script SayCell()*

*If OnSpreadSheet()*

*&& !OnFormulaBar() then*

* SayCell()*

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

* SayActiveCellCoordinates()*

* Endif*

*; SayCell()*

*EndIf*

*EndScript*

I commented out the line

* SayCell()*

*And copied it And pasted it in the script just above the third “if”
statement as shown above *

Regards

Tom Bisset

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Tuesday, June 06, 2017 3:46 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

Richard,

Thank you, Do I have to do this for every spread sheet.?

I want to hear the coordenants before the contents not after. I want to
hear A2, meadows plaza not Meadows plaza A2

I looked around and found the spot to turn off the coordinates but not
how to reverse the order of what is spoken. Is this one of the advanced
settings of the verbosity settings?

Thanks again

Shannon

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner
*Sent:* Tuesday, June 6, 2017 2:30 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

I can help you with the column headers, but I’m not sure why my
coordinates speak after the data.

To set the column headers to read the way you want do the following:

One, Go to a1 and tap the alt key to bring up the upper ribbon and arrow
to the formulas tab.

2. down arrow to the lower ribbon and right arrow to the Define Names
tab.

3. Hit enter.

4. Hit alt+n to create a new name.

5. Write the word “title” without the quotes and hit enter.

6. tab to the close button and hit spacebar.

Now, when you arrow down a column, it will speak the contents of the
cell, but if you right arrow or tab, you will hear the column title. As
you down arrow, you will also hear the row title.

I hope that helps,

Richard

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Tuesday, June 6, 2017 12:05 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Excel bothers me How to customize it?

Hi all,

I use spread sheets every single day.

I have opened an excel sheet and when I am arrowing through it I am
hearing things that are just…. Yucky!

1there is this annoying voice that speaks the cell coordinates.

I have futzed around with the voices so what I don’t know is which one
of the voices is doing this. It is the same one that says the status of
a message in Outlook un-read, forwarded and replied. And gives the
erroneous indexes of the messages. (for some reason it always gives x of
44.)

2I don’t like hearing the contents and then the cell coordinates after.

I want to reverse the order. How can I do that?

3 How to make the entire first row column headers and have it only
report when I change columns? I don’t want to hear it when I stay in the
same column.

Thanks

Shannon














.












Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

 

Shannon, have you called FS support to ask if and how this can be changed? That's what they are there for.

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Shannon
Sent: Thursday, June 8, 2017 6:54 AM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Ted,
Precisely!
My preference would be to hear;
A81 "Thursday, June 8, 2017,
G79 "Five, has formula,."

Sounds like a simple enough thing to do but obviously it is not. Smile Shannon -----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Lisle, Ted (CHFS DMS)
Sent: Thursday, June 8, 2017 8:18 AM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Just for fun, I flipped to a little sheet I use here to track pharmacy calls. The first column reads "Thursday, June 8, 2017, A81." succeeding columns list calls, each designated with a 1. At the end of the day, I enter a simple sum; so yesterday's total reads "Five, has formula, G79."

Ted

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Carol Smith via Groups.Io
Sent: Thursday, June 08, 2017 8:40 AM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Actually, I never gave it any thought, but with Window-Eyes and Excel, the coordinates are spoken first, the contents next and information about the dell, money, date, etc. are spoken afterward.

Carol


On 6/8/2017 7:50 AM, Lisle, Ted (CHFS DMS) wrote:
I got my first real spreadsheet training around 1990. Over the years, I used Artic Business Vision, VOS, ASAP, and, of course, JAWS. Far as I can remember, cells have always been announced the same way; guess I never gave it much thought until now.

Ted

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Shannon
Sent: Wednesday, June 07, 2017 4:41 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Mario,
After doing all of this and rearranging a few lines.
I deleted the entire script entry.
Guess what happened?
Not a thing!
Without that stuff in there it still says the contents and then the coordinates.
So the answer must be tied to something else.
Shannon
P.s.
I copied all of the jaws excel script into note pad for back up before I did anything.
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Mario
Sent: Wednesday, June 7, 2017 3:20 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

yep, same issue I'm having.

at the end of one of Tom's replys, he mentioned about a setting in JAWS.
I wonder if he meant the Cell verbosity, which in my case, it's set to
contents and coordinates. but changing it to contents only is not
practical. these are the only choices for cell verbosity. maybe
there's another setting to adjust?


-------- Original Message --------
From: Shannon [mailto:shannon@bartchroofing.com]
Sent: Wednesday, Jun 7, 2017 4:10 PM EST
To: main@jfw.groups.io
Subject: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

Hi all,
I gave up intrying to over think it and just did a cut and paste.
At first it would not save. I got some sort of error.
Then I read Joseph's message below and learned about compialing. I did
the whole thing over cut and pasted what Tom provided.
I did the ctrl S and I was told it compiled.
But it still is reading the contents and then the coordinates.
It didn't change the behavior.
Here is what I pasted.
Script SayCell()
If OnSpreadSheet()
&& !OnFormulaBar() then
SayCell()
if CellReadingVerbosity() == readCellContentsAndCoordinates then
SayActiveCellCoordinates()
Endif
EndIf
EndScript
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Joseph Lee
Sent: Wednesday, June 7, 2017 2:53 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Hi,
Was the script compiled at all? You need to compile the script
(Control+S) before it takes effect.
Cheers,
Joseph

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Mario
Sent: Wednesday, June 7, 2017 12:52 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Tom, I followed along but the coordinates are still announced after
the contents. I don't understand why does it not work for me, might I
have to do a repair of JAWS?

-------- Original Message --------
From: Bissett, Tom [mailto:tom.bissett@bmo.com]
Sent: Wednesday, Jun 7, 2017 3:23 PM EST
To: main@jfw.groups.io
Subject: Modifying scripts for cell coordinates, was Excel bothers me
How to customize it?

We are moving the line from between the endIF statements to before the

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

statement.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io [mailto:main@jfw.groups.io] *On Behalf Of
*Lisle, Ted (CHFS DMS)
*Sent:* Wednesday, June 07, 2017 3:17 PM
*To:* main@jfw.groups.io
*Subject:* Re: Modifying scripts for cell coordinates, was Excel
bothers me How to customize it?

Correction: if I understood, there’s no line to delete, just insert.

Ted

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Lisle, Ted (CHFS DMS)
*Sent:* Wednesday, June 07, 2017 3:14 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel
bothers me How to customize it?

I’ve been following this, as I haven’t done any cookbook mods to a
script for a good while. I think Tom is inserting the line “SayCell()”
immediately prior to “*if CellReadingVerbosity” . . ., and that makes
the change. If all else fails, try using cut-and-paste, to avoid
mistyping. Delete the original line, and paste from the clipboard.*

**

*Ted*

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 07, 2017 3:02 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel
bothers me How to customize it?

Actually Richard gives a good response.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Wednesday, June 07, 2017 2:47 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel
bothers me How to customize it?

Tom,

I am so sorry to keep pestering.

I did what you said, I opened excel, insert 0 and found that section
in the script.

What you wrote is exactly what it already says.

Which part do we change to reverse the information?

I have no idea at all what the ! () && have to do with anything so I
don’t know what it is that I need to change.

It mentions something about verbosity set to
*readCellContentsAndCoordinates *Which is the default choice

Do we need to find the Verbosity script to change that to say
*readCellCoordinatesANDContents*

Or is that what I need to do right here in this section you pointed out?

Thanks a lot

Shannon

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 7, 2017 1:15 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel
bothers me How to customize it?

Ok, I will give this a go.

Open excel

Then open the script manager using jawsKey and zero on the number row

This will bring up the excel scripts in the script manager

Then do a search using control F searching for “*Script SayCell()”
with out the quotes *

*Here is where you can make the modification so that is reads like the
following *

**

*Script SayCell()*

*If OnSpreadSheet()*

*&& !OnFormulaBar() then*

* SayCell()*

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

* SayActiveCellCoordinates()*

* Endif*

*EndIf*

*EndScript*

**

*You will see that I just moved the line Script SayCell() up 3 lines
so that it is before *

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

**

*That is the only change needed but now you need to compile and save
the
file.*

*When you open the jaws script manager using JawsKey and zero Jaws
automatically creates a copy of the excel scripts in your personal
folder and this is where jaws looks for scripts first so it will pick
up any new or modified scripts.*

*To invoke the compile and save you simply press control and the
letter S. Jaws will announce compile complete you can then use alt F4
to close the script manager. *

Your changes will take effect immediately.

If you want to back out of the changes you can go to your jaws
personal folders

c:\Users\userid\AppData \Roaming \Freedom
Scientific\JAWS\18.0\Settings\enu

here you can delete the excel.jsb and excel.jss files and you are good
to go.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner
*Sent:* Wednesday, June 07, 2017 12:44 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Modifying scripts for cell coordinates, was Excel bothers
me How to customize it?

Tom,

To someone who is not a programmer, or doesn’t know the first thing
about programming, this still is not terribly useful.

If you could give file names and specific instructions how to do this
without screwing up the original scripts or how to safely back them up
first, that would be very useful.

Or, maybe those of us who are completely clueless shouldn’t even
monkey with this.

Richard

-----Original Message-----
From: main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] On Behalf Of Bissett, Tom
Sent: Wednesday, June 7, 2017 9:35 AM
To: main@jfw.groups.io <mailto:main@jfw.groups.io>
Subject: Re: Excel bothers me How to customize it?

This wasn't a new script but which script to change and how to change
it. Adding a new script by the same name at the end won't fix it
because jaws will just the first one.

I should have been more descriptive and said that you needed to locate
the existing script and make the modification as shown in the example.

regards

Tom Bisset

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 7, 2017 7:39 AM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

The only way I can find to change the order is by changing the script.
Below is the script

*Script SayCell()*

*If OnSpreadSheet()*

*&& !OnFormulaBar() then*

* SayCell()*

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

* SayActiveCellCoordinates()*

* Endif*

*; SayCell()*

*EndIf*

*EndScript*

I commented out the line

* SayCell()*

*And copied it And pasted it in the script just above the third “if”
statement as shown above *

Regards

Tom Bisset

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Tuesday, June 06, 2017 3:46 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

Richard,

Thank you, Do I have to do this for every spread sheet.?

I want to hear the coordenants before the contents not after. I want
to hear A2, meadows plaza not Meadows plaza A2

I looked around and found the spot to turn off the coordinates but not
how to reverse the order of what is spoken. Is this one of the
advanced settings of the verbosity settings?

Thanks again

Shannon

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner
*Sent:* Tuesday, June 6, 2017 2:30 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

I can help you with the column headers, but I’m not sure why my
coordinates speak after the data.

To set the column headers to read the way you want do the following:

One, Go to a1 and tap the alt key to bring up the upper ribbon and
arrow to the formulas tab.

2. down arrow to the lower ribbon and right arrow to the Define Names tab.

3. Hit enter.

4. Hit alt+n to create a new name.

5. Write the word “title” without the quotes and hit enter.

6. tab to the close button and hit spacebar.

Now, when you arrow down a column, it will speak the contents of the
cell, but if you right arrow or tab, you will hear the column title.
As you down arrow, you will also hear the row title.

I hope that helps,

Richard

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io>
[mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Tuesday, June 6, 2017 12:05 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Excel bothers me How to customize it?

Hi all,

I use spread sheets every single day.

I have opened an excel sheet and when I am arrowing through it I am
hearing things that are just…. Yucky!

1there is this annoying voice that speaks the cell coordinates.

I have futzed around with the voices so what I don’t know is which one
of the voices is doing this. It is the same one that says the status
of a message in Outlook un-read, forwarded and replied. And gives the
erroneous indexes of the messages. (for some reason it always gives x
of
44.)

2I don’t like hearing the contents and then the cell coordinates after.

I want to reverse the order. How can I do that?

3 How to make the entire first row column headers and have it only
report when I change columns? I don’t want to hear it when I stay in
the same column.

Thanks

Shannon














.












JAWS 18 and Win10 mail app

Jessica D <jldail13@...>
 

Hi,

I’m using windows 10, version 1607, with JAWS 18, via Bootcamp on my mac.

 

 

I’m experiencing some technical difficulties.

They’re listefd below:

 

  1. Jaws won’t read UACs.
  2. 2. When opening the mail app, all tabs are read at once

Can these be fixed?

 

What do I do?

 

 

Sent from Mail for Windows 10

 


Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Shannon
 

Paul,
You are correct that column and row naming is an another option.
Not all spread sheets need that as a feature. Sometimes they are simple enough and or so briefly used that just knowing where you are is what is needed.
Naming is a more sophisticated option, but another option, like Saying the coordinates or not is an option
I and others would like the option to hear the coordinates before the contents as well as the option to hear the coordinates after the contents.
Shannon

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Paul Hunt
Sent: Thursday, June 8, 2017 9:18 AM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Hello everybody. Personally, I don't care so much when coordinates are announced as long as they are announced. To be productive using Excell, I want the name of the row announced as I navigate up and down no matter what cell I'm accessing. So in my budgetfor example, My row names are Categories. Every time I move from one category to another, the category is spoken before the dollar amount in the cell I'm accessing.
In my budget columns would be subtotal, total, Budgeted amount, actually spent, etc. These column names would be announced as I move left and right.
This is easily done in Excell and JAWS. In fact, anyone can make spreadsheets accessible even if they don't have JAWS installed on their machines. The feature in Excel is called Define Name.
There's an excellent Daisy book that shows you exactly how to do this and the good news is that no script modification is necessary.
I hope this helps you.
Paul


-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario
Sent: Thursday, June 8, 2017 9:03 AM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

I don't understand why the cell contents are announced before the coordinates. it is displayed as the cell coordinat followed by it's contents, so why can't JAWS announce it that way. it seems counter productive to me.


-------- Original Message --------
From: Lisle, Ted (CHFS DMS) [mailto:ted.lisle@ky.gov]
Sent: Thursday, Jun 8, 2017 7:50 AM EST
To: main@jfw.groups.io
Subject: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

I got my first real spreadsheet training around 1990. Over the years, I used Artic Business Vision, VOS, ASAP, and, of course, JAWS. Far as I can remember, cells have always been announced the same way; guess I never gave it much thought until now.

Ted

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Shannon
Sent: Wednesday, June 07, 2017 4:41 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Mario,
After doing all of this and rearranging a few lines.
I deleted the entire script entry.
Guess what happened?
Not a thing!
Without that stuff in there it still says the contents and then the coordinates.
So the answer must be tied to something else.
Shannon
P.s.
I copied all of the jaws excel script into note pad for back up before I did anything.
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario
Sent: Wednesday, June 7, 2017 3:20 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

yep, same issue I'm having.

at the end of one of Tom's replys, he mentioned about a setting in JAWS.
I wonder if he meant the Cell verbosity, which in my case, it's set to contents and coordinates. but changing it to contents only is not practical. these are the only choices for cell verbosity. maybe there's another setting to adjust?


-------- Original Message --------
From: Shannon [mailto:shannon@bartchroofing.com]
Sent: Wednesday, Jun 7, 2017 4:10 PM EST
To: main@jfw.groups.io
Subject: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Hi all,
I gave up intrying to over think it and just did a cut and paste.
At first it would not save. I got some sort of error.
Then I read Joseph's message below and learned about compialing. I did the whole thing over cut and pasted what Tom provided.
I did the ctrl S and I was told it compiled.
But it still is reading the contents and then the coordinates.
It didn't change the behavior.
Here is what I pasted.
Script SayCell()
If OnSpreadSheet()
&& !OnFormulaBar() then
SayCell()
if CellReadingVerbosity() == readCellContentsAndCoordinates then
SayActiveCellCoordinates()
Endif
EndIf
EndScript
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Joseph Lee
Sent: Wednesday, June 7, 2017 2:53 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Hi,
Was the script compiled at all? You need to compile the script
(Control+S) before it takes effect.
Cheers,
Joseph

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario
Sent: Wednesday, June 7, 2017 12:52 PM
To: main@jfw.groups.io
Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Tom, I followed along but the coordinates are still announced after the contents. I don't understand why does it not work for me, might I have to do a repair of JAWS?

-------- Original Message --------
From: Bissett, Tom [mailto:tom.bissett@bmo.com]
Sent: Wednesday, Jun 7, 2017 3:23 PM EST
To: main@jfw.groups.io
Subject: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

We are moving the line from between the endIF statements to before the

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

statement.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io [mailto:main@jfw.groups.io] *On Behalf Of *Lisle, Ted (CHFS DMS)
*Sent:* Wednesday, June 07, 2017 3:17 PM
*To:* main@jfw.groups.io
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Correction: if I understood, there’s no line to delete, just insert.

Ted

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *Lisle, Ted (CHFS DMS)
*Sent:* Wednesday, June 07, 2017 3:14 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

I’ve been following this, as I haven’t done any cookbook mods to a script for a good while. I think Tom is inserting the line “SayCell()”
immediately prior to “*if CellReadingVerbosity” . . ., and that makes the change. If all else fails, try using cut-and-paste, to avoid mistyping. Delete the original line, and paste from the clipboard.*

**

*Ted*

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 07, 2017 3:02 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Actually Richard gives a good response.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Wednesday, June 07, 2017 2:47 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Tom,

I am so sorry to keep pestering.

I did what you said, I opened excel, insert 0 and found that section in the script.

What you wrote is exactly what it already says.

Which part do we change to reverse the information?

I have no idea at all what the ! () && have to do with anything so I don’t know what it is that I need to change.

It mentions something about verbosity set to *readCellContentsAndCoordinates *Which is the default choice

Do we need to find the Verbosity script to change that to say
*readCellCoordinatesANDContents*

Or is that what I need to do right here in this section you pointed out?

Thanks a lot

Shannon

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 7, 2017 1:15 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Ok, I will give this a go.

Open excel

Then open the script manager using jawsKey and zero on the number row

This will bring up the excel scripts in the script manager

Then do a search using control F searching for “*Script SayCell()” with out the quotes *

*Here is where you can make the modification so that is reads like the following *

**

*Script SayCell()*

*If OnSpreadSheet()*

*&& !OnFormulaBar() then*

* SayCell()*

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

* SayActiveCellCoordinates()*

* Endif*

*EndIf*

*EndScript*

**

*You will see that I just moved the line Script SayCell() up 3 lines so that it is before *

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

**

*That is the only change needed but now you need to compile and save the
file.*

*When you open the jaws script manager using JawsKey and zero Jaws automatically creates a copy of the excel scripts in your personal folder and this is where jaws looks for scripts first so it will pick up any new or modified scripts.*

*To invoke the compile and save you simply press control and the letter S. Jaws will announce compile complete you can then use alt F4 to close the script manager. *

Your changes will take effect immediately.

If you want to back out of the changes you can go to your jaws personal folders

c:\Users\userid\AppData \Roaming \Freedom Scientific\JAWS\18.0\Settings\enu

here you can delete the excel.jsb and excel.jss files and you are good to go.

Regards

Tom Bisset

**

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner
*Sent:* Wednesday, June 07, 2017 12:44 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Modifying scripts for cell coordinates, was Excel bothers me How to customize it?

Tom,

To someone who is not a programmer, or doesn’t know the first thing about programming, this still is not terribly useful.

If you could give file names and specific instructions how to do this without screwing up the original scripts or how to safely back them up first, that would be very useful.

Or, maybe those of us who are completely clueless shouldn’t even monkey with this.

Richard

-----Original Message-----
From: main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] On Behalf Of Bissett, Tom
Sent: Wednesday, June 7, 2017 9:35 AM
To: main@jfw.groups.io <mailto:main@jfw.groups.io>
Subject: Re: Excel bothers me How to customize it?

This wasn't a new script but which script to change and how to change it. Adding a new script by the same name at the end won't fix it because jaws will just the first one.

I should have been more descriptive and said that you needed to locate the existing script and make the modification as shown in the example.

regards

Tom Bisset

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *Bissett, Tom
*Sent:* Wednesday, June 7, 2017 7:39 AM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

The only way I can find to change the order is by changing the script.
Below is the script

*Script SayCell()*

*If OnSpreadSheet()*

*&& !OnFormulaBar() then*

* SayCell()*

* if CellReadingVerbosity() == readCellContentsAndCoordinates then*

* SayActiveCellCoordinates()*

* Endif*

*; SayCell()*

*EndIf*

*EndScript*

I commented out the line

* SayCell()*

*And copied it And pasted it in the script just above the third “if”
statement as shown above *

Regards

Tom Bisset

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Tuesday, June 06, 2017 3:46 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

Richard,

Thank you, Do I have to do this for every spread sheet.?

I want to hear the coordenants before the contents not after. I want to hear A2, meadows plaza not Meadows plaza A2

I looked around and found the spot to turn off the coordinates but not how to reverse the order of what is spoken. Is this one of the advanced settings of the verbosity settings?

Thanks again

Shannon

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner
*Sent:* Tuesday, June 6, 2017 2:30 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Re: Excel bothers me How to customize it?

I can help you with the column headers, but I’m not sure why my coordinates speak after the data.

To set the column headers to read the way you want do the following:

One, Go to a1 and tap the alt key to bring up the upper ribbon and arrow to the formulas tab.

2. down arrow to the lower ribbon and right arrow to the Define Names tab.

3. Hit enter.

4. Hit alt+n to create a new name.

5. Write the word “title” without the quotes and hit enter.

6. tab to the close button and hit spacebar.

Now, when you arrow down a column, it will speak the contents of the cell, but if you right arrow or tab, you will hear the column title. As you down arrow, you will also hear the row title.

I hope that helps,

Richard

*From:*main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *Shannon
*Sent:* Tuesday, June 6, 2017 12:05 PM
*To:* main@jfw.groups.io <mailto:main@jfw.groups.io>
*Subject:* Excel bothers me How to customize it?

Hi all,

I use spread sheets every single day.

I have opened an excel sheet and when I am arrowing through it I am hearing things that are just…. Yucky!

1there is this annoying voice that speaks the cell coordinates.

I have futzed around with the voices so what I don’t know is which one of the voices is doing this. It is the same one that says the status of a message in Outlook un-read, forwarded and replied. And gives the erroneous indexes of the messages. (for some reason it always gives x of
44.)

2I don’t like hearing the contents and then the cell coordinates after.

I want to reverse the order. How can I do that?

3 How to make the entire first row column headers and have it only
report when I change columns? I don’t want to hear it when I stay in the same column.

Thanks

Shannon














.