Re: Paste Defined Name in Excel


Cearbhall O'Meadhra
 

Quentin,

 

I always thought that the Insert+F3 command was an NVDA command but I discovered to my surprise that it is actually an Excel command. It allows the user to paste the defined Name of their choice into an edit box or a single cell, etc. It is a really useful tool when editing.

 

 

All the best,

 

Cearbhall

 

m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@...

 

 

 

I use the free version of Spam Reader to get rid of spam. The Professional version doesn't have this disclaimer in outgoing emails. Try Spam Reader for free now!

 

 

From: nvda@nvda.groups.io [mailto:nvda@nvda.groups.io] On Behalf Of Quentin Christensen
Sent: Tuesday, July 18, 2017 10:01 AM
To: nvda@nvda.groups.io
Subject: Re: [nvda] Unable to Edit defined Name formula in Excel

 

You're welcome Cearbhall,

 

I know I've seen this issue with another edit box in Excel, but I can't find an issue about it.  In any case, I've created a new issue: https://github.com/nvaccess/nvda/issues/7416 and hopefully fixing one of these edit boxes will fix others.


Regards

 

Quentin.

 

On Tue, Jul 18, 2017 at 5:15 PM, Cearbhall O'Meadhra <cearbhall.omeadhra@...> wrote:

Quentin,

 

That was exactly what I needed!

 

When I press “alt+r” to edit the refers box while looking at the list of defined names, I took my time and pressed F2 first. I then pressed the left-arrow to move backwards through the details of the actual formula.  Prior to this, I would move the arrow keys immediately and I take your point that the focus changes so that I was getting other irrelevant edits suggestions.

 

I can edit the other two text fields without any problem so  now I can manage every field in the Names Dialog!

 

Great work!

 

 

All the best,

 

Cearbhall

 

m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@...

 

 

 

I use the free version of Spam Reader to get rid of spam. The Professional version doesn't have this disclaimer in outgoing emails. Try Spam Reader for free now!

 

 

From: nvda@nvda.groups.io [mailto:nvda@nvda.groups.io] On Behalf Of Quentin Christensen
Sent: Tuesday, July 18, 2017 3:04 AM
To:
nvda@nvda.groups.io
Subject: Re: [nvda] Unable to Edit defined Name formula in Excel

 

Hi Cearbhall,


I see what you mean.  There are a couple of other places in Excel that do that as well - Either the selected cells, or the current cell are listed in that "refers to" edit box, and all selected.  For some reason, in many of its edit boxes, when text is selected, all we can see is "blank".  When you get to that edit box, press F2 to go into edit mode, then press an arrow to unselect everything.  If you don't press F2 then as soon as you press an arrow, it will move the focus.

 

Another way of naming a cell or range, is to select either the cell or range you want to name, then press alt+f3, which takes you to the name box, you can then type a name and press ENTER.  Because that does it directly, it can be quicker, but also doesn't give you the list of existing names to check against first.  You can down arrow in the edit box and it will go through the existing names.  Pressing ENTER on any name will move the highlight to that named cell or range.

 

Regards


Quentin.

 

On Tue, Jul 18, 2017 at 7:16 AM, Cearbhall O'Meadhra <cearbhall.omeadhra@...> wrote:

Quentin,

 

I have been trying to setup a number of defined names in excel 2016 on windows 10 with the latest NVDA. I can edit all the parts of the defined name dialogue but not the “Refers to” part. This is like an old Wyziwyg editor in the bad old days!

 

I can capture the formula using the NVDA screen capture keys from the display of the formula under control-F3 and paste it into Notepad for amendment.

The only way I can edit it is to press alt-r and then mess around with the arrow keys until I get “Sheet1!a1 or something similar. This code is nothing like the actual formula that I would have put into the “Refers To” box and which I can see on the listing of the Defined name using control+F3. I backspace all of this until NVDA is silent. Then I go to my formula in Notepad -something like:

=”B” & Match(“Totals”, $B:$B , 0)

Which gives me the address of a particular cell that can move around as work proceeds on the sheet.

I then paste this formula blind into the “Refers to” edit field and tab to “Close” to save the edit. I can see the result in the listing under control-F3.

 

It would be so much easier if I could actually edit it in the edit box! Have you any solution to this?

 

 

All the best,

 

Cearbhall

 

m +353 (0)833323487 Ph: _353 (0)1-2864623 e: cearbhall.omeadhra@...

 

 



 

--

Quentin Christensen
Training and Support Manager

 

Basic Training for NVDA & Microsoft Word with NVDA E-Books now available: http://www.nvaccess.org/shop/

 

www.nvaccess.org 
Facebook: 
http://www.facebook.com/NVAccess 
Twitter: @NVAccess 



 

--

Quentin Christensen
Training and Support Manager

 

Basic Training for NVDA & Microsoft Word with NVDA E-Books now available: http://www.nvaccess.org/shop/

 

www.nvaccess.org 
Facebook: 
http://www.facebook.com/NVAccess 
Twitter: @NVAccess 

Join nvda@nvda.groups.io to automatically receive all group messages.