Date
1 - 9 of 9
reference function of Excel
Ngoc Ly <lyvanngoc@...>
Dear friends,
I am using jaws 12 and Excel 2003. When I use function of reference, I want to read the texts appear on screen. For example, in sheet1, cell b3 the text inside is “address”. I want the text in cell b3 of sheet1 appears at cell f5 of sheet 2. At cell f5, I type equal sign = then press ctrl+page up to sheet1. Then I move arrow to b3. Jaws says sheet1!b3 but doesn’t say the text “address” in b3. At that time, the text of sheet1 appears on cell f5 of sheet2. I can read the text by invisible cursor. My question is that if there is a keystroke for saying the text Thank you very much and Best luck Ngoc Ly lyvanngoc@... -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20120403/6b643405/attachment.html> |
|
Dave...
There is no JAWS keystroke involved in reading that text. If you can read
toggle quoted message
Show quoted text
the text on sheet1 with JAWS you should still be able to read the reference text on sheet2. I think you need to enable reading formulas in JAWS to read formulas. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message -----
From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list" <jfw@...> Sent: Tuesday, April 03, 2012 06:09 Subject: reference function of Excel Dear friends, I am using jaws 12 and Excel 2003. When I use function of reference, I want to read the texts appear on screen. For example, in sheet1, cell b3 the text inside is “address”. I want the text in cell b3 of sheet1 appears at cell f5 of sheet 2. At cell f5, I type equal sign = then press ctrl+page up to sheet1. Then I move arrow to b3. Jaws says sheet1!b3 but doesn’t say the text “address” in b3. At that time, the text of sheet1 appears on cell f5 of sheet2. I can read the text by invisible cursor. My question is that if there is a keystroke for saying the text Thank you very much and Best luck Ngoc Ly lyvanngoc@... -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20120403/6b643405/attachment.html> _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com |
|
Ngoc Ly <lyvanngoc@...>
oh, I hope one day someone will make a script to read the reference text.
toggle quoted message
Show quoted text
Thank you very much Ngoc Ly lyvanngoc@... -----Original Message-----
From: Farfar, on a Roll Sent: Tuesday, April 03, 2012 8:39 PM To: The Jaws for Windows support list. Subject: Re: reference function of Excel There is no JAWS keystroke involved in reading that text. If you can read the text on sheet1 with JAWS you should still be able to read the reference text on sheet2. I think you need to enable reading formulas in JAWS to read formulas. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message ----- From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list" <jfw@...> Sent: Tuesday, April 03, 2012 06:09 Subject: reference function of Excel Dear friends, I am using jaws 12 and Excel 2003. When I use function of reference, I want to read the texts appear on screen. For example, in sheet1, cell b3 the text inside is “address”. I want the text in cell b3 of sheet1 appears at cell f5 of sheet 2. At cell f5, I type equal sign = then press ctrl+page up to sheet1. Then I move arrow to b3. Jaws says sheet1!b3 but doesn’t say the text “address” in b3. At that time, the text of sheet1 appears on cell f5 of sheet2. I can read the text by invisible cursor. My question is that if there is a keystroke for saying the text Thank you very much and Best luck Ngoc Ly lyvanngoc@... -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20120403/6b643405/attachment.html> _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com |
|
Dave...
Scott,
toggle quoted message
Show quoted text
You do not need a script to read it. I have no problems reading reference text, and have been able to do so several JAWS versions back. I think your problem is that you need to set JAWS to read formulas, or to make sure that you are reading the formula bar in the Excel options. This is a setup problem with your Excel and not a limitation of JAWS. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message -----
From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list." <jfw@...> Sent: Tuesday, April 03, 2012 06:50 Subject: Re: reference function of Excel oh, I hope one day someone will make a script to read the reference text. Thank you very much Ngoc Ly lyvanngoc@... -----Original Message----- From: Farfar, on a Roll Sent: Tuesday, April 03, 2012 8:39 PM To: The Jaws for Windows support list. Subject: Re: reference function of Excel There is no JAWS keystroke involved in reading that text. If you can read the text on sheet1 with JAWS you should still be able to read the reference text on sheet2. I think you need to enable reading formulas in JAWS to read formulas. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message ----- From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list" <jfw@...> Sent: Tuesday, April 03, 2012 06:09 Subject: reference function of Excel Dear friends, I am using jaws 12 and Excel 2003. When I use function of reference, I want to read the texts appear on screen. For example, in sheet1, cell b3 the text inside is “address”. I want the text in cell b3 of sheet1 appears at cell f5 of sheet 2. At cell f5, I type equal sign = then press ctrl+page up to sheet1. Then I move arrow to b3. Jaws says sheet1!b3 but doesn’t say the text “address” in b3. At that time, the text of sheet1 appears on cell f5 of sheet2. I can read the text by invisible cursor. My question is that if there is a keystroke for saying the text Thank you very much and Best luck Ngoc Ly lyvanngoc@... -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20120403/6b643405/attachment.html> _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com |
|
Ngoc Ly <lyvanngoc@...>
Hi friend,
toggle quoted message
Show quoted text
Whenever I want to read the formular bar, I press f2. is there another way to read the formular bar? Ngoc Ly lyvanngoc@... -----Original Message-----
From: Farfar, on a Roll Sent: Tuesday, April 03, 2012 9:20 PM To: The Jaws for Windows support list. Subject: Re: reference function of Excel Scott, You do not need a script to read it. I have no problems reading reference text, and have been able to do so several JAWS versions back. I think your problem is that you need to set JAWS to read formulas, or to make sure that you are reading the formula bar in the Excel options. This is a setup problem with your Excel and not a limitation of JAWS. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message ----- From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list." <jfw@...> Sent: Tuesday, April 03, 2012 06:50 Subject: Re: reference function of Excel oh, I hope one day someone will make a script to read the reference text. Thank you very much Ngoc Ly lyvanngoc@... -----Original Message----- From: Farfar, on a Roll Sent: Tuesday, April 03, 2012 8:39 PM To: The Jaws for Windows support list. Subject: Re: reference function of Excel There is no JAWS keystroke involved in reading that text. If you can read the text on sheet1 with JAWS you should still be able to read the reference text on sheet2. I think you need to enable reading formulas in JAWS to read formulas. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message ----- From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list" <jfw@...> Sent: Tuesday, April 03, 2012 06:09 Subject: reference function of Excel Dear friends, I am using jaws 12 and Excel 2003. When I use function of reference, I want to read the texts appear on screen. For example, in sheet1, cell b3 the text inside is “address”. I want the text in cell b3 of sheet1 appears at cell f5 of sheet 2. At cell f5, I type equal sign = then press ctrl+page up to sheet1. Then I move arrow to b3. Jaws says sheet1!b3 but doesn’t say the text “address” in b3. At that time, the text of sheet1 appears on cell f5 of sheet2. I can read the text by invisible cursor. My question is that if there is a keystroke for saying the text Thank you very much and Best luck Ngoc Ly lyvanngoc@... -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20120403/6b643405/attachment.html> _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com |
|
Dave...
Ngoc,
toggle quoted message
Show quoted text
Okay, I think I may have thought of something. First to make sure I understand: You hear sheet1!B3 and you want to hear address. Is that correct? Well, what you are hearing is the actual formula and not the result, as you explained. There is a setting in Excel that turns off formula detection. I believe that it is a keystroke. Unfortunately I no longer have Excel 2003 and things are different now on 2007. In fact, I have sometimes pressed this key combination by accident and it is very irritating. So I hope someone has the answer so I can try to remember for myself next time it occurs. But you should be able to find a help file to explain how to turn off the formula display mode so that you do not hear the formula, but just the result. I do not think there is a JAWS setting that affects this. I think it is all in the Excel setup. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message -----
From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list." <jfw@...> Sent: Tuesday, April 03, 2012 07:35 Subject: Re: reference function of Excel Hi friend, Whenever I want to read the formular bar, I press f2. is there another way to read the formular bar? Ngoc Ly lyvanngoc@... -----Original Message----- From: Farfar, on a Roll Sent: Tuesday, April 03, 2012 9:20 PM To: The Jaws for Windows support list. Subject: Re: reference function of Excel Scott, You do not need a script to read it. I have no problems reading reference text, and have been able to do so several JAWS versions back. I think your problem is that you need to set JAWS to read formulas, or to make sure that you are reading the formula bar in the Excel options. This is a setup problem with your Excel and not a limitation of JAWS. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message ----- From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list." <jfw@...> Sent: Tuesday, April 03, 2012 06:50 Subject: Re: reference function of Excel oh, I hope one day someone will make a script to read the reference text. Thank you very much Ngoc Ly lyvanngoc@... -----Original Message----- From: Farfar, on a Roll Sent: Tuesday, April 03, 2012 8:39 PM To: The Jaws for Windows support list. Subject: Re: reference function of Excel There is no JAWS keystroke involved in reading that text. If you can read the text on sheet1 with JAWS you should still be able to read the reference text on sheet2. I think you need to enable reading formulas in JAWS to read formulas. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message ----- From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list" <jfw@...> Sent: Tuesday, April 03, 2012 06:09 Subject: reference function of Excel Dear friends, I am using jaws 12 and Excel 2003. When I use function of reference, I want to read the texts appear on screen. For example, in sheet1, cell b3 the text inside is “address”. I want the text in cell b3 of sheet1 appears at cell f5 of sheet 2. At cell f5, I type equal sign = then press ctrl+page up to sheet1. Then I move arrow to b3. Jaws says sheet1!b3 but doesn’t say the text “address” in b3. At that time, the text of sheet1 appears on cell f5 of sheet2. I can read the text by invisible cursor. My question is that if there is a keystroke for saying the text Thank you very much and Best luck Ngoc Ly lyvanngoc@... -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20120403/6b643405/attachment.html> _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com |
|
Dave...
Ngoc,
toggle quoted message
Show quoted text
Found what I think solves your problem. There is an Excel keystroke Ctrl+~ (the grave accent / tilde key left of the #1) that turns on/off formula mode. Try it. If that doesn't work, then another keystroke offered by Excel help is Ctrl+' For Excel 2007 the hotkey command to toggle this is Alt+m, then h. However I do not know the equivalent Alt hotkey combination in Excel 2003 -- perhaps it's the same? Have fun! Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message -----
From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list." <jfw@...> Sent: Tuesday, April 03, 2012 07:35 Subject: Re: reference function of Excel Hi friend, Whenever I want to read the formular bar, I press f2. is there another way to read the formular bar? Ngoc Ly lyvanngoc@... -----Original Message----- From: Farfar, on a Roll Sent: Tuesday, April 03, 2012 9:20 PM To: The Jaws for Windows support list. Subject: Re: reference function of Excel Scott, You do not need a script to read it. I have no problems reading reference text, and have been able to do so several JAWS versions back. I think your problem is that you need to set JAWS to read formulas, or to make sure that you are reading the formula bar in the Excel options. This is a setup problem with your Excel and not a limitation of JAWS. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message ----- From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list." <jfw@...> Sent: Tuesday, April 03, 2012 06:50 Subject: Re: reference function of Excel oh, I hope one day someone will make a script to read the reference text. Thank you very much Ngoc Ly lyvanngoc@... -----Original Message----- From: Farfar, on a Roll Sent: Tuesday, April 03, 2012 8:39 PM To: The Jaws for Windows support list. Subject: Re: reference function of Excel There is no JAWS keystroke involved in reading that text. If you can read the text on sheet1 with JAWS you should still be able to read the reference text on sheet2. I think you need to enable reading formulas in JAWS to read formulas. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message ----- From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list" <jfw@...> Sent: Tuesday, April 03, 2012 06:09 Subject: reference function of Excel Dear friends, I am using jaws 12 and Excel 2003. When I use function of reference, I want to read the texts appear on screen. For example, in sheet1, cell b3 the text inside is “address”. I want the text in cell b3 of sheet1 appears at cell f5 of sheet 2. At cell f5, I type equal sign = then press ctrl+page up to sheet1. Then I move arrow to b3. Jaws says sheet1!b3 but doesn’t say the text “address” in b3. At that time, the text of sheet1 appears on cell f5 of sheet2. I can read the text by invisible cursor. My question is that if there is a keystroke for saying the text Thank you very much and Best luck Ngoc Ly lyvanngoc@... -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20120403/6b643405/attachment.html> _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com |
|
Ann Byrne
Insert+numbpad 5 should read the text in a cell.
toggle quoted message
Show quoted text
At 08:50 AM 4/3/2012, you wrote:
oh, I hope one day someone will make a script to read the reference text. Thank you very much Ngoc Ly lyvanngoc@... -----Original Message----- From: Farfar, on a Roll Sent: Tuesday, April 03, 2012 8:39 PM To: The Jaws for Windows support list. Subject: Re: reference function of Excel There is no JAWS keystroke involved in reading that text. If you can read the text on sheet1 with JAWS you should still be able to read the reference text on sheet2. I think you need to enable reading formulas in JAWS to read formulas. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message ----- |
|
Ngoc Ly <lyvanngoc@...>
hi Dave,
toggle quoted message
Show quoted text
follow my example please... 1. open a new Excel file 2. at sheet 1, b3, type in: address 3. move to sheet3, f5 4. type "=" to start a function 5. ctrl+page up twice, move down arrow, you can hear Jaws says =sheet1!a2 then move to sheet1!b3 6. Sighted users can see the word "address" you typed in sheet1 appear in cell f5 of sheet3 but jaws doesn't say the text. 7: use jaws cursor or invisible cursor, jaws can read the text in sheet1,b3 8, move invisible or jaws cursor to the word "address" then route pc to invisible 9. press enter, insertion point is at f6. press up arrow, you can hear jaws say: address My question is if there is a keystroke for us to read the text of sheet1,b3 while we are opening sheet3,f5. It'll be very helpful for blind users for they don't have to remember well the position of various sheet cell while they are using function of reference in Excel. thank you Ngoc Ly lyvanngoc@... -----Original Message-----
From: Farfar, on a Roll Sent: Tuesday, April 03, 2012 10:42 PM To: The Jaws for Windows support list. Subject: Re: reference function of Excel Ngoc, Okay, I think I may have thought of something. First to make sure I understand: You hear sheet1!B3 and you want to hear address. Is that correct? Well, what you are hearing is the actual formula and not the result, as you explained. There is a setting in Excel that turns off formula detection. I believe that it is a keystroke. Unfortunately I no longer have Excel 2003 and things are different now on 2007. In fact, I have sometimes pressed this key combination by accident and it is very irritating. So I hope someone has the answer so I can try to remember for myself next time it occurs. But you should be able to find a help file to explain how to turn off the formula display mode so that you do not hear the formula, but just the result. I do not think there is a JAWS setting that affects this. I think it is all in the Excel setup. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message ----- From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list." <jfw@...> Sent: Tuesday, April 03, 2012 07:35 Subject: Re: reference function of Excel Hi friend, Whenever I want to read the formular bar, I press f2. is there another way to read the formular bar? Ngoc Ly lyvanngoc@... -----Original Message----- From: Farfar, on a Roll Sent: Tuesday, April 03, 2012 9:20 PM To: The Jaws for Windows support list. Subject: Re: reference function of Excel Scott, You do not need a script to read it. I have no problems reading reference text, and have been able to do so several JAWS versions back. I think your problem is that you need to set JAWS to read formulas, or to make sure that you are reading the formula bar in the Excel options. This is a setup problem with your Excel and not a limitation of JAWS. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message ----- From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list." <jfw@...> Sent: Tuesday, April 03, 2012 06:50 Subject: Re: reference function of Excel oh, I hope one day someone will make a script to read the reference text. Thank you very much Ngoc Ly lyvanngoc@... -----Original Message----- From: Farfar, on a Roll Sent: Tuesday, April 03, 2012 8:39 PM To: The Jaws for Windows support list. Subject: Re: reference function of Excel There is no JAWS keystroke involved in reading that text. If you can read the text on sheet1 with JAWS you should still be able to read the reference text on sheet2. I think you need to enable reading formulas in JAWS to read formulas. Dave Carlson Tastefully composed and transmitted from somewhere in the Western United States, using a Dell Latitude E6520 and Windows 7 ----- Original Message ----- From: "Ngoc Ly" <lyvanngoc@...> To: "The Jaws for Windows support list" <jfw@...> Sent: Tuesday, April 03, 2012 06:09 Subject: reference function of Excel Dear friends, I am using jaws 12 and Excel 2003. When I use function of reference, I want to read the texts appear on screen. For example, in sheet1, cell b3 the text inside is “address”. I want the text in cell b3 of sheet1 appears at cell f5 of sheet 2. At cell f5, I type equal sign = then press ctrl+page up to sheet1. Then I move arrow to b3. Jaws says sheet1!b3 but doesn’t say the text “address” in b3. At that time, the text of sheet1 appears on cell f5 of sheet2. I can read the text by invisible cursor. My question is that if there is a keystroke for saying the text Thank you very much and Best luck Ngoc Ly lyvanngoc@... -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20120403/6b643405/attachment.html> _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list Jfw@... http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com |
|