Date
1 - 19 of 19
can't edit a formula in Excel ... again
|
Ann Byrne
the latest version of JAWS2018 and 2019 has broken the ability to edit a formula in an Excel spreadsheet ... again. the fix in earlier versions of JAWS was to modify the JAWS Excel settings, insert+number row 6. Go to text processing, general, Enhanced Edit Support, and be sure it was unchecked. Now, whether I check or uncheck enhanced edit support, I cannot edit a formula in Excel.
Does anyone know a way to do this? thanks, |
|
|
|
Ann,
toggle quoted message
Show quoted text
With focus on the cell with the formula, when I press the F2 function key, I'm able to edit the formula in Fusion 2019. Does this not work in JAWS? Alan Lemly -----Original Message-----
From: jaws-users-list@groups.io [mailto:jaws-users-list@groups.io] On Behalf Of Ann Byrne Sent: Thursday, December 20, 2018 10:14 PM To: jaws-users-list@groups.io Subject: [jaws-users] can't edit a formula in Excel ... again the latest version of JAWS2018 and 2019 has broken the ability to edit a formula in an Excel spreadsheet ... again. the fix in earlier versions of JAWS was to modify the JAWS Excel settings, insert+number row 6. Go to text processing, general, Enhanced Edit Support, and be sure it was unchecked. Now, whether I check or uncheck enhanced edit support, I cannot edit a formula in Excel. Does anyone know a way to do this? thanks, |
|
|
|
Justin Williams
Ps, it needs to be more graceful then this.
toggle quoted message
Show quoted text
Justin -----Original Message-----
From: jaws-users-list@groups.io [mailto:jaws-users-list@groups.io] On Behalf Of Ann Byrne Sent: Thursday, December 20, 2018 11:14 PM To: jaws-users-list@groups.io Subject: [jaws-users] can't edit a formula in Excel ... again the latest version of JAWS2018 and 2019 has broken the ability to edit a formula in an Excel spreadsheet ... again. the fix in earlier versions of JAWS was to modify the JAWS Excel settings, insert+number row 6. Go to text processing, general, Enhanced Edit Support, and be sure it was unchecked. Now, whether I check or uncheck enhanced edit support, I cannot edit a formula in Excel. Does anyone know a way to do this? thanks, |
|
|
|
Justin Williams
What I just did was when I het f2 with jaws 2019, I hit the home key to go
toggle quoted message
Show quoted text
to the beginning of the cell. Jaws will then read the formula if you go character by character. When you hit the home key, it will say the beginning of the formula and you can edit from there. Justin -----Original Message-----
From: jaws-users-list@groups.io [mailto:jaws-users-list@groups.io] On Behalf Of Ann Byrne Sent: Thursday, December 20, 2018 11:14 PM To: jaws-users-list@groups.io Subject: [jaws-users] can't edit a formula in Excel ... again the latest version of JAWS2018 and 2019 has broken the ability to edit a formula in an Excel spreadsheet ... again. the fix in earlier versions of JAWS was to modify the JAWS Excel settings, insert+number row 6. Go to text processing, general, Enhanced Edit Support, and be sure it was unchecked. Now, whether I check or uncheck enhanced edit support, I cannot edit a formula in Excel. Does anyone know a way to do this? thanks, |
|
|
|
Justin Williams
Oh, I didn't know that.
toggle quoted message
Show quoted text
So, we can't edit formulas? Justin -----Original Message-----
From: jaws-users-list@groups.io [mailto:jaws-users-list@groups.io] On Behalf Of Ann Byrne Sent: Thursday, December 20, 2018 11:14 PM To: jaws-users-list@groups.io Subject: [jaws-users] can't edit a formula in Excel ... again the latest version of JAWS2018 and 2019 has broken the ability to edit a formula in an Excel spreadsheet ... again. the fix in earlier versions of JAWS was to modify the JAWS Excel settings, insert+number row 6. Go to text processing, general, Enhanced Edit Support, and be sure it was unchecked. Now, whether I check or uncheck enhanced edit support, I cannot edit a formula in Excel. Does anyone know a way to do this? thanks, |
|
|
|
Justin Williams
Yes it does.
toggle quoted message
Show quoted text
Justin -----Original Message-----
From: jaws-users-list@groups.io [mailto:jaws-users-list@groups.io] On Behalf Of Alan Lemly Sent: Thursday, December 20, 2018 11:55 PM To: jaws-users-list@groups.io Subject: Re: [jaws-users] can't edit a formula in Excel ... again Ann, With focus on the cell with the formula, when I press the F2 function key, I'm able to edit the formula in Fusion 2019. Does this not work in JAWS? Alan Lemly -----Original Message----- From: jaws-users-list@groups.io [mailto:jaws-users-list@groups.io] On Behalf Of Ann Byrne Sent: Thursday, December 20, 2018 10:14 PM To: jaws-users-list@groups.io Subject: [jaws-users] can't edit a formula in Excel ... again the latest version of JAWS2018 and 2019 has broken the ability to edit a formula in an Excel spreadsheet ... again. the fix in earlier versions of JAWS was to modify the JAWS Excel settings, insert+number row 6. Go to text processing, general, Enhanced Edit Support, and be sure it was unchecked. Now, whether I check or uncheck enhanced edit support, I cannot edit a formula in Excel. Does anyone know a way to do this? thanks, |
|
|
|
george b
Hight the cell
toggle quoted message
Show quoted text
Press f2 In the edit field f2 takes you to edit the formulia -----Original Message-----
From: jaws-users-list@groups.io <jaws-users-list@groups.io> On Behalf Of Justin Williams Sent: December 21, 2018 5:20 To: jaws-users-list@groups.io Subject: Re: [jaws-users] can't edit a formula in Excel ... again Ps, it needs to be more graceful then this. Justin -----Original Message----- From: jaws-users-list@groups.io [mailto:jaws-users-list@groups.io] On Behalf Of Ann Byrne Sent: Thursday, December 20, 2018 11:14 PM To: jaws-users-list@groups.io Subject: [jaws-users] can't edit a formula in Excel ... again the latest version of JAWS2018 and 2019 has broken the ability to edit a formula in an Excel spreadsheet ... again. the fix in earlier versions of JAWS was to modify the JAWS Excel settings, insert+number row 6. Go to text processing, general, Enhanced Edit Support, and be sure it was unchecked. Now, whether I check or uncheck enhanced edit support, I cannot edit a formula in Excel. Does anyone know a way to do this? thanks, |
|
|
|
Ann Byrne
Nope. It does not. It did before the last update to JAWS 2019, but not since then.
toggle quoted message
Show quoted text
At 10:55 PM 12/20/2018, you wrote:
Ann, |
|
|
|
Ann Byrne
After pressing f2, when I try to move the cursor, JAWS reads the whole stinkin' formula, but does not move character by character to allow editing.
toggle quoted message
Show quoted text
At 07:22 AM 12/21/2018, you wrote:
Hight the cell |
|
|
|
Douglas C. DeCamp
Ann,
toggle quoted message
Show quoted text
This has been an ongoing problem for me for quite a while. It only affects certain cells based on their construction. The one thing that seems to fix this for me is: 1. In Excel - Select File menu 2. Select Options 3. select Advanced 4. Uncheck the box that says "Allow editing directly in the cell". This works for me. -- hth -- -----Original Message-----
From: jaws-users-list@groups.io <jaws-users-list@groups.io> On Behalf Of Ann Byrne Sent: Friday, December 21, 2018 8:15 AM To: jaws-users-list@groups.io Subject: Re: [jaws-users] can't edit a formula in Excel ... again Nope. It does not. It did before the last update to JAWS 2019, but not since then. At 10:55 PM 12/20/2018, you wrote: Ann,JAWS? it was unchecked. Now, whether I check or uncheck enhanced edit support, I cannot edit a |
|
|
|
Alan Robbins <arobbin2@...>
Ann,
toggle quoted message
Show quoted text
Not sure what else to suggest. Works fine here with the steps I sent you. Have you talked with Vispero regarding this? Al -----Original Message-----
From: jaws-users-list@groups.io <jaws-users-list@groups.io> On Behalf Of Ann Byrne Sent: Friday, December 21, 2018 9:15 AM To: jaws-users-list@groups.io Subject: Re: [jaws-users] can't edit a formula in Excel ... again Nope. It does not. It did before the last update to JAWS 2019, but not since then. At 10:55 PM 12/20/2018, you wrote: Ann,JAWS? it was unchecked. Now, whether I check or uncheck enhanced edit support, I cannot edit a |
|
|
|
Bob Hicks
Can you just replace the entire formula? I know this isn't an answer, just
toggle quoted message
Show quoted text
curious. Have a great day, 73 Bob Hicks, KC8CR Windows 7 and 10 home 64 bit -----Original Message-----
From: jaws-users-list@groups.io [mailto:jaws-users-list@groups.io] On Behalf Of Ann Byrne Sent: Friday, December 21, 2018 9:21 AM To: jaws-users-list@groups.io Subject: Re: [jaws-users] can't edit a formula in Excel ... again After pressing f2, when I try to move the cursor, JAWS reads the whole stinkin' formula, but does not move character by character to allow editing. At 07:22 AM 12/21/2018, you wrote: Hight the cellit was unchecked. Now, whether I check or uncheck enhanced edit support, I cannot edit a |
|
|
|
Ann Byrne
Yes. I can just replace the whole formula, but I *should be able to edit the stinker.
toggle quoted message
Show quoted text
Ann (WM9L) At 08:42 AM 12/21/2018, you wrote:
Can you just replace the entire formula? I know this isn't an answer, just |
|
|
|
Ann Byrne
Thank you. That does it!
toggle quoted message
Show quoted text
Ann At 08:26 AM 12/21/2018, you wrote:
Ann, |
|
|
|
Bob Hicks
Yes Mam! grin
toggle quoted message
Show quoted text
Have a great day, 73 Bob Hicks, KC8CR Windows 7 and 10 home 64 bit -----Original Message-----
From: jaws-users-list@groups.io [mailto:jaws-users-list@groups.io] On Behalf Of Ann Byrne Sent: Friday, December 21, 2018 9:53 AM To: jaws-users-list@groups.io Subject: Re: [jaws-users] can't edit a formula in Excel ... again Yes. I can just replace the whole formula, but I *should be able to edit the stinker. Ann (WM9L) At 08:42 AM 12/21/2018, you wrote: Can you just replace the entire formula? I know this isn't an answer,editing.
|
|
|
|
Annette Carr
I've been having this problem intermittently for years. I think I have
toggle quoted message
Show quoted text
picked up on a possible cause. If the length of the formula is wider than the cell width JAWS will not read the info, or just keeps repeating the entire formula. I've resorted to copying the cell contents and pasting them into Notepad, making the edit, copying the new formula and pasting it in the cell. Annette -----Original Message-----
From: jaws-users-list@groups.io <jaws-users-list@groups.io> On Behalf Of Ann Byrne Sent: Friday, December 21, 2018 9:21 AM To: jaws-users-list@groups.io Subject: Re: [jaws-users] can't edit a formula in Excel ... again After pressing f2, when I try to move the cursor, JAWS reads the whole stinkin' formula, but does not move character by character to allow editing. At 07:22 AM 12/21/2018, you wrote: Hight the cellit was unchecked. Now, whether I check or uncheck enhanced edit support, I cannot edit a |
|
|
|
K0LNY
I use an older version of Office, but sometimes when results also aren't
toggle quoted message
Show quoted text
displaying as they should, when there is a formula there, I select the column and use the applications key to adjust the cell width, and this fixes some things. Sometimes some columns wind up narrower than others, even when the data length is the same in all cells. Glenn ----- Original Message -----
From: "Annette Carr" <amcarr1@...> To: <jaws-users-list@groups.io> Sent: Friday, December 21, 2018 8:28 PM Subject: Re: [jaws-users] can't edit a formula in Excel ... again I've been having this problem intermittently for years. I think I have picked up on a possible cause. If the length of the formula is wider than the cell width JAWS will not read the info, or just keeps repeating the entire formula. I've resorted to copying the cell contents and pasting them into Notepad, making the edit, copying the new formula and pasting it in the cell. Annette -----Original Message----- From: jaws-users-list@groups.io <jaws-users-list@groups.io> On Behalf Of Ann Byrne Sent: Friday, December 21, 2018 9:21 AM To: jaws-users-list@groups.io Subject: Re: [jaws-users] can't edit a formula in Excel ... again After pressing f2, when I try to move the cursor, JAWS reads the whole stinkin' formula, but does not move character by character to allow editing. At 07:22 AM 12/21/2018, you wrote: Hight the cellit was unchecked. Now, whether I check or uncheck enhanced edit support, I cannot edit a |
|
|
|
Ann Byrne
Anette, did you see this from douglas DeCamp? It fixed the problem for me.
toggle quoted message
Show quoted text
1. In Excel - Select File menu 2. Select Options 3. select Advanced 4. Uncheck the box that says "Allow editing directly in the cell". This works for me. -- hth -- At 08:28 PM 12/21/2018, you wrote:
I've been having this problem intermittently for years. I think I have |
|
|
|
Terrie Terlau
Hello Ann,
toggle quoted message
Show quoted text
Thank you for reposting and thank Douglas for sharing this fix. I just did it and it works, thank Heavens. Terrie -----Original Message-----
From: jaws-users-list@groups.io <jaws-users-list@groups.io> On Behalf Of Ann Byrne Sent: Friday, December 21, 2018 11:57 PM To: jaws-users-list@groups.io Subject: Re: [jaws-users] can't edit a formula in Excel ... again Anette, did you see this from douglas DeCamp? It fixed the problem for me. 1. In Excel - Select File menu 2. Select Options 3. select Advanced 4. Uncheck the box that says "Allow editing directly in the cell". This works for me. -- hth -- At 08:28 PM 12/21/2018, you wrote: I've been having this problem intermittently for years. I think I haveediting.
|
|
|