Re: to change announcement of cell content and coordinates to coordinates and cell content


John Martyn
 

This is a way over complicated approach to what you need to do. Just use a use statement at the top of the script in order to import the XL.JSS file into your new script and it will automatically. Towards that script no matter where the location is. Thanks Johnny Martyn

On Thu, Jul 6, 2017 at 3:40 PM Carolyn Arnold <4carolyna@...> wrote:
Remember back when we had to reset the time on our computers
when the time changed?



Best from,

Carolyn
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On
Behalf Of Mario
Sent: Thursday, July 6, 2017 12:28 PM
To: main@jfw.groups.io
Subject: Re: to change announcement of cell content and
coordinates to coordinates and cell content

so, nothing for JAWS 16, not even a work around. shucks.
well... thanks for your effort. if you do hear of a way to
do it for JAWS 16, please do let me know.


-------- Original Message --------
From: Bissett, Tom [mailto:tom.bissett@...]
Sent: Wednesday, Jul 5, 2017 2:50 PM EST
To: main@jfw.groups.io
Subject: to change announcement of cell content and
coordinates to
coordinates and cell content

Hi,  here it is.  this only applies to jaws 17 and 18.
Earlier version
of jaws doesn't give us access to the source code we need.
I do not have win 10 so I can't be sure whether the path to
the file is
the same as win 7.  These instructions are put together
using win 7.

to change announcement of cell content and coordinates to
coordinates
and cell content do the following

1.        Copy the excelFunc.jss file from
"C:\ProgramData\Freedom Scientific\JAWS\17.0\Scripts\"
And paste in to
"C:\Users\your user Id\AppData\Roaming\Freedom
Scientific\JAWS\18.0\Settings\enu\"

2.        Open excel

3.       Press JawsKey + 0 on the number row to open the
script manager
with the excel script loaded.

4.       Press control + O to open the list of files, it is
a standered
dialogue

5.       Look for the file ExcelFunc.jss and press enter.
This will
bring up the script set we want to work with.

6.       Search for ReadActiveCell, it should be the second
occurrence.
The line should read void function ReadActiveCell(optional
int
bForceReadCoordinates)

7.       Here we are going to cut and paste the following
line
SayCellText(cXLActiveCell.text) which should be the next
line

8.       Move 12 lines down press enter for a new line and
paste the
line you cut in there.  The script should look like the
following:

void function ReadActiveCell(optional int
bForceReadCoordinates)
if cXLActiveCell.mergeCells
&& MergedCellsAnnounce() then

SayFormattedMessageWithVoice(vctx_message,ot_JAWS_message,ms
gMergedCells,cmsgSilent)
EndIf
SayObjectCellInfo(oXLActiveCell)
if CellReadingVerbosity() == readCellContentsAndCoordinates
||
bForceReadCoordinates then
     if cXLActiveCell.mergeCells then
        SaySelectedRange(true)
     else
        SayCellCoordinates(cXLActiveCell,ot_position)
     endIf
endIf
SayCellText(cXLActiveCell.text)
if NumberFormatVerbosity () then
     DetectActiveCellFormatChange()
EndIf
if CellBorderVerbosity() then
     detectActiveCellBorderChange()
EndIf
if cXLActiveCell.ContainsErrors then
     sayMessage (OT_ERROR, msgCellContainsErrors)
endIf
EndFunction


9.       Press control + S to compile the script

10.   Close the jaws script manager with alt + F4

In the event you wish to change back to the original
navigate to
"C:\Users\your user Id\AppData\Roaming\Freedom
Scientific\JAWS\18.0\Settings\enu\"
And delete the ExcelFunc.jsb file

I hope this helps
Regards
Tom Bisset










Join main@jfw.groups.io to automatically receive all group messages.