Re: recommended version of JAWS for use with Windows 10?
Lisle, Ted (CHFS DMS)
Get the latest version of 16 or later. I understand that both 16 and 17 received final tweaks to make them work better with 10.
toggle quoted messageShow quoted text
Ted
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Jessica D Sent: Thursday, June 08, 2017 8:40 AM To: main@jfw.groups.io Subject: recommended version of JAWS for use with Windows 10? Hi, I'm using Windows 10 on my mac via bootcamp. I'd like to know what version of Jaws is recommended for this setup. Also, I don't want the tandum feature, should I keep the regular version of JAWS or uninstall it, and install the non-tandum version? Thanks, from a new member, Jessica Sent from my iPhone
|
|
Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?
Paul Hunt <prhunt1@...>
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.
toggle quoted messageShow quoted text
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@...] 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@...] 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@...] 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 .
|
|
Free JAWS script downloads
Vic Beckley
Hi all,
Is there a website where you can download third-party scripts for JAWS that people have made available free? Thanks for any info! Best Regards From Ohio, Vic
|
|
Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?
Mario
I don't have enough knowledge to actually tinker and correctly make
toggle quoted messageShow quoted text
adjustments, but I do know some stuff about scripting. for example, the script that Tom offered has simple if/then/else and say statements that I could figure out, but anything more involved, forget it. I get lost. sometimes I get lost with the simple stuff too. for example, the SayCell script does not have a shortcut assigned to it, and yet it is designated as a script that is to be activated with a shortcut. is it a deprecated script that no longer is needed since it's not assigned to a shortcut, or does it serve a purpose for being there. if it is deprecated, shouldn't it be removed (why is it still there if it is deprecated)? I wish I could find someone to teach me what I'd need to learn in order to write effective scripts for JAWS. I mean really good scripting. I guess I would need to start with the basic concepts of programming because I'm not a programmer and I believe it is really necessary to understand the concepts before writing/troubleshooting scripts for JAWS. just look at the script source file for Winamp, that's an example of what I consider true scripting (and the kind of scripting I'd want to eventually be able to do).
-------- Original Message --------
From: Shannon [mailto:shannon@...] Sent: Thursday, Jun 8, 2017 9:46 AM EST To: main@jfw.groups.io Subject: Modifying scripts for cell coordinates, was Excel bothers me How to customize it? Mario, I think you are on to something here. How much of this stuff do you know? I don't know anything about scripts at all. Are the actions of the navigation keys arrows, enter and tab defined in this script or are they defined somewhere else? Is It part of that Verbosity setting? Is verbosity something we mere mortals can reach? Seems like a small thing but I really think it should be a choice. Just like when you are hearing LINK I prefer to hear that after the text of the link and not at all during read to end or say all. It is a preference. Is this one of those things that we have to report as a feature request or can we fix it on our own? Have a wonderful day. Shannon -----Original Message----- From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario Sent: Wednesday, June 7, 2017 3:46 PM To: main@jfw.groups.io Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it? hold on. I just realized something, this script is tied to a keystroke, which doesn't have a shortcut. but anyway, shouldn't it be a function that needs to be modified because Shannon and I, and others who might want the same thing, want the cell coordinates to be spoken before it's contents while navigating from cell to cell using the arrow keys? if not, please explain why. -------- Original Message -------- From: Mario [mailto:mrb620@...] Sent: Wednesday, Jun 7, 2017 4:20 PM EST To: main@jfw.groups.io Subject: 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@...] 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@...] 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 . .
|
|
recommended version of JAWS for use with Windows 10?
Jessica D <jldail13@...>
Hi,
I'm using Windows 10 on my mac via bootcamp. I'd like to know what version of Jaws is recommended for this setup. Also, I don't want the tandum feature, should I keep the regular version of JAWS or uninstall it, and install the non-tandum version? Thanks, from a new member, Jessica Sent from my iPhone
|
|
Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?
Mario
I don't understand why the cell contents are announced before the
toggle quoted messageShow quoted text
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@...] 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@...] 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@...] 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
OH! Tom!
toggle quoted messageShow quoted text
You mean there is still hope? I am getting so excited! You have successfully tweaked it before and it worked? I didn't realize that you did have it working the way we are describing. I thought you were trying this out for us who wanted the change. That means the answer is not that far off if you did it before we should be able to find it again! Good luck!!! Have you done lots of tweaking to your JAWS excel script? Could we just copy paste your entire text file into our own and recompile it for ourselves Thanks ever so much for looking.
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Bissett, Tom Sent: Thursday, June 8, 2017 8:52 AM To: main@jfw.groups.io Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it? My appologies to all. I have made changes to my excel scripts and thought this was where I had changed it to speak coordinates first. I will have to look further to recall what I changed. I will hopefully have something in the next little while. Regards Tom Bisset -----Original Message----- From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Shannon Sent: Thursday, June 08, 2017 9:46 AM To: main@jfw.groups.io Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it? Mario, I think you are on to something here. How much of this stuff do you know? I don't know anything about scripts at all. Are the actions of the navigation keys arrows, enter and tab defined in this script or are they defined somewhere else? Is It part of that Verbosity setting? Is verbosity something we mere mortals can reach? Seems like a small thing but I really think it should be a choice. Just like when you are hearing LINK I prefer to hear that after the text of the link and not at all during read to end or say all. It is a preference. Is this one of those things that we have to report as a feature request or can we fix it on our own? Have a wonderful day. Shannon -----Original Message----- From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario Sent: Wednesday, June 7, 2017 3:46 PM To: main@jfw.groups.io Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it? hold on. I just realized something, this script is tied to a keystroke, which doesn't have a shortcut. but anyway, shouldn't it be a function that needs to be modified because Shannon and I, and others who might want the same thing, want the cell coordinates to be spoken before it's contents while navigating from cell to cell using the arrow keys? if not, please explain why. -------- Original Message -------- From: Mario [mailto:mrb620@...] Sent: Wednesday, Jun 7, 2017 4:20 PM EST To: main@jfw.groups.io Subject: 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@...] 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@...] 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
Ted,
toggle quoted messageShow quoted text
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.
|
|
Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?
Bissett, Tom <tom.bissett@...>
My appologies to all. I have made changes to my excel scripts and thought this was where I had changed it to speak coordinates first. I will have to look further to recall what I changed. I will hopefully have something in the next little while.
toggle quoted messageShow quoted text
Regards Tom Bisset
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Shannon Sent: Thursday, June 08, 2017 9:46 AM To: main@jfw.groups.io Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it? Mario, I think you are on to something here. How much of this stuff do you know? I don't know anything about scripts at all. Are the actions of the navigation keys arrows, enter and tab defined in this script or are they defined somewhere else? Is It part of that Verbosity setting? Is verbosity something we mere mortals can reach? Seems like a small thing but I really think it should be a choice. Just like when you are hearing LINK I prefer to hear that after the text of the link and not at all during read to end or say all. It is a preference. Is this one of those things that we have to report as a feature request or can we fix it on our own? Have a wonderful day. Shannon -----Original Message----- From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario Sent: Wednesday, June 7, 2017 3:46 PM To: main@jfw.groups.io Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it? hold on. I just realized something, this script is tied to a keystroke, which doesn't have a shortcut. but anyway, shouldn't it be a function that needs to be modified because Shannon and I, and others who might want the same thing, want the cell coordinates to be spoken before it's contents while navigating from cell to cell using the arrow keys? if not, please explain why. -------- Original Message -------- From: Mario [mailto:mrb620@...] Sent: Wednesday, Jun 7, 2017 4:20 PM EST To: main@jfw.groups.io Subject: 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@...] 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@...] 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
Mario,
toggle quoted messageShow quoted text
I think you are on to something here. How much of this stuff do you know? I don't know anything about scripts at all. Are the actions of the navigation keys arrows, enter and tab defined in this script or are they defined somewhere else? Is It part of that Verbosity setting? Is verbosity something we mere mortals can reach? Seems like a small thing but I really think it should be a choice. Just like when you are hearing LINK I prefer to hear that after the text of the link and not at all during read to end or say all. It is a preference. Is this one of those things that we have to report as a feature request or can we fix it on our own? Have a wonderful day. Shannon
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario Sent: Wednesday, June 7, 2017 3:46 PM To: main@jfw.groups.io Subject: Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it? hold on. I just realized something, this script is tied to a keystroke, which doesn't have a shortcut. but anyway, shouldn't it be a function that needs to be modified because Shannon and I, and others who might want the same thing, want the cell coordinates to be spoken before it's contents while navigating from cell to cell using the arrow keys? if not, please explain why. -------- Original Message -------- From: Mario [mailto:mrb620@...] Sent: Wednesday, Jun 7, 2017 4:20 PM EST To: main@jfw.groups.io Subject: 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@...] 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@...] 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?
Lisle, Ted (CHFS DMS)
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."
toggle quoted messageShow quoted text
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.
|
|
Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?
Richard Turner <richardturner42@...>
And, you could change that easily in the Window-Eyes settings.
toggle quoted messageShow quoted text
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.
|
|
Re: running a dos program
Lisle, Ted (CHFS DMS)
I found out years ago that some DOS programs don't run well in a DOS window, so I can't say whether or not the Motorola software will work. However, as indicated, full command capability remains. I still use it when I want something quick and easy.
toggle quoted messageShow quoted text
Ted
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Sieghard Weitzel Sent: Wednesday, June 07, 2017 8:11 PM To: main@jfw.groups.io Subject: Re: running a dos program Any version of Windows including Windows 10 will give you a command prompt, just type "cmd" into the run command. -----Original Message----- From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Jed Barton Sent: Wednesday, June 07, 2017 3:11 PM To: main@jfw.groups.io Subject: running a dos program Hey guys, OK, this may seem like i'm going back to the dark ages, and OK, yeah it sure is. I have to program some radios, and typical motorola they actually have some dos software. Is there any sort of program that can give me a dos prommpt so i can run the software? If not, that's totally ok. Figured i would ask, if jaws 18 would even run with such a program.
|
|
Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?
Carol Smith
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.
toggle quoted messageShow quoted text
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.
|
|
Re: Modifying scripts for cell coordinates, was Excel bothers me How to customize it?
Lisle, Ted (CHFS DMS)
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.
toggle quoted messageShow quoted text
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@...] 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@...] 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: Making English the only language?
Tyler Spivey
These are languages in Windows.
toggle quoted messageShow quoted text
I assume you're on Windows 10. Try this to remove extra languages: 1. Press windows+i to open Settings. 2. tab and find Time & language in the list. Press enter. 3. Find Region & language, press enter. 4. in the list of languages, press enter on one and remove it by pressing the Remove button.
On 6/6/2017 8:14 AM, David & his pack of dogs wrote:
I know this question has probably been already asked and answered but,
|
|
Re: running a dos program
Michelle's Home Emails
Hi Sieghard meant to say Jed not yourselfApologies. Michelle
|
|
Re: running a dos program
Soronel Haetir
Umm, you only need an admin cmd prompt if you intend to run admin-only
toggle quoted messageShow quoted text
actions. There are plenty of things you can do with a normal-user prompt.
On 6/7/17, Michelle's Home Emails <m1stevens@...> wrote:
Hi there Sieghard --
Soronel Haetir soronel.haetir@...
|
|
Re: A program that duplicates what is on the screen?
Soronel Haetir
If you are using remote assistance over anything but a local network
toggle quoted messageShow quoted text
sound is simply very likely to be delayed. I am not aware of any way to improve this. (The jaws remote access option gets around this problem by sending accessibility events rather than audio and having the audio then rendered on the client system, but this is not practical for most remote assistance situations as it requires jaws on both ends of the connection). Even switching to lower quality voices isn't likely to help as by the time the sound information is being sent it has already been rendered to a full-quality audio stream.
On 6/7/17, Carolyn Arnold <4carolyna@...> wrote:
Jim says that same thing, that he can't see what I'm talking --
Soronel Haetir soronel.haetir@...
|
|
Re: running a dos program
Michelle's Home Emails
Hi there Sieghard
toggle quoted messageShow quoted text
What about command prompt to access this you will need to open it with admin privileges. " Michelle Sent from Michelle's iPhone
On 8 Jun 2017, at 10:10 am, Sieghard Weitzel <sieghard@...> wrote:
|
|